PTIASPRPTRQPRVW

(SQL View)
Index Back

First level Bug PreDependency


SELECT REQS.PTIASPRPTNO , REQS.PTIASPRPTNOPRE , H2.PTIASPRPTSUBJECT , H2.PTIASPSPVERS , H2.PTIASPRPTPOSTDT FROM PS_PTIASPRPTREQS REQS ,PS_PTIASPRPTHEAD H1 ,PS_PTIASPRPTHEAD H2 WHERE REQS.PTIASPRPTNO = H1.PTIASPRPTNO AND REQS.PTIASPRPTNOPRE = H2.PTIASPRPTNO AND REQS.PTIASPRPTNO <> REQS.PTIASPRPTNOPRE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number
2 PTIASPRPTNOPRE Number(10,0) DECIMAL(10) NOT NULL BUG Number
3 PTIASPRPTSUBJECT Character(240) VARCHAR2(240) NOT NULL Bug Subject
4 PTIASPSPVERS Number(5,0) INTEGER NOT NULL Numeric value for Patch Database Version Number
5 PTIASPRPTPOSTDT DateTime(26) TIMESTAMP Date this Bug was Posted