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 970: FROM mtl_transaction_lot_numbers

966:
967: CURSOR cur_get_mtl_trxn_lot (v_trans_id NUMBER)
968: IS
969: SELECT COUNT (1)
970: FROM mtl_transaction_lot_numbers
971: WHERE transaction_id = v_trans_id;
972:
973: CURSOR cur_sub_control (v_org_id NUMBER, v_subinventory VARCHAR2)
974: IS

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

1194: INTO l_count_lot_trans;
1195:
1196: CLOSE cur_get_mtl_trxn_lot;
1197:
1198: -- check MTL_TRANSACTION_LOT_NUMBERS table; join on transaction_id = l_trans_id
1199: -- if there is more than 1 record there, then can't update these transactions
1200: -- in essence, this is more than 1 transaction.
1201: IF l_count_lot_trans > 1 THEN
1202: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

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

1205: || '.'
1206: || l_api_name
1207: || 'matl_dtl_id= '
1208: || TO_CHAR (l_mtl_dtl_rec.material_detail_id)
1209: || ': return -1: 1 trxn in mtl_material_transactions with more than 1 lot entry in mtl_transaction_lot_numbers'
1210: || ' trans_id= '
1211: || TO_CHAR (l_trans_id) );
1212: END IF;
1213: