APPS.OPI_EDW_JOB_RSRC_F_SZ dependencies on WIP_OPERATION_RESOURCES

Line 13: WIP_OPERATION_RESOURCES wor,

9: select count(*) from
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,

Line 237: FROM WIP_OPERATION_RESOURCES

233: avg(nvl(vsize(resource_id), 0)),
234: -- ITEM_FK we.primary_item_id, add instance_code
235: -- USAGE_UOM_FK
236: avg(nvl(vsize(uom_code), 0))
237: FROM WIP_OPERATION_RESOURCES
238: WHERE last_update_date between
239: p_from_date and p_to_date;
240:
241: CURSOR c_2 IS