Scribd
Upload
43 views1 page

BackOrder CheckList

This document contains SQL statements to update transaction request line and delivery assignment records. It sets various fields to NULL or a status of 5, and updates timestamps. It also lists steps to check for related reservation, transaction, license plate, and task records before making the updates.

Uploaded by

Mohankumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
43 views1 page

BackOrder CheckList

This document contains SQL statements to update transaction request line and delivery assignment records. It sets various fields to NULL or a status of 5, and updates timestamps. It also lists steps to check for related reservation, transaction, license plate, and task records before making the updates.

Uploaded by

Mohankumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 1

UPDATE mtl_txn_request_lines

SET quantity_detailed = NULL,


TO_SUBINVENTORY_CODE = NULL,
TO_LOCATOR_ID = NULL,
line_status = 5,
last_update_date = SYSDATE
WHERE LINE_ID = &Enter_MOLineID
AND INVENTORY_ITEM_ID = &Enter_ItemID
AND ORGANIZATION_ID = &Enter_OrgID;

UPDATE wsh_delivery_assignments
SET delivery_id = NULL ,
parent_delivery_detail_id = NULL ,
last_update_date = SYSDATE
WHERE DELIVERY_DETAIL_ID = &Enter_DetailID;

1.Check for reservations


2.Check for mtl_material_transactions_temp
3.Check for LPN data
4.Check for wsh_delivery_assignments (Unassign delivery_id and parent_delivery_id)
5.Check for mtl_txn_request_lines
6.Check for wms_dispatched_tasks if allocation exists.

You might also like