APPS.PO_INTERFACE_S dependencies on MTL_UNITS_OF_MEASURE

Line 3140: x_secondary_unit_def MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;

3136: l_manual_price_change_flag po_lines_all.manual_price_change_flag%TYPE := NULL; --bug 3495772
3137: l_from_type_lookup_code PO_HEADERS.type_lookup_code%type;--bug#3612701
3138:
3139: --
3140: x_secondary_unit_def MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
3141: x_secondary_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
3142: x_secondary_quantity_def PO_LINES.SECONDARY_QUANTITY%TYPE;
3143: x_preferred_grade_def MTL_GRADES.GRADE_CODE%TYPE;
3144: l_quantity_temp PO_LINES.QUANTITY%TYPE;

Line 3141: x_secondary_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;

3137: l_from_type_lookup_code PO_HEADERS.type_lookup_code%type;--bug#3612701
3138:
3139: --
3140: x_secondary_unit_def MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
3141: x_secondary_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
3142: x_secondary_quantity_def PO_LINES.SECONDARY_QUANTITY%TYPE;
3143: x_preferred_grade_def MTL_GRADES.GRADE_CODE%TYPE;
3144: l_quantity_temp PO_LINES.QUANTITY%TYPE;
3145: --

Line 5125: FROM mtl_units_of_measure

5121: AND l_quantity_temp > 0
5122: AND x_secondary_quantity_def IS NULL ) THEN -- bug 9324837
5123: SELECT unit_of_measure
5124: INTO x_secondary_unit_def
5125: FROM mtl_units_of_measure
5126: WHERE uom_code = item.secondary_uom_code ;
5127:
5128: PO_UOM_S.uom_convert (l_quantity_temp,
5129: x_unit_of_measure,

Line 5758: x_shipment_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;

5754: -- Bug 5208159
5755: l_from_type_lookup_code po_headers_all.type_lookup_code%TYPE;
5756:
5757: --
5758: x_shipment_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
5759: x_secondary_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
5760: x_secondary_quantity PO_LINES.SECONDARY_QUANTITY%TYPE;
5761: x_secondary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
5762: --

Line 5759: x_secondary_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;

5755: l_from_type_lookup_code po_headers_all.type_lookup_code%TYPE;
5756:
5757: --
5758: x_shipment_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
5759: x_secondary_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
5760: x_secondary_quantity PO_LINES.SECONDARY_QUANTITY%TYPE;
5761: x_secondary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
5762: --
5763:

Line 5761: x_secondary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

5757: --
5758: x_shipment_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
5759: x_secondary_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
5760: x_secondary_quantity PO_LINES.SECONDARY_QUANTITY%TYPE;
5761: x_secondary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
5762: --
5763:
5764: l_matching_basis PO_LINE_TYPES.matching_basis%TYPE; --
5765: l_inspection_required_flag VARCHAR2(1); --10403047

Line 10526: x_secondary_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;

10522: x_num_interface_lines number := 1; /* used for incrementing po line number */
10523: x_int_shipment_num number; /* maximum shipment num in interface table */
10524: x_int_line_num number; /* maximum line num in interface table */
10525: -- start of 1548597
10526: x_secondary_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
10527: x_preferred_grade MTL_GRADES.GRADE_CODE%TYPE; -- increased to 150
10528: -- end of 1548597
10529: /* Bug 1949160. x_count variable is used as counter to increment in a
10530: loop */