PTIASPRPTSELDVW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
1 PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number
2 PTIASPPRDCD Character(8) VARCHAR2(8) NOT NULL Product
3 PTIASPRPTSUBJECT Character(240) VARCHAR2(240) NOT NULL Bug Subject
4 PTIASPRPTNOAPLD Character(1) VARCHAR2(1) NOT NULL This flag indicates a BUG has already been applied
5 PTIASPCRITICALFLAG Character(1) VARCHAR2(1) NOT NULL True Post Req
6 PTIASPSPVERS Number(5,0) INTEGER NOT NULL Numeric value for Patch Database Version Number
7 PTIASPRPTCUSTFLAG Character(1) VARCHAR2(1) NOT NULL Custom Impact
A=Excluded
B=Included
D=Run Calc
N=No Impact
R=Requisite
8 PTIASPRPTTESTFLAG Character(1) VARCHAR2(1) NOT NULL Test Exists
A=Above Threshold
B=Below Threshod
D=Dirty Value
N=No Customization
R=Requisite
9 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