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.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 1867: SELECT LOT_NUMBER FROM mtl_transaction_lots_interface WHERE product_transaction_id=l_transaction_id;

1863: l_sec_lot_spe_tqty NUMBER :=0 ;
1864: /*End Bug 13938193*/
1865:
1866: CURSOR lot_num_cur(l_transaction_id NUMBER) IS
1867: SELECT LOT_NUMBER FROM mtl_transaction_lots_interface WHERE product_transaction_id=l_transaction_id;
1868:
1869: /*Bug 13938193*/
1870: CURSOR lot_num_cur1(l_transaction_id NUMBER) IS
1871: SELECT transaction_quantity, LOT_NUMBER ,SECONDARY_TRANSACTION_QUANTITY FROM mtl_transaction_lots_interface WHERE product_transaction_id=l_transaction_id;

Line 1871: SELECT transaction_quantity, LOT_NUMBER ,SECONDARY_TRANSACTION_QUANTITY FROM mtl_transaction_lots_interface WHERE product_transaction_id=l_transaction_id;

1867: SELECT LOT_NUMBER FROM mtl_transaction_lots_interface WHERE product_transaction_id=l_transaction_id;
1868:
1869: /*Bug 13938193*/
1870: CURSOR lot_num_cur1(l_transaction_id NUMBER) IS
1871: SELECT transaction_quantity, LOT_NUMBER ,SECONDARY_TRANSACTION_QUANTITY FROM mtl_transaction_lots_interface WHERE product_transaction_id=l_transaction_id;
1872: /*End Bug 13938193*/
1873:
1874: BEGIN
1875: l_progress :='0001';