APPS.INV_RECEIVING_TRANSACTION dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 484: FROM mtl_material_transactions_temp

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

Line 635: FROM mtl_material_transactions_temp

631: IF (l_rti_rec.mmtt_temp_id IS NOT NULL) THEN
632: UPDATE mtl_txn_request_lines
633: SET wms_process_flag = 1
634: WHERE line_id = (SELECT move_order_line_id
635: FROM mtl_material_transactions_temp
636: WHERE transaction_temp_id = l_rti_rec.mmtt_temp_id);
637: ELSIF (l_rti_rec.lpn_id IS NOT NULL) THEN
638: UPDATE mtl_txn_request_lines
639: SET wms_process_flag = 1

Line 790: FROM mtl_material_transactions_temp

786: IF (l_rti_rec.mmtt_temp_id IS NOT NULL) THEN
787: UPDATE mtl_txn_request_lines
788: SET wms_process_flag = 1
789: WHERE line_id = (SELECT move_order_line_id
790: FROM mtl_material_transactions_temp
791: WHERE transaction_temp_id = l_rti_rec.mmtt_temp_id);
792: ELSIF (l_rti_rec.lpn_id IS NOT NULL) THEN
793: UPDATE mtl_txn_request_lines
794: SET wms_process_flag = 1

Line 946: FROM mtl_material_transactions_temp

942: IF (l_rti_rec.mmtt_temp_id IS NOT NULL) THEN
943: UPDATE mtl_txn_request_lines
944: SET wms_process_flag = 1
945: WHERE line_id = (SELECT move_order_line_id
946: FROM mtl_material_transactions_temp
947: WHERE transaction_temp_id = l_rti_rec.mmtt_temp_id);
948: ELSIF (l_rti_rec.lpn_id IS NOT NULL) THEN
949: UPDATE mtl_txn_request_lines
950: SET wms_process_flag = 1