eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JMF_SHIKYU_AUTO_RCV_PROC dependencies on MTL_UNITS_OF_MEASURE_TL

Line 988: l_primary_uom_code mtl_units_of_measure_tl.uom_code%TYPE;

984: l_line_quantity oe_order_lines_all.shipped_quantity%TYPE;
985: l_returned_quantity NUMBER;
986: l_received_quantity NUMBER;
987:
988: l_primary_uom_code mtl_units_of_measure_tl.uom_code%TYPE;
989:
990: l_prm_uom_quantity_so NUMBER;
991: l_prm_uom_quantity_po NUMBER;
992:

Line 993: l_po_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;

989:
990: l_prm_uom_quantity_so NUMBER;
991: l_prm_uom_quantity_po NUMBER;
992:
993: l_po_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
994: l_po_uom_code mtl_units_of_measure_tl.uom_code%TYPE;
995:
996: l_item_id oe_order_lines_all.inventory_item_id%TYPE;
997: l_uom_code oe_order_lines_all.shipping_quantity_uom%TYPE;

Line 994: l_po_uom_code mtl_units_of_measure_tl.uom_code%TYPE;

990: l_prm_uom_quantity_so NUMBER;
991: l_prm_uom_quantity_po NUMBER;
992:
993: l_po_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
994: l_po_uom_code mtl_units_of_measure_tl.uom_code%TYPE;
995:
996: l_item_id oe_order_lines_all.inventory_item_id%TYPE;
997: l_uom_code oe_order_lines_all.shipping_quantity_uom%TYPE;
998:

Line 1137: FROM mtl_units_of_measure_tl uom

1133:
1134: BEGIN
1135: SELECT DISTINCT uom.uom_code
1136: INTO l_po_uom_code
1137: FROM mtl_units_of_measure_tl uom
1138: WHERE uom.unit_of_measure = l_po_uom
1139: AND uom.LANGUAGE = userenv('LANG');
1140:
1141: EXCEPTION

Line 1208: l_uom mtl_units_of_measure_tl.uom_code%TYPE;

1204: l_api_name VARCHAR2(100) := 'get_backorder_shipped_quantity';
1205: l_shipped_quantity NUMBER;
1206: l_shipped_quantity_amount NUMBER;
1207: l_inventory_item_id NUMBER;
1208: l_uom mtl_units_of_measure_tl.uom_code%TYPE;
1209: l_line_count NUMBER;
1210: l_prm_uom_quantity_so NUMBER;
1211:
1212: CURSOR back_order_line_c (p_so_header_id IN NUMBER,p_line_id IN NUMBER)

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

1620: l_task_id OE_ORDER_LINES_ALL.task_id%TYPE;
1621:
1622: l_group_id rcv_headers_interface.group_id%TYPE;
1623: l_return_number NUMBER;
1624: --l_unit_of_measure mtl_units_of_measure_tl.unit_of_measure%TYPE;
1625:
1626: l_rcv_header_id NUMBER;
1627: l_transaction_type VARCHAR2(20) := 'RECEIVE';
1628:

Line 1679: l_primary_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;

1675: l_prm_uom_quantity_ordered po_distributions_all.quantity_ordered%TYPE;
1676: l_prm_uom_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
1677: l_prm_uom_allocated_quantity NUMBER;
1678: l_prm_uom_receive_quantity NUMBER;
1679: l_primary_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1680: l_po_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1681: l_so_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1682: l_item_id oe_order_lines_all.inventory_item_id%TYPE;
1683:

Line 1680: l_po_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;

1676: l_prm_uom_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
1677: l_prm_uom_allocated_quantity NUMBER;
1678: l_prm_uom_receive_quantity NUMBER;
1679: l_primary_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1680: l_po_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1681: l_so_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1682: l_item_id oe_order_lines_all.inventory_item_id%TYPE;
1683:
1684: BEGIN

Line 1681: l_so_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;

1677: l_prm_uom_allocated_quantity NUMBER;
1678: l_prm_uom_receive_quantity NUMBER;
1679: l_primary_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1680: l_po_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1681: l_so_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1682: l_item_id oe_order_lines_all.inventory_item_id%TYPE;
1683:
1684: BEGIN
1685: JMF_SHIKYU_UTIL.debug_output