APPS.PO_OM_INTEGRATION_GRP dependencies on MTL_UNITS_OF_MEASURE

Line 153: l_so_request_unit_of_measure mtl_units_of_measure.UNIT_OF_MEASURE_TL%TYPE;

149: --Bug# 4640038 Start, Added the following variable
150:
151: l_po_request_unit_of_measure PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%TYPE;
152: l_po_request_secondary_uom PO_LINES_ALL.SECONDARY_UOM%TYPE;
153: l_so_request_unit_of_measure mtl_units_of_measure.UNIT_OF_MEASURE_TL%TYPE;
154: l_so_request_secondary_uom mtl_units_of_measure.UNIT_OF_MEASURE_TL%TYPE;
155: l_uom_conversion_rate NUMBER := 1;
156: l_suom_conversion_rate NUMBER := 1;
157: l_secondary_quantity_ordered PO_TBL_NUMBER := p_secondary_quantity;

Line 154: l_so_request_secondary_uom mtl_units_of_measure.UNIT_OF_MEASURE_TL%TYPE;

150:
151: l_po_request_unit_of_measure PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%TYPE;
152: l_po_request_secondary_uom PO_LINES_ALL.SECONDARY_UOM%TYPE;
153: l_so_request_unit_of_measure mtl_units_of_measure.UNIT_OF_MEASURE_TL%TYPE;
154: l_so_request_secondary_uom mtl_units_of_measure.UNIT_OF_MEASURE_TL%TYPE;
155: l_uom_conversion_rate NUMBER := 1;
156: l_suom_conversion_rate NUMBER := 1;
157: l_secondary_quantity_ordered PO_TBL_NUMBER := p_secondary_quantity;
158: l_item_id po_lines.item_id%TYPE;

Line 270: mtl_units_of_measure puom,

266: INTO l_so_request_unit_of_measure,
267: l_so_request_secondary_uom
268: FROM oe_order_lines_all ol,
269: oe_drop_ship_sources ds,
270: mtl_units_of_measure puom,
271: mtl_units_of_measure suom
272: WHERE ol.line_id=ds.line_id
273: AND ds.line_location_id= p_po_line_location_id(i)
274: and ol.order_quantity_uom= puom.uom_code

Line 271: mtl_units_of_measure suom

267: l_so_request_secondary_uom
268: FROM oe_order_lines_all ol,
269: oe_drop_ship_sources ds,
270: mtl_units_of_measure puom,
271: mtl_units_of_measure suom
272: WHERE ol.line_id=ds.line_id
273: AND ds.line_location_id= p_po_line_location_id(i)
274: and ol.order_quantity_uom= puom.uom_code
275: and ol.ordered_quantity_uom2=suom.uom_code(+);

Line 521: mtl_units_of_measure puom,

517: INTO l_so_request_unit_of_measure,
518: l_so_request_secondary_uom
519: FROM oe_order_lines_all ol,
520: oe_drop_ship_sources ds,
521: mtl_units_of_measure puom,
522: mtl_units_of_measure suom
523: WHERE ol.line_id=ds.line_id
524: AND ds.requisition_line_id= p_req_line_id(i)
525: and ol.order_quantity_uom= puom.uom_code

Line 522: mtl_units_of_measure suom

518: l_so_request_secondary_uom
519: FROM oe_order_lines_all ol,
520: oe_drop_ship_sources ds,
521: mtl_units_of_measure puom,
522: mtl_units_of_measure suom
523: WHERE ol.line_id=ds.line_id
524: AND ds.requisition_line_id= p_req_line_id(i)
525: and ol.order_quantity_uom= puom.uom_code
526: and ol.ordered_quantity_uom2=suom.uom_code(+);