APPS.OPI_EDW_JOB_DETAIL_F_SZ dependencies on WIP_REPETITIVE_SCHEDULES

Line 21: WIP_ENTITIES EN, WIP_REPETITIVE_SCHEDULES RE

17: and en.last_update_date between p_from_date and p_to_date
18: union
19: Select count(*) cnt
20: FROM
21: WIP_ENTITIES EN, WIP_REPETITIVE_SCHEDULES RE
22: WHERE
23: RE.STATUS_TYPE IN (4,5,7,12) AND '_SEC:re.organization_id' IS NOT NULL AND
24: RE.WIP_ENTITY_ID = EN.WIP_ENTITY_ID AND RE.ORGANIZATION_ID = EN.ORGANIZATION_ID
25: and en.last_update_date between p_from_date and p_to_date

Line 155: WIP_REPETITIVE_SCHEDULES RE

151: avg(nvl(vsize(DECODE(RE.STATUS_TYPE,7,RE.DATE_CLOSED,NULL)), 0)), -- ACT_CNCL_DATE,
152: avg(nvl(vsize(RE.LINE_ID), 0)), -- PRD_LINE_FK,
153: avg(nvl(vsize(RE.ROUTING_REVISION), 0)) -- ROUTING_REVISION
154: FROM
155: WIP_REPETITIVE_SCHEDULES RE
156: WHERE
157: RE.STATUS_TYPE IN (4,5,7,12) AND '_SEC:re.organization_id' IS NOT NULL;
158:
159: CURSOR c_4 IS

Line 205: WIP_REPETITIVE_SCHEDULES RE;

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
204: FROM
205: WIP_REPETITIVE_SCHEDULES RE;
206:
207: CURSOR c_10 IS
208: SELECT
209: avg(nvl(vsize((NVL(FL.DATE_CLOSED, FL.scheduled_completion_date) - FL.SCHEDULED_START_DATE)), 0)) -- ACT_JOB_TIME AND PLN_JOB_TIME

Line 234: WIP_ENTITIES EN, WIP_REPETITIVE_SCHEDULES RE

230:
231: CURSOR c_14 IS
232: Select count(*) cnt
233: FROM
234: WIP_ENTITIES EN, WIP_REPETITIVE_SCHEDULES RE
235: WHERE
236: RE.STATUS_TYPE IN (4,5,7,12) AND '_SEC:re.organization_id' IS NOT NULL AND
237: RE.WIP_ENTITY_ID = EN.WIP_ENTITY_ID AND RE.ORGANIZATION_ID = EN.ORGANIZATION_ID ;
238: