PTIASPRPTSELDVW

index back

Bug Select Dynamic View


SELECT CALC.PTIASPRPTNO , PRD.PTIASPPRDCD , RPT.PTIASPRPTSUBJECT , CALC.PTIASPRPTNOAPLD , ( CASE WHEN PTIASPSEARCHSCOPE ='S' AND EXISTS ( SELECT 'X' FROM PS_PTIASPRPTREQS , PS_PTIASPPKGS WHERE PS_PTIASPRPTREQS.PTIASPRPTNO=CALC.PTIASPRPTNO AND CALC.PTIASPPKGGUID = PS_PTIASPPKGS.PTIASPPKGGUID AND PTIASPREQTYPE ='True Requisite' AND EXISTS ( SELECT 'X' FROM PS_PTIASPLOGTGT WHERE PS_PTIASPRPTREQS.PTIASPRPTNOPRE = PS_PTIASPLOGTGT.PTIASPRPTNO AND PS_PTIASPPKGS.DBNAME =PS_PTIASPLOGTGT.DBNAME ) AND NOT EXISTS ( SELECT 'X' FROM PS_PTIASPLOGTGT WHERE PS_PTIASPRPTREQS.PTIASPRPTNO = PS_PTIASPLOGTGT.PTIASPRPTNO AND PS_PTIASPPKGS.DBNAME =PS_PTIASPLOGTGT.DBNAME ) ) THEN 'Y' ELSE '' END ) AS PTIASPCRITICALFLAG, RPT.PTIASPSPVERS, CALC.PTIASPRPTCUSTFLAG, CALC.PTIASPRPTTESTFLAG, CALC.PTIASPRPTNOUSEL FROM PS_PTIASPPKGCALC CALC , PS_PTIASPRPTHEAD RPT , PS_PTIASPPRD PRD , PS_PTIASPPKGOPTS WHERE CALC.PTIASPRPTNO = RPT.PTIASPRPTNO AND RPT.PTIASPPRDID = PRD.PTIASPPRDID AND CALC.PTIASPPKGGUID = PS_PTIASPPKGOPTS.PTIASPPKGGUID

PeopleSoft Field Name Field Type Column Type Description
PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number
PTIASPPRDCD Character(8) VARCHAR2(8) NOT NULL Product
PTIASPRPTSUBJECT Character(240) VARCHAR2(240) NOT NULL Bug Subject
PTIASPRPTNOAPLD Character(1) VARCHAR2(1) NOT NULL This flag indicates a BUG has already been applied
PTIASPCRITICALFLAG Character(1) VARCHAR2(1) NOT NULL True Post Req
PTIASPSPVERS Number(5,0) INTEGER NOT NULL Numeric value for Patch Database Version Number
PTIASPRPTCUSTFLAG Character(1) VARCHAR2(1) NOT NULL Custom Impact
A=Above Threshold
B=Below Threshod
D=Dirty Value
N=No Customization
R=Requisite
PTIASPRPTTESTFLAG Character(1) VARCHAR2(1) NOT NULL Test Exists
A=Above Threshold
B=Below Threshod
D=Dirty Value
N=No Customization
R=Requisite
PTIASPRPTNOUSEL Character(1) VARCHAR2(1) NOT NULL Indicates that this BUG was user selected and formed the basis of the requisite calculation

Y/N Table Edit

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20