PTIASPRPTRQPOVW

index back

First level Bug PostDependency


SELECT REQS.PTIASPRPTNOPRE , REQS.PTIASPRPTNO , H1.PTIASPRPTSUBJECT , H1.PTIASPSPVERS , H1.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 AND REQS.PTIASPREQDIRECTN = 'BOTH'

PeopleSoft Field Name Field Type Column Type Description
PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number
PTIASPRPTNOPOST 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