DBA Data[Home] [Help]

APPS.OPI_EDW_JOB_RSRC_F_SZ dependencies on BOM_DEPARTMENTS

Line 16: BOM_DEPARTMENTS bd,

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,
20: WIP_REPETITIVE_SCHEDULES wrs,

Line 60: BOM_DEPARTMENTS bd,

56: FROM
57: WIP_ENTITIES we,
58: WIP_TRANSACTIONS wt,
59: WIP_TRANSACTION_ACCOUNTS wta,
60: BOM_DEPARTMENTS bd,
61: HR_ORGANIZATION_INFORMATION hoi,
62: GL_SETS_OF_BOOKS gsob,
63: WIP_FLOW_SCHEDULES wfs,
64: BOM_OPERATIONAL_ROUTINGS bor,

Line 261: FROM BOM_DEPARTMENTS

257:
258: CURSOR c_4 IS
259: SELECT
260: avg(nvl(vsize(department_code), 0))
261: FROM BOM_DEPARTMENTS
262: WHERE last_update_date between
263: p_from_date and p_to_date;
264:
265: CURSOR c_5 IS