DBA Data[Home] [Help]

APPS.BOM_MIXED_MODEL_MAP_PVT dependencies on MTL_UOM_CONVERSIONS

Line 1497: mtl_uom_conversions con

1493: bom_resources br,
1494: bom_operational_routings brtg,
1495: bom_operation_sequences bos1,
1496: bom_operation_sequences bos2,
1497: mtl_uom_conversions con
1498: where brtg.line_id = p_line_id
1499: and brtg.mixed_model_map_flag = 1
1500: and bos1.routing_sequence_id = brtg.common_routing_sequence_id
1501: and bos2.routing_sequence_id = brtg.common_routing_sequence_id

Line 1658: FROM mtl_uom_conversions

1654: l_hour_uom := FND_PROFILE.VALUE('BOM:HOUR_UOM_CODE');
1655: BEGIN
1656: SELECT nvl(conversion_rate, 0)
1657: INTO l_hour_conv
1658: FROM mtl_uom_conversions
1659: WHERE uom_code = l_hour_uom
1660: AND inventory_item_id = 0;
1661: EXCEPTION
1662: WHEN OTHERS THEN