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.GME_MATERIAL_DETAIL_PVT dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 1010: FROM mtl_transaction_lot_numbers

1006:
1007: CURSOR cur_get_mtl_trxn_lot (v_trans_id NUMBER)
1008: IS
1009: SELECT COUNT (1)
1010: FROM mtl_transaction_lot_numbers
1011: WHERE transaction_id = v_trans_id;
1012:
1013: CURSOR cur_sub_control (v_org_id NUMBER, v_subinventory VARCHAR2)
1014: IS

Line 1238: -- check MTL_TRANSACTION_LOT_NUMBERS table; join on transaction_id = l_trans_id

1234: INTO l_count_lot_trans;
1235:
1236: CLOSE cur_get_mtl_trxn_lot;
1237:
1238: -- check MTL_TRANSACTION_LOT_NUMBERS table; join on transaction_id = l_trans_id
1239: -- if there is more than 1 record there, then can't update these transactions
1240: -- in essence, this is more than 1 transaction.
1241: IF l_count_lot_trans > 1 THEN
1242: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 1249: || ': return -1: 1 trxn in mtl_material_transactions with more than 1 lot entry in mtl_transaction_lot_numbers'

1245: || '.'
1246: || l_api_name
1247: || 'matl_dtl_id= '
1248: || TO_CHAR (l_mtl_dtl_rec.material_detail_id)
1249: || ': return -1: 1 trxn in mtl_material_transactions with more than 1 lot entry in mtl_transaction_lot_numbers'
1250: || ' trans_id= '
1251: || TO_CHAR (l_trans_id) );
1252: END IF;
1253: