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.INV_RCV_STD_TRANSFER_APIS dependencies on MTL_UNITS_OF_MEASURE

Line 828: l_rcvtxn_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

824: l_avail_transfer_qty NUMBER; --Quantity available to transfer
825: l_avail_primary_qty NUMBER; --Quantity in primary UOM
826: l_rcvtxn_qty NUMBER; --Parent transaction qty
827: l_rcvqty_txn_uom NUMBER; --Available Qty in txn uom
828: l_rcvtxn_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
829: l_rcvtxn_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
830: l_tolerable_qty NUMBER;
831: l_lpn_count NUMBER; --Count of RT records for the LPN ID
832: l_lot_count NUMBER; --Count of RLS records for the given lot

Line 829: l_rcvtxn_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;

825: l_avail_primary_qty NUMBER; --Quantity in primary UOM
826: l_rcvtxn_qty NUMBER; --Parent transaction qty
827: l_rcvqty_txn_uom NUMBER; --Available Qty in txn uom
828: l_rcvtxn_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
829: l_rcvtxn_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
830: l_tolerable_qty NUMBER;
831: l_lpn_count NUMBER; --Count of RT records for the LPN ID
832: l_lot_count NUMBER; --Count of RLS records for the given lot
833:

Line 1213: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;

1209: --Local variables
1210: l_parent_transaction_id NUMBER; --Transaction ID of the parent RT record
1211: l_con_transfer_qty NUMBER; --Qty converted in MOL UOM code
1212: l_primary_qty NUMBER; --Quantity in primay uom code
1213: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1214: l_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
1215: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
1216: l_transfer_uom_code mtl_units_of_measure.uom_code%TYPE;
1217: l_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp;

Line 1214: l_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;

1210: l_parent_transaction_id NUMBER; --Transaction ID of the parent RT record
1211: l_con_transfer_qty NUMBER; --Qty converted in MOL UOM code
1212: l_primary_qty NUMBER; --Quantity in primay uom code
1213: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1214: l_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
1215: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
1216: l_transfer_uom_code mtl_units_of_measure.uom_code%TYPE;
1217: l_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp;
1218: l_rcvtxn_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_enter_rec_cursor_rec;

Line 1215: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;

1211: l_con_transfer_qty NUMBER; --Qty converted in MOL UOM code
1212: l_primary_qty NUMBER; --Quantity in primay uom code
1213: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1214: l_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
1215: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
1216: l_transfer_uom_code mtl_units_of_measure.uom_code%TYPE;
1217: l_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp;
1218: l_rcvtxn_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_enter_rec_cursor_rec;
1219: l_receipt_source_code RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE;

Line 1216: l_transfer_uom_code mtl_units_of_measure.uom_code%TYPE;

1212: l_primary_qty NUMBER; --Quantity in primay uom code
1213: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1214: l_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
1215: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
1216: l_transfer_uom_code mtl_units_of_measure.uom_code%TYPE;
1217: l_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp;
1218: l_rcvtxn_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_enter_rec_cursor_rec;
1219: l_receipt_source_code RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE;
1220: l_parent_txn_id NUMBER;

Line 1227: l_sec_transfer_uom_code mtl_units_of_measure.uom_code%TYPE; --OPM Convergence

1223: l_progress NUMBER; --Index to track progress and log error
1224: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1225:
1226: --OPM Convergence
1227: l_sec_transfer_uom_code mtl_units_of_measure.uom_code%TYPE; --OPM Convergence
1228: l_secondary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1229: l_sec_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
1230: l_secondary_uom_code mtl_units_of_measure.uom_code%TYPE;
1231: l_sec_um_xfer_qty NUMBER;

Line 1228: l_secondary_uom mtl_units_of_measure.unit_of_measure%TYPE;

1224: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1225:
1226: --OPM Convergence
1227: l_sec_transfer_uom_code mtl_units_of_measure.uom_code%TYPE; --OPM Convergence
1228: l_secondary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1229: l_sec_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
1230: l_secondary_uom_code mtl_units_of_measure.uom_code%TYPE;
1231: l_sec_um_xfer_qty NUMBER;
1232:

Line 1229: l_sec_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;

1225:
1226: --OPM Convergence
1227: l_sec_transfer_uom_code mtl_units_of_measure.uom_code%TYPE; --OPM Convergence
1228: l_secondary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1229: l_sec_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
1230: l_secondary_uom_code mtl_units_of_measure.uom_code%TYPE;
1231: l_sec_um_xfer_qty NUMBER;
1232:
1233: l_secondary_qty NUMBER;

Line 1230: l_secondary_uom_code mtl_units_of_measure.uom_code%TYPE;

1226: --OPM Convergence
1227: l_sec_transfer_uom_code mtl_units_of_measure.uom_code%TYPE; --OPM Convergence
1228: l_secondary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1229: l_sec_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
1230: l_secondary_uom_code mtl_units_of_measure.uom_code%TYPE;
1231: l_sec_um_xfer_qty NUMBER;
1232:
1233: l_secondary_qty NUMBER;
1234:

Line 1646: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;

1642: --Local variables
1643: l_parent_transaction_id NUMBER; --Transaction ID of the parent RT record
1644: l_con_transfer_qty NUMBER; --Qty converted in MOL UOM code
1645: l_primary_qty NUMBER; --Quantity in primay uom code
1646: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1647: l_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
1648: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
1649: l_transfer_uom_code mtl_units_of_measure.uom_code%TYPE;
1650: l_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp;

Line 1647: l_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;

1643: l_parent_transaction_id NUMBER; --Transaction ID of the parent RT record
1644: l_con_transfer_qty NUMBER; --Qty converted in MOL UOM code
1645: l_primary_qty NUMBER; --Quantity in primay uom code
1646: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1647: l_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
1648: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
1649: l_transfer_uom_code mtl_units_of_measure.uom_code%TYPE;
1650: l_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp;
1651: l_rcvtxn_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_enter_rec_cursor_rec;

Line 1648: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;

1644: l_con_transfer_qty NUMBER; --Qty converted in MOL UOM code
1645: l_primary_qty NUMBER; --Quantity in primay uom code
1646: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1647: l_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
1648: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
1649: l_transfer_uom_code mtl_units_of_measure.uom_code%TYPE;
1650: l_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp;
1651: l_rcvtxn_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_enter_rec_cursor_rec;
1652: l_receipt_source_code RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE;

Line 1649: l_transfer_uom_code mtl_units_of_measure.uom_code%TYPE;

1645: l_primary_qty NUMBER; --Quantity in primay uom code
1646: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1647: l_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
1648: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
1649: l_transfer_uom_code mtl_units_of_measure.uom_code%TYPE;
1650: l_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp;
1651: l_rcvtxn_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_enter_rec_cursor_rec;
1652: l_receipt_source_code RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE;
1653: l_parent_txn_id NUMBER;

Line 1658: l_sec_transfer_uom_code mtl_units_of_measure.uom_code%TYPE; --OPM Convergence

1654: l_um_transfer_qty NUMBER; --Transfer quantity converted to MOL UOM
1655: l_progress NUMBER; --Index to track progress and log error
1656: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1657: --OPM Convergence
1658: l_sec_transfer_uom_code mtl_units_of_measure.uom_code%TYPE; --OPM Convergence
1659: l_secondary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1660: l_sec_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
1661: l_secondary_uom_code mtl_units_of_measure.uom_code%TYPE;
1662: l_sec_um_xfer_qty NUMBER;

Line 1659: l_secondary_uom mtl_units_of_measure.unit_of_measure%TYPE;

1655: l_progress NUMBER; --Index to track progress and log error
1656: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1657: --OPM Convergence
1658: l_sec_transfer_uom_code mtl_units_of_measure.uom_code%TYPE; --OPM Convergence
1659: l_secondary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1660: l_sec_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
1661: l_secondary_uom_code mtl_units_of_measure.uom_code%TYPE;
1662: l_sec_um_xfer_qty NUMBER;
1663:

Line 1660: l_sec_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;

1656: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1657: --OPM Convergence
1658: l_sec_transfer_uom_code mtl_units_of_measure.uom_code%TYPE; --OPM Convergence
1659: l_secondary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1660: l_sec_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
1661: l_secondary_uom_code mtl_units_of_measure.uom_code%TYPE;
1662: l_sec_um_xfer_qty NUMBER;
1663:
1664: l_secondary_qty NUMBER;

Line 1661: l_secondary_uom_code mtl_units_of_measure.uom_code%TYPE;

1657: --OPM Convergence
1658: l_sec_transfer_uom_code mtl_units_of_measure.uom_code%TYPE; --OPM Convergence
1659: l_secondary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1660: l_sec_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
1661: l_secondary_uom_code mtl_units_of_measure.uom_code%TYPE;
1662: l_sec_um_xfer_qty NUMBER;
1663:
1664: l_secondary_qty NUMBER;
1665: BEGIN

Line 2062: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;

2058: --Local variables
2059: l_parent_transaction_id NUMBER; --Transaction ID of the parent RT record
2060: l_con_transfer_qty NUMBER; --Qty converted in MOL UOM code
2061: l_primary_qty NUMBER; --Quantity in primay uom code
2062: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
2063: l_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
2064: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
2065: l_transfer_uom_code mtl_units_of_measure.uom_code%TYPE;
2066: l_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp;

Line 2063: l_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;

2059: l_parent_transaction_id NUMBER; --Transaction ID of the parent RT record
2060: l_con_transfer_qty NUMBER; --Qty converted in MOL UOM code
2061: l_primary_qty NUMBER; --Quantity in primay uom code
2062: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
2063: l_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
2064: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
2065: l_transfer_uom_code mtl_units_of_measure.uom_code%TYPE;
2066: l_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp;
2067: l_rcvtxn_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_enter_rec_cursor_rec;

Line 2064: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;

2060: l_con_transfer_qty NUMBER; --Qty converted in MOL UOM code
2061: l_primary_qty NUMBER; --Quantity in primay uom code
2062: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
2063: l_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
2064: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
2065: l_transfer_uom_code mtl_units_of_measure.uom_code%TYPE;
2066: l_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp;
2067: l_rcvtxn_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_enter_rec_cursor_rec;
2068: l_receipt_source_code RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE;

Line 2065: l_transfer_uom_code mtl_units_of_measure.uom_code%TYPE;

2061: l_primary_qty NUMBER; --Quantity in primay uom code
2062: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
2063: l_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
2064: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
2065: l_transfer_uom_code mtl_units_of_measure.uom_code%TYPE;
2066: l_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp;
2067: l_rcvtxn_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_enter_rec_cursor_rec;
2068: l_receipt_source_code RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE;
2069: l_parent_txn_id NUMBER;

Line 2076: l_sec_transfer_uom_code mtl_units_of_measure.uom_code%TYPE; --OPM Convergence

2072: l_progress NUMBER; --Index to track progress and log error
2073: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
2074:
2075: --OPM Convergence
2076: l_sec_transfer_uom_code mtl_units_of_measure.uom_code%TYPE; --OPM Convergence
2077: l_secondary_uom mtl_units_of_measure.unit_of_measure%TYPE;
2078: l_sec_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
2079: l_secondary_uom_code mtl_units_of_measure.uom_code%TYPE;
2080: l_sec_um_xfer_qty NUMBER;

Line 2077: l_secondary_uom mtl_units_of_measure.unit_of_measure%TYPE;

2073: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
2074:
2075: --OPM Convergence
2076: l_sec_transfer_uom_code mtl_units_of_measure.uom_code%TYPE; --OPM Convergence
2077: l_secondary_uom mtl_units_of_measure.unit_of_measure%TYPE;
2078: l_sec_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
2079: l_secondary_uom_code mtl_units_of_measure.uom_code%TYPE;
2080: l_sec_um_xfer_qty NUMBER;
2081: l_secondary_qty NUMBER;

Line 2078: l_sec_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;

2074:
2075: --OPM Convergence
2076: l_sec_transfer_uom_code mtl_units_of_measure.uom_code%TYPE; --OPM Convergence
2077: l_secondary_uom mtl_units_of_measure.unit_of_measure%TYPE;
2078: l_sec_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
2079: l_secondary_uom_code mtl_units_of_measure.uom_code%TYPE;
2080: l_sec_um_xfer_qty NUMBER;
2081: l_secondary_qty NUMBER;
2082:

Line 2079: l_secondary_uom_code mtl_units_of_measure.uom_code%TYPE;

2075: --OPM Convergence
2076: l_sec_transfer_uom_code mtl_units_of_measure.uom_code%TYPE; --OPM Convergence
2077: l_secondary_uom mtl_units_of_measure.unit_of_measure%TYPE;
2078: l_sec_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
2079: l_secondary_uom_code mtl_units_of_measure.uom_code%TYPE;
2080: l_sec_um_xfer_qty NUMBER;
2081: l_secondary_qty NUMBER;
2082:
2083: BEGIN