DBA Data[Home] [Help]

APPS.INL_INTERFACE_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 3345: FROM mtl_units_of_measure mum

3341: p_var_value => p_ship_line_int_id) ;
3342:
3343: SELECT COUNT(1)
3344: INTO l_count_txn_uom_valid
3345: FROM mtl_units_of_measure mum
3346: WHERE mum.uom_code = p_txn_uom_code;
3347:
3348: IF NVL(l_count_txn_uom_valid, 0) = 0 THEN
3349: l_debug_info := 'Transaction Uom Code is invalid';

Line 3719: mtl_units_of_measure muom

3715: SELECT rti.uom_code, muom.uom_code, pl.unit_price
3716: INTO l_rcv_uom_code, l_po_uom_code, l_po_unit_price
3717: FROM rcv_transactions_interface rti,
3718: po_lines_all pl,
3719: mtl_units_of_measure muom
3720: WHERE muom.unit_of_measure = pl.unit_meas_lookup_code
3721: AND pl.po_line_id = rti.po_line_id
3722: AND interface_transaction_id = p_interface_source_line_id;
3723:

Line 3868: FROM mtl_units_of_measure mum

3864: p_debug_info => l_debug_info);
3865:
3866: SELECT COUNT(1)
3867: INTO l_count_2ary_uom_vld
3868: FROM mtl_units_of_measure mum
3869: WHERE mum.uom_code = x_2ary_uom_code;
3870:
3871: IF NVL(l_count_2ary_uom_vld,0) = 0 THEN
3872: l_debug_info := 'Secondary Uom Code populated is invalid';

Line 12771: FROM mtl_units_of_measure

12767: BEGIN
12768: -- Get UOM Code
12769: SELECT unit_of_measure
12770: INTO l_uom
12771: FROM mtl_units_of_measure
12772: WHERE uom_code = p_matched_uom_code;
12773: EXCEPTION
12774: WHEN NO_DATA_FOUND THEN
12775: l_result := L_FND_FALSE;