PTIASPEOPC_VW

(SQL View)
 Index Back

View for EOPC support

View for Patch Delivery Based Post Requisite support, which stores bugs with base rule or instance rule.

SELECT DISTINCT PTIASPDEPTOOLSREL , PTIASPRPTNO , PTIASPRPTDEPTYPE FROM ( SELECT PTIASPDEPTOOLSREL , PTIASPRPTNO , 'B' AS PTIASPRPTDEPTYPE FROM PS_PTIASPMODEPINF WHERE PTIASPDEPTOOLSREL>=50000 AND PTIASPDEPTOOLSREL<60000 AND PTIASPDEPTYPE IN (3, 4) AND MOD(PTIASPDEPTOOLSREL, 100) = 0 UNION ALL SELECT PTIASPDEPTOOLSREL , PTIASPRPTNO , 'B' AS PTIASPRPTDEPTYPE FROM PS_PTIASPADSDEPINF WHERE PTIASPDEPTOOLSREL>=50000 AND PTIASPDEPTOOLSREL<60000 AND PTIASPDEPTYPE IN (3, 4) AND MOD(PTIASPDEPTOOLSREL, 100) = 0 UNION ALL SELECT TRUNC(PTIASPDEPTOOLSREL/100) * 100 AS PTIASPDEPTOOLSREL , PTIASPRPTNO , 'I' AS PTIASPRPTDEPTYPE FROM PS_PTIASPMODEPINF WHERE PTIASPDEPTOOLSREL>=50000 AND PTIASPDEPTOOLSREL<60000 AND PTIASPDEPTYPE IN (3, 4) AND MOD(PTIASPDEPTOOLSREL, 100) <> 0 UNION ALL SELECT TRUNC(PTIASPDEPTOOLSREL/100) * 100 AS PTIASPDEPTOOLSREL , PTIASPRPTNO , 'I' AS PTIASPRPTDEPTYPE FROM PS_PTIASPADSDEPINF WHERE PTIASPDEPTOOLSREL>=50000 AND PTIASPDEPTOOLSREL<60000 AND PTIASPDEPTYPE IN (3, 4) AND MOD(PTIASPDEPTOOLSREL, 100) <> 0)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTIASPDEPTOOLSREL Number(5,0) INTEGER NOT NULL Dependency Tools Release
2 PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number
3 PTIASPRPTDEPTYPE Character(1) VARCHAR2(1) NOT NULL Dependency Type
B=Base Rule
I=Instance Rule