WSH_DELIVERY_DETAILS.INV_INTERFACED_FLAG
N --> When delivery detail created/ New
Y --> Interfaced to MTI and processed successfully by Trx mgr
P --> Pending Interfaced
WSH_DELIVERY_DETAILS.RELEASED_STATUS
B: Backordered- Line failed to be allocated in Inventory
C: Shipped -Line has been shipped
D: Cancelled -Line is Cancelled
N: Not Ready for Release -Line is not ready to be released
R: Ready to Release: Line is ready to be released
S: Released to Warehouse: Line has been released to Inventory for processing
X: Not Applicable- Line is not applicable for Pick Release
Y: Staged- Line has been picked and staged by Inventory
Points to be noted:
Select delivery_detail_id, oe_interfaced_flag, inv_interfaced_flag from wsh_delivery_details where delivery_detail_id = &Delivery_detail_id;
If the above output does not show ‘Y’ for both oe_interfaced_flag and inv_interfaced_flag the same means that the Interface Trip Stop has not been successful (completed in error) and the same needs to be processed.
If the above output shows ‘P’ for inv_interfaced_flag the same means that the Interface Trip Stop has run into warning & the same needs to be processed
