PTIAMDMMCDET_VW

(SQL View)
 Index Back

SELECT DISTINCT DBNAME , 'APP' , %Coalesce(( SELECT PTIAMMCAPPBYCUR FROM PS_PTIAMMCAPPBYCUR WHERE DBNAME = PS_PTIASPLOGTGT.DBNAME), 0) FROM PS_PTIASPLOGTGT UNION SELECT DISTINCT DBNAME , 'PRD' , %Coalesce(( SELECT PTIAMMCINPBYCUR FROM PS_PTIAMMCINPBYCUR WHERE DBNAME = PS_PTIASPLOGTGT.DBNAME), 0) FROM PS_PTIASPLOGTGT UNION SELECT DISTINCT DBNAME , 'REG' , %coalesce(( SELECT PTIAMMCREGBYCUR FROM PS_PTIAMMCREGBYCUR WHERE DBNAME = PS_PTIASPLOGTGT.DBNAME), 0) FROM PS_PTIASPLOGTGT UNION SELECT DISTINCT DBNAME , 'HFA' , %coalesce(( SELECT PTIAMMCAPPBYMAX FROM PS_PTIAMMCAPPBYMAX WHERE DBNAME = PS_PTIASPLOGTGT.DBNAME), 0) FROM PS_PTIASPLOGTGT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name
2 PTIAMMCCRITERIA Character(4) VARCHAR2(4) NOT NULL Criteria
3 PTIASPSPVERS Number(5,0) INTEGER NOT NULL Numeric value for Patch Database Version Number