APPS.INV_RECEIVING_TRANSACTION dependencies on MTL_TXN_REQUEST_LINES

Line 337: DELETE mtl_txn_request_lines

333: print_debug('rcv_txn_clean_up 40: delete MO Lines RTI ',4);
334: END IF;
335: l_progress := '90';
336:
337: DELETE mtl_txn_request_lines
338: WHERE line_id IN
339: (SELECT line_id
340: FROM rcv_transactions_interface rti
341: , mtl_txn_request_lines mol

Line 341: , mtl_txn_request_lines mol

337: DELETE mtl_txn_request_lines
338: WHERE line_id IN
339: (SELECT line_id
340: FROM rcv_transactions_interface rti
341: , mtl_txn_request_lines mol
342: WHERE rti.group_id = p_group_id
343: AND mol.txn_source_id = rti.interface_transaction_id
344: AND mol.organization_id = rti.to_organization_id
345: AND mol.inventory_item_id = rti.item_id);

Line 481: UPDATE mtl_txn_request_lines

477: --we cannot join on MOL.TXN_SOURCE_ID. Instead, we make
478: --use of rti.mmtt_temp_id if present. If not, we can only
479: --update all MOL for the given org/item combination
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);

Line 487: UPDATE mtl_txn_request_lines

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
489: WHERE organization_id = l_rti_rec.to_organization_id
490: AND lpn_id = l_rti_rec.lpn_id
491: AND wms_process_flag = 2;

Line 493: UPDATE mtl_txn_request_lines

489: WHERE organization_id = l_rti_rec.to_organization_id
490: AND lpn_id = l_rti_rec.lpn_id
491: AND wms_process_flag = 2;
492: ELSE
493: UPDATE mtl_txn_request_lines
494: SET wms_process_flag = 1
495: WHERE organization_id = l_rti_rec.to_organization_id
496: AND inventory_item_id = l_rti_rec.item_id
497: AND Nvl(revision,'#$!') = Nvl(l_rti_rec.item_revision,'#$!')

Line 632: UPDATE mtl_txn_request_lines

628: --we cannot join on MOL.TXN_SOURCE_ID. Instead, we make
629: --use of rti.mmtt_temp_id if present. If not, we can only
630: --update all MOL for the given org/item combination
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);

Line 638: UPDATE mtl_txn_request_lines

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
640: WHERE organization_id = l_rti_rec.to_organization_id
641: AND lpn_id = l_rti_rec.lpn_id
642: AND wms_process_flag = 2;

Line 644: UPDATE mtl_txn_request_lines

640: WHERE organization_id = l_rti_rec.to_organization_id
641: AND lpn_id = l_rti_rec.lpn_id
642: AND wms_process_flag = 2;
643: ELSE
644: UPDATE mtl_txn_request_lines
645: SET wms_process_flag = 1
646: WHERE organization_id = l_rti_rec.to_organization_id
647: AND inventory_item_id = l_rti_rec.item_id
648: AND wms_process_flag = 2

Line 787: UPDATE mtl_txn_request_lines

783: --we cannot join on MOL.TXN_SOURCE_ID. Instead, we make
784: --use of rti.mmtt_temp_id if present. If not, we can only
785: --update all MOL for the given org/item combination
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);

Line 793: UPDATE mtl_txn_request_lines

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
795: WHERE organization_id = l_rti_rec.to_organization_id
796: AND lpn_id = l_rti_rec.lpn_id
797: AND wms_process_flag = 2;

Line 799: UPDATE mtl_txn_request_lines

795: WHERE organization_id = l_rti_rec.to_organization_id
796: AND lpn_id = l_rti_rec.lpn_id
797: AND wms_process_flag = 2;
798: ELSE
799: UPDATE mtl_txn_request_lines
800: SET wms_process_flag = 1
801: WHERE organization_id = l_rti_rec.to_organization_id
802: AND inventory_item_id = l_rti_rec.item_id
803: AND wms_process_flag = 2

Line 943: UPDATE mtl_txn_request_lines

939: --we cannot join on MOL.TXN_SOURCE_ID. Instead, we make
940: --use of rti.mmtt_temp_id if present. If not, we can only
941: --update all MOL for the given org/item combination
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);

Line 949: UPDATE mtl_txn_request_lines

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
951: WHERE organization_id = l_rti_rec.to_organization_id
952: AND lpn_id = l_rti_rec.lpn_id
953: AND wms_process_flag = 2;

Line 955: UPDATE mtl_txn_request_lines

951: WHERE organization_id = l_rti_rec.to_organization_id
952: AND lpn_id = l_rti_rec.lpn_id
953: AND wms_process_flag = 2;
954: ELSE
955: UPDATE mtl_txn_request_lines
956: SET wms_process_flag = 1
957: WHERE organization_id = l_rti_rec.to_organization_id
958: AND inventory_item_id = l_rti_rec.item_id
959: AND wms_process_flag = 2