APPS.PO_OM_INTEGRATION_GRP dependencies on MTL_UNITS_OF_MEASURE

Line 148: l_so_request_unit_of_measure mtl_units_of_measure.UNIT_OF_MEASURE_TL%TYPE;

144: --Bug# 4640038 Start, Added the following variable
145:
146: l_po_request_unit_of_measure PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%TYPE;
147: l_po_request_secondary_uom PO_LINES_ALL.SECONDARY_UOM%TYPE;
148: l_so_request_unit_of_measure mtl_units_of_measure.UNIT_OF_MEASURE_TL%TYPE;
149: l_so_request_secondary_uom mtl_units_of_measure.UNIT_OF_MEASURE_TL%TYPE;
150: l_uom_conversion_rate NUMBER := 1;
151: l_suom_conversion_rate NUMBER := 1;
152: l_secondary_quantity_ordered PO_TBL_NUMBER := p_secondary_quantity;

Line 149: l_so_request_secondary_uom mtl_units_of_measure.UNIT_OF_MEASURE_TL%TYPE;

145:
146: l_po_request_unit_of_measure PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%TYPE;
147: l_po_request_secondary_uom PO_LINES_ALL.SECONDARY_UOM%TYPE;
148: l_so_request_unit_of_measure mtl_units_of_measure.UNIT_OF_MEASURE_TL%TYPE;
149: l_so_request_secondary_uom mtl_units_of_measure.UNIT_OF_MEASURE_TL%TYPE;
150: l_uom_conversion_rate NUMBER := 1;
151: l_suom_conversion_rate NUMBER := 1;
152: l_secondary_quantity_ordered PO_TBL_NUMBER := p_secondary_quantity;
153: l_item_id po_lines.item_id%TYPE;

Line 265: mtl_units_of_measure puom,

261: INTO l_so_request_unit_of_measure,
262: l_so_request_secondary_uom
263: FROM oe_order_lines_all ol,
264: oe_drop_ship_sources ds,
265: mtl_units_of_measure puom,
266: mtl_units_of_measure suom
267: WHERE ol.line_id=ds.line_id
268: AND ds.line_location_id= p_po_line_location_id(i)
269: and ol.order_quantity_uom= puom.uom_code

Line 266: mtl_units_of_measure suom

262: l_so_request_secondary_uom
263: FROM oe_order_lines_all ol,
264: oe_drop_ship_sources ds,
265: mtl_units_of_measure puom,
266: mtl_units_of_measure suom
267: WHERE ol.line_id=ds.line_id
268: AND ds.line_location_id= p_po_line_location_id(i)
269: and ol.order_quantity_uom= puom.uom_code
270: and ol.ordered_quantity_uom2=suom.uom_code(+);