PTIASP_SCOMP_VW

index back

SELECT PTIASPPRDID , PTIASPPRDCMP , PTIASPPRDCMPNM , ' ' , ' ' FROM PS_PTIASPPRDCOMP UNION SELECT S.PTIASPPRDID , S.PTIASPPRDCMP , C.PTIASPPRDCMPNM , S.PTIASPPRDSUBCMP , S.PTIASPPRDSUBCMPNM FROM PS_PTIASPPRDCOMP C , PS_PTIASPSUBCOMP S WHERE C.PTIASPPRDID=S.PTIASPPRDID AND C.PTIASPPRDCMP=S.PTIASPPRDCMP

PeopleSoft Field Name Field Type Column Type Description
PTIASPPRDID Number(8,0) INTEGER NOT NULL Product ID
PTIASPPRDCMP Character(10) VARCHAR2(10) NOT NULL Product Component
PTIASPPRDCMPNM Character(30) VARCHAR2(30) NOT NULL Product Component Name
PTIASPPRDSUBCMP Character(14) VARCHAR2(14) NOT NULL Product Sub Component
PTIASPPRDSUBCMPNM Character(40) VARCHAR2(40) NOT NULL Product Sub Component
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20