PTIAMOCUSTCNTVW

index back

SELECT A.OBJECTTYPE , A.OBJECTVALUE1 , A.OBJECTVALUE2 , A.OBJECTVALUE3 , A.OBJECTVALUE4 , COUNT(B.PTIACUSTNAME) FROM PS_PTIAMOCUSTREPO A , PS_PTIAMOREFREPO B WHERE A.OBJECTTYPE=B.OBJECTTYPE(+) AND A.OBJECTVALUE1 = B.OBJECTVALUE1 (+) AND A.OBJECTVALUE2 = B.OBJECTVALUE2 (+) AND A.OBJECTVALUE3 = B.OBJECTVALUE3 (+) AND A.OBJECTVALUE4 = B.OBJECTVALUE4 (+) GROUP BY A.OBJECTTYPE , A.OBJECTVALUE1 , A.OBJECTVALUE2 , A.OBJECTVALUE3 , A.OBJECTVALUE4

PeopleSoft Field Name Field Type Column Type Description
OBJECTTYPE Number(5,0) INTEGER NOT NULL Object Type
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