PTIAMMCAPPBYFIX

(SQL View)
Index Back

SELECT DISTINCT B.DBNAME , A.PTIASPSPVERS , B.PTIASPRPTNO FROM PS_PTIASPRPTHEAD A , PS_PTIASPLOGTGT B WHERE 1=1 AND A.PTIASPRPTNO = B.PTIASPRPTNO ORDER BY B.DBNAME, A.PTIASPSPVERS, B.PTIASPRPTNO DESC

# 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