DBA Data[Home] [Help]

APPS.PO_RETROACTIVE_PRICING_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 3702: l_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;

3698: l_dist_account_ids_tbl po_tbl_number;
3699:
3700: l_primary_quantity PO_LINES.quantity%TYPE;
3701: l_primary_uom PO_LINES.unit_meas_lookup_code%TYPE;
3702: l_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
3703:
3704: l_consigned_flag PO_HEADERS.consigned_consumption_flag%TYPE;
3705: l_return_status varchar2(1);
3706: l_msg_data varchar2(2000);

Line 4128: FROM mtl_units_of_measure mum

4124: BEGIN
4125: -- INV expects the uom_code whereas PO stores unit_of_measure.
4126: SELECT mum.uom_code
4127: INTO l_uom_code
4128: FROM mtl_units_of_measure mum
4129: WHERE mum.unit_of_measure = l_transaction_uoms_tbl(i);
4130: EXCEPTION
4131: WHEN OTHERS THEN
4132: l_uom_code := NULL;