APPS.GME_TRANSACTIONS_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 481: from mtl_material_transactions_temp

477: IF (g_debug <= gme_debug.g_log_statement) THEN
478: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'after validate transactions:'|| l_ret);
479: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'x_trans_count:'|| l_txn_count);
480: select count(*) into l_cnt_temp
481: from mtl_material_transactions_temp
482: where transaction_header_id= gme_common_pvt.g_transaction_header_id;
483: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'count from temp table:'|| l_cnt_temp);
484: END IF;
485: IF l_ret < 0 THEN

Line 4506: FROM mtl_material_transactions_temp

4502:
4503: CURSOR get_error_temp
4504: IS
4505: SELECT ERROR_CODE, error_explanation
4506: FROM mtl_material_transactions_temp
4507: WHERE transaction_header_id =gme_common_pvt.g_transaction_header_id
4508: AND error_explanation IS NOT NULL;
4509:
4510: l_api_name CONSTANT VARCHAR2 (30) := 'PROCESS_TRANSACTIONS';

Line 4535: FROM mtl_material_transactions_temp

4531: Select sum(cnt)
4532: INTO int_rec_count
4533: FROM (
4534: SELECT COUNT (*) cnt
4535: FROM mtl_material_transactions_temp
4536: WHERE transaction_header_id = p_header_id
4537: AND process_flag = 'Y'
4538: UNION ALL
4539: SELECT COUNT (*) cnt

Line 4602: FROM mtl_material_transactions_temp

4598: -- Bug 14297117. Update the Supplier lot number
4599: IF (p_table = 2) THEN
4600: FOR mmtt_rec_cur in
4601: (SELECT transaction_temp_id, inventory_item_id, organization_id
4602: FROM mtl_material_transactions_temp
4603: WHERE transaction_header_id = p_header_id
4604: AND process_flag = 'Y') LOOP
4605: UPDATE mtl_transaction_lots_temp mtlt
4606: SET (grade_code, supplier_lot_number) =