APPS.BOM_CALC_OP_TIMES_PK dependencies on MTL_UOM_CONVERSIONS

Line 86: FROM mtl_uom_conversions

82: hour_uom := FND_PROFILE.VALUE('BOM:HOUR_UOM_CODE');
83:
84: SELECT conversion_rate
85: INTO hour_conv
86: FROM mtl_uom_conversions
87: WHERE uom_code = hour_uom
88: AND inventory_item_id = 0;
89:
90: OPEN Events_cur;

Line 109: mtl_uom_conversions con

105: bom_operation_resources bor,
106: bom_department_resources bdr2,
107: bom_department_resources bdr1,
108: bom_resources br,
109: mtl_uom_conversions con
110: -- WHERE bor.schedule_flag <> 2
111: WHERE bor.resource_id = br.resource_id
112: AND br.resource_type = 1
113: AND NVL(br.disable_date, trunc(sysdate) + 1)

Line 142: mtl_uom_conversions con

138: bom_operation_resources bor,
139: bom_department_resources bdr2,
140: bom_department_resources bdr1,
141: bom_resources br,
142: mtl_uom_conversions con
143: -- WHERE bor.schedule_flag <> 2
144: WHERE bor.resource_id = br.resource_id
145: AND br.resource_type = 2
146: AND NVL(br.disable_date, trunc(sysdate) + 1)

Line 174: mtl_uom_conversions con

170: bom_operation_resources bor,
171: bom_department_resources bdr2,
172: bom_department_resources bdr1,
173: bom_resources br,
174: mtl_uom_conversions con
175: WHERE bor.schedule_flag <> 2
176: AND bor.resource_id = br.resource_id
177: AND br.resource_type IN (1, 2)
178: AND NVL(br.disable_date, trunc(sysdate) + 1)