APPS.PO_LINES_SV3 dependencies on MTL_UNITS_OF_MEASURE

Line 201: X_secondary_unit_of_measure_s MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE := NULL;

197: X_receive_close_tolerance_tmp number;
198: X_invoice_close_tolerance_tmp number;
199:
200: /** bug# 1548597 **/
201: X_secondary_unit_of_measure_s MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE := NULL;
202: X_secondary_quantity_shipment PO_LINE_LOCATIONS_ALL.SECONDARY_QUANTITY%TYPE := NULL;
203: X_preferred_grade_shipment MTL_GRADES.GRADE_CODE%TYPE := NULL;-- increased length to 150
204:
205: --

Line 208: l_secondary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

204:
205: --
206: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE;
207: l_grade_control_flag MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG%TYPE;
208: l_secondary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
209: --
210: l_outsourced_assembly po_line_locations_all.outsourced_assembly%type; --
211:
212: l_ip_category_id PO_LINES_ALL.ip_category_id%TYPE; --

Line 573: FROM mtl_units_of_measure

569: END IF;
570:
571: IF l_secondary_uom_code IS NOT NULL THEN -- item is dual uom control
572: SELECT unit_of_measure INTO x_secondary_unit_of_measure_s
573: FROM mtl_units_of_measure
574: WHERE uom_code = l_secondary_uom_code ;
575:
576: /** secondary quantity is specified on the lines. Validate the line secondary quantity
577: with respect to ship to organization . Items in different organization can have different