PTIASPEOPC_VW

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 Field Type Column Type Description
PTIASPDEPTOOLSREL Number(5,0) INTEGER NOT NULL Dependency Tools Release
PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number
PTIASPRPTDEPTYPE Character(1) VARCHAR2(1) NOT NULL Dependency Type
B=Base Rule
I=Instance Rule
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20