DBA Data[Home] [Help]

APPS.RCV_QUANTITIES_S dependencies on MTL_UNITS_OF_MEASURE

Line 1044: mtl_units_of_measure uom

1040: x_qty_rcv_tolerance,
1041: x_item_id,
1042: x_oe_uom
1043: FROM oe_order_lines_all oel,
1044: mtl_units_of_measure uom
1045: WHERE oel.line_id = p_oe_order_line_id
1046: AND uom.uom_code = oel.order_quantity_uom;
1047:
1048: x_progress := '020';

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

2985: dbms_output.put_line ('get_primary_qty : X_organization_Id : '||
2986: TO_CHAR(X_organization_id));*/
2987: /*
2988: ** Check if item_id = 0, if TRUE get primary unit of measure from
2989: ** MTL_UNITS_OF_MEASURE else get primary unit of measure from
2990: ** MTL_SYSTEM_ITEMS
2991: */
2992:
2993: IF (X_item_id IS NULL) THEN

Line 2999: FROM mtl_units_of_measure MUOM1,

2995: X_progress := '1100';
2996:
2997: SELECT MUOM2.unit_of_measure
2998: INTO X_primary_uom
2999: FROM mtl_units_of_measure MUOM1,
3000: mtl_units_of_measure MUOM2
3001: WHERE MUOM1.unit_of_measure = X_transaction_uom
3002: AND MUOM1.uom_class = MUOM2.uom_class
3003: AND MUOM2.base_uom_flag = 'Y';

Line 3000: mtl_units_of_measure MUOM2

2996:
2997: SELECT MUOM2.unit_of_measure
2998: INTO X_primary_uom
2999: FROM mtl_units_of_measure MUOM1,
3000: mtl_units_of_measure MUOM2
3001: WHERE MUOM1.unit_of_measure = X_transaction_uom
3002: AND MUOM1.uom_class = MUOM2.uom_class
3003: AND MUOM2.base_uom_flag = 'Y';
3004: