eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OPI_EDW_RES_UTIL_F_SZ dependencies on BOM_DEPARTMENTS

Line 15: bom_departments bd,

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,
19: mtl_units_of_measure m1,

Line 40: bom_departments bd,

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,
44: bom_shift_times bst,

Line 105: FROM bom_departments;

101: FROM EDW_LOCAL_INSTANCE ;
102:
103: CURSOR c_dept IS
104: SELECT avg(nvl(Vsize(department_code), 0))
105: FROM bom_departments;
106:
107: CURSOR c_org IS
108: SELECT avg(nvl(Vsize(organization_id), 0)) org_id,
109: avg(nvl(Vsize(organization_code), 0)) org_code