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

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 1666: MTL_UNITS_OF_MEASURE uom,

1662: uom.unit_of_measure,
1663: oola.inventory_item_id
1664: FROM po_distributions_all d,
1665: po_line_locations_all l,
1666: MTL_UNITS_OF_MEASURE uom,
1667: jmf_shikyu_replenishments jsr,
1668: oe_order_lines_all oola
1669: WHERE d.line_location_id = p_location_id
1670: AND d.LINE_LOCATION_ID = jsr.replenishment_PO_shipment_ID

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

Line 1763: mtl_units_of_measure_vl uom

1759: uom.unit_of_measure
1760: INTO
1761: l_primary_uom
1762: FROM
1763: mtl_units_of_measure_vl uom
1764: WHERE uom.uom_code = p_primary_uom_code;
1765: EXCEPTION
1766: WHEN no_data_found THEN
1767: JMF_SHIKYU_UTIL.debug_output