PTIASPRPTRQPRVW

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 Field Type Column Type Description
PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number
PTIASPRPTNOPRE Number(10,0) DECIMAL(10) NOT NULL BUG Number
PTIASPRPTSUBJECT Character(80) VARCHAR2(80) NOT NULL Bug Subject
PTIASPSPVERS Number(5,0) INTEGER NOT NULL Numeric value for Patch Database Version Number
PTIASPRPTPOSTDT DateTime(26) TIMESTAMP Date this Bug was Posted
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19