PTIAMMCAPPBYREG

(SQL View)
 Index Back

SELECT DISTINCT PS_PTIAMMCAPPBYFIX.DBNAME , PS_PTIASPRPTHEAD.PTIASPSPVERS , PS_PTIASPRPTHEAD.PTIASPRPTNO FROM PS_PTIASPRPTHEAD , PS_PTIASPRPTTAGS , PS_PTIAMMCAPPBYFIX , PS_PTIAMMCINPBYDB WHERE 1=1 AND PS_PTIASPRPTHEAD.PTIASPRPTNO = PS_PTIASPRPTTAGS.PTIASPRPTNO AND PS_PTIASPRPTHEAD.PTIASPRPTNO = PS_PTIAMMCAPPBYFIX.PTIASPRPTNO AND PS_PTIASPRPTHEAD.PTIASPPRDID = PS_PTIAMMCINPBYDB.PTIASPPRDID AND PS_PTIAMMCAPPBYFIX.DBNAME = PS_PTIAMMCINPBYDB.DBNAME AND PS_PTIASPRPTTAGS.PTIASPRPTTAGNAME IN ('Legislative/Regulatory','Tax Update (PSFT)') ORDER BY PS_PTIASPRPTHEAD.PTIASPRPTNO

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