DBA Data[Home] [Help]

APPS.RCV_QUANTITIES_S dependencies on MTL_UNITS_OF_MEASURE

Line 1256: mtl_units_of_measure uom

1252: x_qty_rcv_tolerance,
1253: x_item_id,
1254: x_oe_uom
1255: FROM oe_order_lines_all oel,
1256: mtl_units_of_measure uom
1257: WHERE oel.line_id = p_oe_order_line_id
1258: AND uom.uom_code = oel.order_quantity_uom;
1259:
1260: x_progress := '020';

Line 3873: ** MTL_UNITS_OF_MEASURE else get primary unit of measure from

3869: dbms_output.put_line ('get_primary_qty : X_organization_Id : '||
3870: TO_CHAR(X_organization_id));*/
3871: /*
3872: ** Check if item_id = 0, if TRUE get primary unit of measure from
3873: ** MTL_UNITS_OF_MEASURE else get primary unit of measure from
3874: ** MTL_SYSTEM_ITEMS
3875: */
3876:
3877: IF (X_item_id IS NULL) THEN

Line 3883: FROM mtl_units_of_measure MUOM1,

3879: X_progress := '1100';
3880:
3881: SELECT MUOM2.unit_of_measure
3882: INTO X_primary_uom
3883: FROM mtl_units_of_measure MUOM1,
3884: mtl_units_of_measure MUOM2
3885: WHERE MUOM1.unit_of_measure = X_transaction_uom
3886: AND MUOM1.uom_class = MUOM2.uom_class
3887: AND MUOM2.base_uom_flag = 'Y';

Line 3884: mtl_units_of_measure MUOM2

3880:
3881: SELECT MUOM2.unit_of_measure
3882: INTO X_primary_uom
3883: FROM mtl_units_of_measure MUOM1,
3884: mtl_units_of_measure MUOM2
3885: WHERE MUOM1.unit_of_measure = X_transaction_uom
3886: AND MUOM1.uom_class = MUOM2.uom_class
3887: AND MUOM2.base_uom_flag = 'Y';
3888: