PTIASPRPTMOLVW

 index back

BUG MOL

This is the modified object list for each BUG
SELECT A.PTIASPRPTNO , A.OBJECTTYPE , B.DESCR254 , A.OBJECTID1 , A.OBJECTVALUE1 , A.OBJECTID2 , A.OBJECTVALUE2 , A.OBJECTID3 , A.OBJECTVALUE3 , A.OBJECTID4 , A.OBJECTVALUE4 , A.UPGRADEACTION , A.PTIASPUPGACTION , A.PTIASPTAKEACTION , NVL(C.PTIA_COUNTER , 0) FROM PS_PTIASPRPTMOL A , PS_PTIASPINTCODES B , PS_PTIAMOCUSTCNTVW C WHERE A.OBJECTTYPE = B.PTIASPINTVALUE AND B.PTIASPLOOKUPCODE = 'OBJTYPE' AND A.OBJECTTYPE = C.OBJECTTYPE (+) AND A.OBJECTVALUE1 = C.OBJECTVALUE1 (+) AND A.OBJECTVALUE2 = C.OBJECTVALUE2 (+) AND A.OBJECTVALUE3 = C.OBJECTVALUE3 (+) AND A.OBJECTVALUE4 = C.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
OBJECTID1 Number(5,0) INTEGER NOT NULL Object Id 1
1=Record
2=Field
3=Menu
4=Bar Name
5=Item Name
9=Page
10=Component
12=Event
20=Database Type
21=Effective Date
39=Market
60=Message
66=Application Engine Program
74=Component Interface
77=Section
78=Step
87=Subscription
104=Application Package
105=Class
106=Class
107=Class
OBJECTVALUE1 Character(100) VARCHAR2(100) NOT NULL Object Value 1
OBJECTID2 Number(5,0) INTEGER NOT NULL Object Id 2, as OBJECTID1
OBJECTVALUE2 Character(100) VARCHAR2(100) NOT NULL Object Value 2
OBJECTID3 Number(5,0) INTEGER NOT NULL Object Id 3, as OBJECTID1
OBJECTVALUE3 Character(30) VARCHAR2(30) NOT NULL Object Value 3
OBJECTID4 Number(5,0) INTEGER NOT NULL Object Id 4, as OBJECTID1
OBJECTVALUE4 Character(30) VARCHAR2(30) NOT NULL Object Value 4
UPGRADEACTION Number(1,0) SMALLINT NOT NULL Upgrade Action
PTIASPUPGACTION Character(1) VARCHAR2(1) NOT NULL Upgrade Action
0=Copy
1=Delete
2=None
3=Copy Property
PTIASPTAKEACTION Number(1,0) SMALLINT NOT NULL Take Upgrade Action
PTIA_COUNTER Number(10,0) DECIMAL(10) NOT NULL Customization Count
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20