APPS.OPI_EDW_RES_UTIL_F_SZ dependencies on MTL_UNITS_OF_MEASURE

Line 19: mtl_units_of_measure m1,

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
23: AND br.resource_id = bdr.resource_id

Line 20: mtl_units_of_measure m2

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
23: AND br.resource_id = bdr.resource_id
24: AND m1.uom_code = fnd_profile.value('BOM:HOUR_UOM_CODE')

Line 46: mtl_units_of_measure m1,

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
50: AND br.resource_id = bdr.resource_id

Line 47: mtl_units_of_measure m2

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
50: AND br.resource_id = bdr.resource_id
51: AND m1.uom_code = fnd_profile.value('BOM:HOUR_UOM_CODE')