DBA Data[Home] [Help]

APPS.OPI_EDW_JOB_RSRC_F_SZ dependencies on WIP_ENTITIES

Line 15: WIP_ENTITIES we,

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,
19: WIP_DISCRETE_JOBS wdj,

Line 57: WIP_ENTITIES we,

53: UNION ALL
54: select
55: to_char(wt.organization_id)||inst.instance_code
56: FROM
57: WIP_ENTITIES we,
58: WIP_TRANSACTIONS wt,
59: WIP_TRANSACTION_ACCOUNTS wta,
60: BOM_DEPARTMENTS bd,
61: HR_ORGANIZATION_INFORMATION hoi,

Line 253: FROM WIP_ENTITIES

249: CURSOR c_3 IS
250: SELECT
251: avg(nvl(vsize(wip_entity_name), 0)),
252: avg(nvl(vsize(primary_item_id), 0))
253: FROM WIP_ENTITIES
254: WHERE last_update_date between
255: p_from_date and p_to_date;
256:
257: