DBA Data[Home] [Help]

APPS.PO_RETROACTIVE_PRICING_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 3581: l_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;

3577: l_dist_account_ids_tbl po_tbl_number;
3578:
3579: l_primary_quantity PO_LINES.quantity%TYPE;
3580: l_primary_uom PO_LINES.unit_meas_lookup_code%TYPE;
3581: l_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
3582:
3583: l_consigned_flag PO_HEADERS.consigned_consumption_flag%TYPE;
3584: l_return_status varchar2(1);
3585: l_msg_data varchar2(2000);

Line 4007: FROM mtl_units_of_measure mum

4003: BEGIN
4004: -- INV expects the uom_code whereas PO stores unit_of_measure.
4005: SELECT mum.uom_code
4006: INTO l_uom_code
4007: FROM mtl_units_of_measure mum
4008: WHERE mum.unit_of_measure = l_transaction_uoms_tbl(i);
4009: EXCEPTION
4010: WHEN OTHERS THEN
4011: l_uom_code := NULL;