APPS.OPI_EDW_RES_UTIL_F_SZ dependencies on BOM_DEPARTMENT_RESOURCES

Line 16: bom_department_resources bdr,

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,
20: mtl_units_of_measure m2

Line 41: bom_department_resources bdr,

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,
45: mtl_parameters mp,

Line 119: FROM bom_department_resources

115: WHERE last_update_date between p_from_date and p_to_date;
116:
117: CURSOR c_avail IS
118: SELECT AVG(Nvl(Vsize(24*capacity_units), 0))
119: FROM bom_department_resources
120: WHERE last_update_date between p_from_date and p_to_date;
121:
122: CURSOR c_trx_date_fk IS
123: SELECT AVG(Nvl(Vsize(EDW_TIME_PKG.CAL_DAY_FK(Sysdate, set_of_books_id) ),0))