APPS.INV_RECEIVING_TRANSACTION dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 483: FROM mtl_material_transactions_temp

479: IF (l_rti_rec.mmtt_temp_id IS NOT NULL) THEN
480: UPDATE mtl_txn_request_lines
481: SET wms_process_flag = 1
482: WHERE line_id = (SELECT move_order_line_id
483: FROM mtl_material_transactions_temp
484: WHERE transaction_temp_id = l_rti_rec.mmtt_temp_id);
485: ELSIF (l_rti_rec.lpn_id IS NOT NULL) THEN
486: UPDATE mtl_txn_request_lines
487: SET wms_process_flag = 1

Line 576: FROM mtl_material_transactions_temp

572: IF (l_rti_rec.mmtt_temp_id IS NOT NULL) THEN
573: UPDATE mtl_txn_request_lines
574: SET wms_process_flag = 1
575: WHERE line_id = (SELECT move_order_line_id
576: FROM mtl_material_transactions_temp
577: WHERE transaction_temp_id = l_rti_rec.mmtt_temp_id);
578: ELSIF (l_rti_rec.lpn_id IS NOT NULL) THEN
579: UPDATE mtl_txn_request_lines
580: SET wms_process_flag = 1

Line 670: FROM mtl_material_transactions_temp

666: IF (l_rti_rec.mmtt_temp_id IS NOT NULL) THEN
667: UPDATE mtl_txn_request_lines
668: SET wms_process_flag = 1
669: WHERE line_id = (SELECT move_order_line_id
670: FROM mtl_material_transactions_temp
671: WHERE transaction_temp_id = l_rti_rec.mmtt_temp_id);
672: ELSIF (l_rti_rec.lpn_id IS NOT NULL) THEN
673: UPDATE mtl_txn_request_lines
674: SET wms_process_flag = 1

Line 765: FROM mtl_material_transactions_temp

761: IF (l_rti_rec.mmtt_temp_id IS NOT NULL) THEN
762: UPDATE mtl_txn_request_lines
763: SET wms_process_flag = 1
764: WHERE line_id = (SELECT move_order_line_id
765: FROM mtl_material_transactions_temp
766: WHERE transaction_temp_id = l_rti_rec.mmtt_temp_id);
767: ELSIF (l_rti_rec.lpn_id IS NOT NULL) THEN
768: UPDATE mtl_txn_request_lines
769: SET wms_process_flag = 1