APPS.OPI_EDW_JOB_DETAIL_F_SZ dependencies on WIP_ENTITIES

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 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 29: WIP_ENTITIES EN, WIP_FLOW_SCHEDULES FL

25: and en.last_update_date between p_from_date and p_to_date
26: union
27: Select count(*) cnt
28: FROM
29: WIP_ENTITIES EN, WIP_FLOW_SCHEDULES FL
30: WHERE
31: FL.STATUS = 2 AND '_SEC:fl.organization_id' IS NOT NULL AND
32: FL.WIP_ENTITY_ID = EN.WIP_ENTITY_ID AND FL.ORGANIZATION_ID = EN.ORGANIZATION_ID
33: and en.last_update_date between p_from_date and p_to_date

Line 125: FROM WIP_ENTITIES EN;

121: avg(nvl(vsize(EN.ENTITY_TYPE), 0)), -- ENTITY_TYPE
122: avg(nvl(vsize(EN.CREATION_DATE), 0)), -- CREATION_DATE
123: avg(nvl(vsize(EN.LAST_UPDATE_DATE), 0)) , -- LAST_UPDATE_DATE
124: avg(nvl(vsize(TO_CHAR(EN.PRIMARY_ITEM_ID)), 0)) -- ROUTING
125: FROM WIP_ENTITIES EN;
126:
127: CURSOR c_2 IS
128: SELECT
129: avg(nvl(vsize(DI.QUANTITY_COMPLETED), 0)), -- ACT_OUT_QTY,

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:

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:

Line 242: WIP_ENTITIES EN, WIP_FLOW_SCHEDULES FL

238:
239: CURSOR c_15 IS
240: Select count(*) cnt
241: FROM
242: WIP_ENTITIES EN, WIP_FLOW_SCHEDULES FL
243: WHERE
244: FL.STATUS = 2 AND '_SEC:fl.organization_id' IS NOT NULL AND
245: FL.WIP_ENTITY_ID = EN.WIP_ENTITY_ID AND FL.ORGANIZATION_ID = EN.ORGANIZATION_ID;
246: