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,
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,
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