APPS.JMF_SHIKYU_AUTO_RCV_PROC dependencies on MTL_UNITS_OF_MEASURE_TL

Line 1008: l_primary_uom_code mtl_units_of_measure_tl.uom_code%TYPE;

1004: l_line_quantity oe_order_lines_all.shipped_quantity%TYPE;
1005: l_returned_quantity NUMBER;
1006: l_received_quantity NUMBER;
1007:
1008: l_primary_uom_code mtl_units_of_measure_tl.uom_code%TYPE;
1009:
1010: l_prm_uom_quantity_so NUMBER;
1011: l_prm_uom_quantity_po NUMBER;
1012:

Line 1013: l_po_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;

1009:
1010: l_prm_uom_quantity_so NUMBER;
1011: l_prm_uom_quantity_po NUMBER;
1012:
1013: l_po_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1014: l_po_uom_code mtl_units_of_measure_tl.uom_code%TYPE;
1015:
1016: l_item_id oe_order_lines_all.inventory_item_id%TYPE;
1017: l_uom_code oe_order_lines_all.shipping_quantity_uom%TYPE;

Line 1014: l_po_uom_code mtl_units_of_measure_tl.uom_code%TYPE;

1010: l_prm_uom_quantity_so NUMBER;
1011: l_prm_uom_quantity_po NUMBER;
1012:
1013: l_po_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1014: l_po_uom_code mtl_units_of_measure_tl.uom_code%TYPE;
1015:
1016: l_item_id oe_order_lines_all.inventory_item_id%TYPE;
1017: l_uom_code oe_order_lines_all.shipping_quantity_uom%TYPE;
1018:

Line 1157: FROM mtl_units_of_measure_tl uom

1153:
1154: BEGIN
1155: SELECT DISTINCT uom.uom_code
1156: INTO l_po_uom_code
1157: FROM mtl_units_of_measure_tl uom
1158: WHERE uom.unit_of_measure = l_po_uom
1159: AND uom.LANGUAGE = userenv('LANG');
1160:
1161: EXCEPTION

Line 1228: l_uom mtl_units_of_measure_tl.uom_code%TYPE;

1224: l_api_name VARCHAR2(100) := 'get_backorder_shipped_quantity';
1225: l_shipped_quantity NUMBER;
1226: l_shipped_quantity_amount NUMBER;
1227: l_inventory_item_id NUMBER;
1228: l_uom mtl_units_of_measure_tl.uom_code%TYPE;
1229: l_line_count NUMBER;
1230: l_prm_uom_quantity_so NUMBER;
1231:
1232: CURSOR back_order_line_c (p_so_header_id IN NUMBER,p_line_id IN NUMBER)

Line 1644: --l_unit_of_measure mtl_units_of_measure_tl.unit_of_measure%TYPE;

1640: l_task_id OE_ORDER_LINES_ALL.task_id%TYPE;
1641:
1642: l_group_id rcv_headers_interface.group_id%TYPE;
1643: l_return_number NUMBER;
1644: --l_unit_of_measure mtl_units_of_measure_tl.unit_of_measure%TYPE;
1645:
1646: l_rcv_header_id NUMBER;
1647: l_transaction_type VARCHAR2(20) := 'RECEIVE';
1648:

Line 1699: l_primary_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;

1695: l_prm_uom_quantity_ordered po_distributions_all.quantity_ordered%TYPE;
1696: l_prm_uom_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
1697: l_prm_uom_allocated_quantity NUMBER;
1698: l_prm_uom_receive_quantity NUMBER;
1699: l_primary_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1700: l_po_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1701: l_so_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1702: l_item_id oe_order_lines_all.inventory_item_id%TYPE;
1703:

Line 1700: l_po_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;

1696: l_prm_uom_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
1697: l_prm_uom_allocated_quantity NUMBER;
1698: l_prm_uom_receive_quantity NUMBER;
1699: l_primary_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1700: l_po_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1701: l_so_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1702: l_item_id oe_order_lines_all.inventory_item_id%TYPE;
1703:
1704: BEGIN

Line 1701: l_so_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;

1697: l_prm_uom_allocated_quantity NUMBER;
1698: l_prm_uom_receive_quantity NUMBER;
1699: l_primary_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1700: l_po_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1701: l_so_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1702: l_item_id oe_order_lines_all.inventory_item_id%TYPE;
1703:
1704: BEGIN
1705: JMF_SHIKYU_UTIL.debug_output