DBA Data[Home] [Help]

APPS.OPI_EDW_RES_UTIL_F_SZ dependencies on FND_PROFILE

Line 24: AND m1.uom_code = fnd_profile.value('BOM:HOUR_UOM_CODE')

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')
25: AND m2.uom_code = br.unit_of_measure
26: AND m2.uom_class = m1.uom_class
27: AND bd.department_id = bdr.department_id
28: AND bd.organization_id = mp.organization_id

Line 51: AND m1.uom_code = fnd_profile.value('BOM:HOUR_UOM_CODE')

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')
52: AND m2.uom_code = br.unit_of_measure
53: AND m2.uom_class = m1.uom_class
54: AND bd.department_id = bdr.department_id
55: AND bd.organization_id = mp.organization_id