PTIASPRPTQRYVW

(SQL View)
Index Back

SELECT A.PTIASPRPTNO , A.PTIASPSPVERS , A.PTIASPRPTSEVERITY , B.PTIASPPRDFMLY FROM PS_PTIASPRPTHEAD A , PS_PTIASPPRDFMLY B WHERE B.PTIASPPRDID = A.PTIASPPRDID AND A.PTIASPRPTNO>1000 AND A.PTIASPRPTNO<600000000

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number
2 PTIASPSPVERS Number(5,0) INTEGER NOT NULL Numeric value for Patch Database Version Number
3 PTIASPRPTSEVERITY Character(45) VARCHAR2(45) NOT NULL BUG Severity Description
4 PTIASPPRDFMLY Character(5) VARCHAR2(5) NOT NULL Product Family