DBA Data[Home] [Help]

APPS.OPI_EDW_RES_UTIL_F_SZ dependencies on MTL_PARAMETERS

Line 18: mtl_parameters mp,

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
21: WHERE bdr.available_24_hours_flag = 1 -- 24 hr available
22: AND bdr.share_from_dept_id IS NULL

Line 45: mtl_parameters mp,

41: bom_department_resources bdr,
42: bom_resource_shifts brs,
43: bom_shift_dates bsd,
44: bom_shift_times bst,
45: mtl_parameters mp,
46: mtl_units_of_measure m1,
47: mtl_units_of_measure m2
48: WHERE bdr.available_24_hours_flag = 2 -- shift based
49: AND bdr.share_from_dept_id IS NULL

Line 110: FROM mtl_parameters;

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
110: FROM mtl_parameters;
111:
112: CURSOR c_act_usage IS
113: SELECT AVG(Nvl(Vsize(primary_quantity), 0))
114: FROM wip_transactions