PTIARPTTSTMO_VW(SQL View) |
Index Back |
---|
SELECT O.PTIASPRPTNO , O.OBJECTTYPE , I.DESCR254 , O.OBJECTVALUE1 , O.OBJECTVALUE2 , O.OBJECTVALUE3 , O.OBJECTVALUE4 ,Coalesce((SELECT PTIAUMISUSED FROM PS_PTIAUMPMTAGR WHERE OBJECTTYPE = O.OBJECTTYPE AND OBJECTVALUE1 = O.OBJECTVALUE1 AND OBJECTVALUE2 = O.OBJECTVALUE2 AND OBJECTVALUE3 = O.OBJECTVALUE3 AND OBJECTVALUE4 = O.OBJECTVALUE4), 'N') , 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 | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PTIASPRPTNO | Number(10,0) | DECIMAL(10) NOT NULL | BUG Number |
2 | Number(5,0) | INTEGER NOT NULL | Object Type | |
3 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
4 | Character(100) | VARCHAR2(100) NOT NULL | Object Value 1 | |
5 | Character(100) | VARCHAR2(100) NOT NULL | Object Value 2 | |
6 | Character(30) | VARCHAR2(30) NOT NULL | Object Value 3 | |
7 | Character(30) | VARCHAR2(30) NOT NULL | Object Value 4 | |
8 | PTIASPRPTUSAGEFLAG | Character(1) | VARCHAR2(1) NOT NULL |
Is Used
N=Not Used Y=Used |
9 | PTIA_COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | PTIA Counter |