APPS.OPI_EDW_JOB_DETAIL_F_SZ dependencies on WIP_DISCRETE_JOBS

Line 13: WIP_ENTITIES EN, WIP_DISCRETE_JOBS DI

9: from
10: (
11: Select count(*) cnt
12: FROM
13: WIP_ENTITIES EN, WIP_DISCRETE_JOBS DI
14: WHERE
15: DI.STATUS_TYPE IN (4,5,7,12) AND '_SEC:di.organization_id' IS NOT NULL AND
16: DI.WIP_ENTITY_ID = EN.WIP_ENTITY_ID AND DI.ORGANIZATION_ID = EN.ORGANIZATION_ID
17: and en.last_update_date between p_from_date and p_to_date

Line 138: FROM WIP_DISCRETE_JOBS DI

134: avg(nvl(vsize(DI.date_closed), 0)), -- ACT_CMPL_DATE,
135: avg(nvl(vsize(DECODE(DI.STATUS_TYPE,7,DI.DATE_COMPLETED,NULL)), 0)), -- ACT_CNCL_DATE,
136: avg(nvl(vsize(DI.LINE_ID), 0)), -- PRD_LINE_FK,
137: avg(nvl(vsize(DI.ROUTING_REVISION), 0)) -- ROUTING_REVISION,
138: FROM WIP_DISCRETE_JOBS DI
139: WHERE
140: DI.STATUS_TYPE IN (4,5,7,12) AND '_SEC:di.organization_id' IS NOT NULL;
141:
142: CURSOR c_3 IS

Line 199: WIP_DISCRETE_JOBS DI;

195: CURSOR c_8 IS
196: SELECT
197: avg(nvl(vsize((NVL(DI.DATE_COMPLETED,DI.date_closed) - DI.SCHEDULED_START_DATE)), 0)) -- ACT_JOB_TIME AND PLN_JOB_TIME
198: FROM
199: WIP_DISCRETE_JOBS DI;
200:
201: CURSOR c_9 IS
202: SELECT
203: avg(nvl(vsize((NVL(RE.DATE_CLOSED,RE.last_unit_completion_date) - RE.FIRST_UNIT_START_DATE)), 0)) -- ACT_JOB_TIME AND PLN_JOB_TIME

Line 226: WIP_ENTITIES EN, WIP_DISCRETE_JOBS DI

222:
223: CURSOR c_13 IS
224: Select count(*) cnt
225: FROM
226: WIP_ENTITIES EN, WIP_DISCRETE_JOBS DI
227: WHERE
228: DI.STATUS_TYPE IN (4,5,7,12) AND '_SEC:di.organization_id' IS NOT NULL AND
229: DI.WIP_ENTITY_ID = EN.WIP_ENTITY_ID AND DI.ORGANIZATION_ID = EN.ORGANIZATION_ID ;
230: