APPS.OPI_EDW_JOB_RSRC_F_SZ dependencies on WIP_OPERATIONS

Line 14: WIP_OPERATIONS wo,

10: (
11: select to_char(wor.organization_id)||inst.instance_code
12: FROM
13: WIP_OPERATION_RESOURCES wor,
14: WIP_OPERATIONS wo,
15: WIP_ENTITIES we,
16: BOM_DEPARTMENTS bd,
17: HR_ORGANIZATION_INFORMATION hoi,
18: GL_SETS_OF_BOOKS gsob,

Line 245: FROM WIP_OPERATIONS

241: CURSOR c_2 IS
242: SELECT
243: -- OPRN_FK wo.operation_seq_id (Need to add inst.instance_code)
244: avg(nvl(vsize(operation_sequence_id||organization_id),0))
245: FROM WIP_OPERATIONS
246: WHERE last_update_date between
247: p_from_date and p_to_date;
248:
249: CURSOR c_3 IS