PTIASPRPTPMOLVW

index back

PACKAGE MOL

This is the modified object list for all bugs in PACKAGE
SELECT DISTINCT PTIASPPKGGUID , OBJECTTYPE , DESCR254 , OBJECTVALUE1 , OBJECTVALUE2 , OBJECTVALUE3 , OBJECTVALUE4 FROM ( SELECT C.PTIASPPKGGUID , A.OBJECTTYPE , B.DESCR254 , A.OBJECTVALUE1 , A.OBJECTVALUE2 , A.OBJECTVALUE3 , A.OBJECTVALUE4 FROM PS_PTIASPRPTMOL A , PS_PTIASPINTCODES B , PS_PTIASPPKGBUGS C WHERE A.OBJECTTYPE = b.PTIASPINTVALUE AND B.PTIASPLOOKUPCODE = 'OBJTYPE' AND A.PTIASPRPTNO=C.PTIASPRPTNO UNION SELECT A.PTIASPPKGGUID , A.OBJECTTYPE , B.DESCR254 , A.OBJECTVALUE1 , A.OBJECTVALUE2 , A.OBJECTVALUE3 , A.OBJECTVALUE4 FROM PS_PTIASPDLTPKGMO A , PS_PTIASPINTCODES B WHERE A.OBJECTTYPE = b.PTIASPINTVALUE AND B.PTIASPLOOKUPCODE = 'OBJTYPE' )

PeopleSoft Field Name Field Type Column Type Description
PTIASPPKGGUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
OBJECTTYPE Number(5,0) INTEGER NOT NULL Object Type
DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
OBJECTVALUE1 Character(100) VARCHAR2(100) NOT NULL Object Value 1
OBJECTVALUE2 Character(100) VARCHAR2(100) NOT NULL Object Value 2
OBJECTVALUE3 Character(30) VARCHAR2(30) NOT NULL Object Value 3
OBJECTVALUE4 Character(30) VARCHAR2(30) NOT NULL Object Value 4
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20