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 480: UPDATE mtl_txn_request_lines

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

Line 486: UPDATE mtl_txn_request_lines

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

Line 492: UPDATE mtl_txn_request_lines

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

Line 573: UPDATE mtl_txn_request_lines

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

Line 579: UPDATE mtl_txn_request_lines

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
581: WHERE organization_id = l_rti_rec.to_organization_id
582: AND lpn_id = l_rti_rec.lpn_id
583: AND wms_process_flag = 2;

Line 585: UPDATE mtl_txn_request_lines

581: WHERE organization_id = l_rti_rec.to_organization_id
582: AND lpn_id = l_rti_rec.lpn_id
583: AND wms_process_flag = 2;
584: ELSE
585: UPDATE mtl_txn_request_lines
586: SET wms_process_flag = 1
587: WHERE organization_id = l_rti_rec.to_organization_id
588: AND inventory_item_id = l_rti_rec.item_id
589: AND wms_process_flag = 2

Line 667: UPDATE mtl_txn_request_lines

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

Line 673: UPDATE mtl_txn_request_lines

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
675: WHERE organization_id = l_rti_rec.to_organization_id
676: AND lpn_id = l_rti_rec.lpn_id
677: AND wms_process_flag = 2;

Line 679: UPDATE mtl_txn_request_lines

675: WHERE organization_id = l_rti_rec.to_organization_id
676: AND lpn_id = l_rti_rec.lpn_id
677: AND wms_process_flag = 2;
678: ELSE
679: UPDATE mtl_txn_request_lines
680: SET wms_process_flag = 1
681: WHERE organization_id = l_rti_rec.to_organization_id
682: AND inventory_item_id = l_rti_rec.item_id
683: AND wms_process_flag = 2

Line 762: UPDATE mtl_txn_request_lines

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

Line 768: UPDATE mtl_txn_request_lines

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
770: WHERE organization_id = l_rti_rec.to_organization_id
771: AND lpn_id = l_rti_rec.lpn_id
772: AND wms_process_flag = 2;

Line 774: UPDATE mtl_txn_request_lines

770: WHERE organization_id = l_rti_rec.to_organization_id
771: AND lpn_id = l_rti_rec.lpn_id
772: AND wms_process_flag = 2;
773: ELSE
774: UPDATE mtl_txn_request_lines
775: SET wms_process_flag = 1
776: WHERE organization_id = l_rti_rec.to_organization_id
777: AND inventory_item_id = l_rti_rec.item_id
778: AND wms_process_flag = 2