APPS.WMS_RETURN_SV dependencies on MTL_TXN_REQUEST_LINES

Line 184: FROM mtl_txn_request_lines mol, rcv_transactions rt

180: , rt.quantity rt_quantity
181: , rt.primary_unit_of_measure
182: , rt.unit_of_measure
183: , rt.organization_id
184: FROM mtl_txn_request_lines mol, rcv_transactions rt
185: WHERE rt.transaction_id = l_transaction_id
186: AND mol.organization_id = v_organization_id
187: AND rt.organization_id = v_organization_id
188: AND mol.reference_id = v_reference_id

Line 494: --UPDATE mtl_txn_request_lines

490: END;
491:
492: -- Donot need to do this since it will get updated in
493: -- the end anyway.
494: --UPDATE mtl_txn_request_lines
495: --SET wms_process_flag = 1
496: --WHERE txn_source_id = i.interface_transaction_id;
497: END IF;
498: l_update_lpn := l_lpn_id;

Line 509: UPDATE mtl_txn_request_lines

505: -- wms_process_flag = 1.
506: IF (l_debug = 1) THEN
507: print_debug('Updating MOLs for:'||l_update_lpn);
508: END IF;
509: UPDATE mtl_txn_request_lines
510: SET wms_process_flag = 1
511: , txn_source_line_detail_id = NULL
512: WHERE lpn_id = l_update_lpn
513: AND txn_source_line_detail_id = i.interface_transaction_id;

Line 544: UPDATE mtl_txn_request_lines

540: -- of a rtv/rtc from inventory we dont need to update or create
541: -- any mol but we do need to update the process_flag as that
542: -- was updated.
543: l_lpn_id := NULL;
544: UPDATE mtl_txn_request_lines
545: SET wms_process_flag = 1
546: , txn_source_line_detail_id = NULL
547: WHERE lpn_id = i.lpn_id
548: AND txn_source_line_detail_id = i.interface_transaction_id;

Line 810: UPDATE mtl_txn_request_lines

806:
807: /* We have enough qty in MO Line, hence consume it and exit */
808: /* Substract the MO Line qty with l_mol_qty_in_primary_uom */
809:
810: UPDATE mtl_txn_request_lines
811: SET quantity = quantity - l_rt_qty_in_mol_uom
812: , primary_quantity = primary_quantity - l_rt_qty_in_primary_uom
813: WHERE header_id = j.header_id
814: AND nvl(lot_number,'@@@') = nvl(j.lot_number,'@@@')

Line 823: UPDATE mtl_txn_request_lines

819: END IF;
820:
821:
822: -- 4389811 updating line status to 5 for closed MO
823: UPDATE mtl_txn_request_lines
824: SET line_status=5
825: WHERE header_id = j.header_id
826: AND line_id = j.line_id
827: AND ( nvl(quantity,0) = 0 OR

Line 845: UPDATE mtl_txn_request_lines

841: ELSE
842: /* We don't have enough qty in MO Line, hence consume it and proceed to next loop */
843: /* Substract the MO Line qty with l_mol_qty_in_primary_uom */
844:
845: UPDATE mtl_txn_request_lines
846: SET quantity = quantity - abs(j.mol_available_quantity) --l_rt_qty_in_mol_uom
847: , primary_quantity = primary_quantity - l_mol_qty_in_primary_uom
848: WHERE header_id = j.header_id
849: AND nvl(lot_number,'@@@') = nvl(j.lot_number,'@@@')

Line 857: UPDATE mtl_txn_request_lines

853: print_debug(' Before update of mtrl within ELSE');
854: END IF;
855:
856: -- 4389811 updating line status to 5 for closed MO
857: UPDATE mtl_txn_request_lines
858: SET line_status=5
859: WHERE header_id = j.header_id
860: AND line_id = j.line_id
861: AND ( nvl(quantity,0) = 0 OR

Line 895: UPDATE mtl_txn_request_lines

891: x_return_status := FND_API.G_RET_STS_ERROR;
892: RAISE fnd_api.g_exc_error; --return;
893: END IF;
894:
895: UPDATE mtl_txn_request_lines
896: SET wms_process_flag = 1
897: , txn_source_line_detail_id = NULL
898: WHERE lpn_id = l_lpn_id
899: AND txn_source_line_detail_id = i.interface_transaction_id;

Line 2663: UPDATE mtl_txn_request_lines

2659: --WHERE organization_id = p_org_id
2660: --AND lpn_id = p_lpn_id;
2661: END IF;
2662:
2663: UPDATE mtl_txn_request_lines
2664: SET wms_process_flag = 2
2665: , txn_source_line_detail_id = p_rcv_trx_interface_id
2666: WHERE lpn_id = p_lpn_id;
2667:

Line 3668: UPDATE mtl_txn_request_lines

3664: UPDATE wms_license_plate_numbers
3665: SET lpn_context = wms_container_pub.lpn_context_rcv
3666: WHERE lpn_id = p_lpn_id;
3667:
3668: UPDATE mtl_txn_request_lines
3669: SET wms_process_flag = 2
3670: , txn_source_line_detail_id = p_rcv_trx_interface_id
3671: WHERE lpn_id = p_lpn_id;
3672: