APPS.OPI_EDW_RES_UTIL_F_SZ dependencies on BOM_RESOURCES

Line 14: bom_resources br,

10: from (
11: -- Third UNION: no wip actual, only availability, 24 hr available
12: SELECT count(*) cnt
13: FROM
14: bom_resources br,
15: bom_departments bd,
16: bom_department_resources bdr,
17: bom_calendar_dates bcd,
18: mtl_parameters mp,

Line 39: bom_resources br,

35: UNION ALL
36: -- Fourth UNION: no wip actual, only availability, shift based
37: SELECT count(*) cnt
38: FROM
39: bom_resources br,
40: bom_departments bd,
41: bom_department_resources bdr,
42: bom_resource_shifts brs,
43: bom_shift_dates bsd,

Line 96: FROM bom_resources;

92: CURSOR c_res IS
93: SELECT avg(nvl(vsize(resource_id), 0)) res_id,
94: avg(nvl(vsize(unit_of_measure), 0)) uom,
95: avg(nvl(vsize(resource_code), 0)) res_code
96: FROM bom_resources;
97:
98: CURSOR c_instance IS
99: SELECT
100: avg(nvl(vsize(instance_code), 0))