PTIASPPRJITEMVW

(SQL View)
 Index Back

PACKAGE MOL

This is the modified object list for all bugs in PACKAGE

SELECT A.PTIASPPKGGUID , A.PROJECTNAME , A.OBJECTTYPE , B.DESCR254 , A.OBJECTVALUE1 , A.OBJECTVALUE2 , A.OBJECTVALUE3 , A.OBJECTVALUE4 , A.PTIA_COUNTER , C.PTIACUSTOMIZATION , %coalesce(( SELECT PTIAUMISUSED FROM PS_PTIAUMPMTAGR UM WHERE A.OBJECTTYPE = UM.OBJECTTYPE AND A.OBJECTVALUE1 = UM.OBJECTVALUE1 AND A.OBJECTVALUE2 = UM.OBJECTVALUE2 AND A.OBJECTVALUE3 = UM.OBJECTVALUE3 AND A.OBJECTVALUE4 = UM.OBJECTVALUE4), 'N' ) FROM PS_PTIASPPRJITEM A , PS_PTIASPINTCODES B , PS_PTIAMOCUSTREPO 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 PeopleSoft Field Type Database Column Type Description
1 PTIASPPKGGUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
2 PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).
3 OBJECTTYPE Number(5,0) INTEGER NOT NULL Object Type
4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
5 OBJECTVALUE1 Character(100) VARCHAR2(100) NOT NULL Object Value 1
6 OBJECTVALUE2 Character(100) VARCHAR2(100) NOT NULL Object Value 2
7 OBJECTVALUE3 Character(30) VARCHAR2(30) NOT NULL Object Value 3
8 OBJECTVALUE4 Character(30) VARCHAR2(30) NOT NULL Object Value 4
9 PTIA_COUNTER Number(10,0) DECIMAL(10) NOT NULL PTIA Counter
10 PTIACUSTOMIZATION Character(4) VARCHAR2(4) NOT NULL Is Customized
N== PPLSOFT
U=Unknown
Y=<> PPLSOFT
11 PTIASPRPTUSAGEFLAG Character(1) VARCHAR2(1) NOT NULL Is Used
N=Not Used
Y=Used