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 OBJECTTYPE Number(5,0) INTEGER NOT NULL Object Type
3 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
4 OBJECTVALUE1 Character(100) VARCHAR2(100) NOT NULL Object Value 1
5 OBJECTVALUE2 Character(100) VARCHAR2(100) NOT NULL Object Value 2
6 OBJECTVALUE3 Character(30) VARCHAR2(30) NOT NULL Object Value 3
7 OBJECTVALUE4 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