DBA Data[Home] [Help]

APPS.PO_INTERFACE_S dependencies on MTL_UNITS_OF_MEASURE

Line 2803: x_secondary_unit_def MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;

2799: l_manual_price_change_flag po_lines_all.manual_price_change_flag%TYPE := NULL; --bug 3495772
2800: l_from_type_lookup_code PO_HEADERS.type_lookup_code%type;--bug#3612701
2801:
2802: --
2803: x_secondary_unit_def MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
2804: x_secondary_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
2805: x_secondary_quantity_def PO_LINES.SECONDARY_QUANTITY%TYPE;
2806: x_preferred_grade_def MTL_GRADES.GRADE_CODE%TYPE;
2807: l_quantity_temp PO_LINES.QUANTITY%TYPE;

Line 2804: x_secondary_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;

2800: l_from_type_lookup_code PO_HEADERS.type_lookup_code%type;--bug#3612701
2801:
2802: --
2803: x_secondary_unit_def MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
2804: x_secondary_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
2805: x_secondary_quantity_def PO_LINES.SECONDARY_QUANTITY%TYPE;
2806: x_preferred_grade_def MTL_GRADES.GRADE_CODE%TYPE;
2807: l_quantity_temp PO_LINES.QUANTITY%TYPE;
2808: --

Line 4665: FROM mtl_units_of_measure

4661: --
4662: IF item.secondary_uom_code IS NOT NULL and l_quantity_temp > 0 THEN
4663: SELECT unit_of_measure
4664: INTO x_secondary_unit_def
4665: FROM mtl_units_of_measure
4666: WHERE uom_code = item.secondary_uom_code ;
4667:
4668: PO_UOM_S.uom_convert (l_quantity_temp,
4669: x_unit_of_measure,

Line 5295: x_shipment_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;

5291: -- Bug 5208159
5292: l_from_type_lookup_code po_headers_all.type_lookup_code%TYPE;
5293:
5294: --
5295: x_shipment_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
5296: x_secondary_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
5297: x_secondary_quantity PO_LINES.SECONDARY_QUANTITY%TYPE;
5298: x_secondary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
5299: --

Line 5296: x_secondary_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;

5292: l_from_type_lookup_code po_headers_all.type_lookup_code%TYPE;
5293:
5294: --
5295: x_shipment_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
5296: x_secondary_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
5297: x_secondary_quantity PO_LINES.SECONDARY_QUANTITY%TYPE;
5298: x_secondary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
5299: --
5300:

Line 5298: x_secondary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

5294: --
5295: x_shipment_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
5296: x_secondary_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
5297: x_secondary_quantity PO_LINES.SECONDARY_QUANTITY%TYPE;
5298: x_secondary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
5299: --
5300:
5301: l_matching_basis PO_LINE_TYPES.matching_basis%TYPE; --
5302:

Line 9895: x_secondary_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;

9891: x_num_interface_lines number := 1; /* used for incrementing po line number */
9892: x_int_shipment_num number; /* maximum shipment num in interface table */
9893: x_int_line_num number; /* maximum line num in interface table */
9894: -- start of 1548597
9895: x_secondary_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
9896: x_preferred_grade MTL_GRADES.GRADE_CODE%TYPE; -- increased to 150
9897: -- end of 1548597
9898: /* Bug 1949160. x_count variable is used as counter to increment in a
9899: loop */