PTIARPTTSTMO_VW

index back

SELECT O.PTIASPRPTNO , O.OBJECTTYPE , I.DESCR254 , O.OBJECTVALUE1 , O.OBJECTVALUE2 , O.OBJECTVALUE3 , O.OBJECTVALUE4 , COUNT(R.PTIATESTNAME) FROM PS_PTIATESTOBJREPO O , PS_PTIATESTREFREPO R , PS_PTIASPINTCODES I WHERE O.OBJECTTYPE=R.OBJECTTYPE (+) AND O.OBJECTTYPE=I.PTIASPINTVALUE AND I.PTIASPLOOKUPCODE = 'OBJTYPE' AND O.OBJECTVALUE1=R.OBJECTVALUE1 (+) AND O.OBJECTVALUE2=R.OBJECTVALUE2 (+) AND O.OBJECTVALUE3=R.OBJECTVALUE3 (+) AND O.OBJECTVALUE4=R.OBJECTVALUE4 (+) GROUP BY O.PTIASPRPTNO , O.OBJECTTYPE , I.DESCR254 , O.OBJECTVALUE1 , O.OBJECTVALUE2 , O.OBJECTVALUE3 , O.OBJECTVALUE4

PeopleSoft Field Name Field Type Column Type Description
PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number
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
PTIA_COUNTER Number(10,0) DECIMAL(10) NOT NULL PTIA Counter
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20