Oracle Applications Order Management Technical Review
SHIP_FROM_ORG_ID WAREHOUSE_ID or INVENTORY ORGANIZATION ID
SOLD_TO_ORG_ID CUSTOMER_ID or HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID PRICE_LIST_ID QP_LIST_HEADERS_B.PRICE_LIST_ID
LINE_CATEGORY_CODE ORDER, RETURN
ORDER_SOURCE_ID Order Source from OE_ORDER_SOURCES
ORIG_SYS_DOCUMENT_REF Quote Number.Version for Sales & Mkting Quote OE_ORDER_HEADERS_ALL<HEADER_ID> for OM SOURCE_DOCUMENT_ID Order Header ID from which order is Copied PRICE_LIST_ID OE_PRICE_LISTS.PRICE_LIST_ID
Pick Release: WSH_PICKING_BATCHES The information filled in the Pick Release form is inserted in this table. System creates one batch for the condition you specify in Pick Release Form.
After Pick Release records goes to WSH_DELIVERY_DETAILS for each line, which is picked or backordered. If Autocreate Deliveries is set to set ‘YES’ then record also goes to WHS_NEW_DELIVERIES and WSH_DELIVERY_ASSIGNMENTS but Pick Release is only Reserving the Items against particular Sales Order Line.
DELIVERY_DETAIL_ID SOURCE_CODE ‘OE’
SOURCE_HEADER_NUMBER Order Number
SOURCE_LINE_NUMBER SOURCE_HEADER_ID Order Header ID
SOURCE_LINE_ID Order Line ID
SOURCE_HEADER_TYPE_ID Order Type ID
SOURCE_HEADER_TYPE_NAME Order Type Name
CUST_PO_NUMBER Customer PO Number
INVENTORY_ITEM_ID & ITEM_DESCRIPTION
REQUESTED_QUANTITY The qty. requested for Pick Release.
If the program reserves partial qty. then it splits the Lines in the Order and also inserts two lines in WSH_DELIVERY_DETAILS. The qty. available for reservation will be REQUESTED_QUANTITY for First record and balance qty. will be REQUESTED_QUANTITY for other record. PICKED_QUANTITY SHIPPED_QUANTITY After Ship Confirm Shipped qty. is updated
SPLIT_FROM_DELIVERY_DETAIL_ID (For Backordered Line)
RELEASED_STATUS (B=Backordered, C=Shipped, D=Cancelled, N=Not ready for release, R=Ready to release, S=Released to Warehouse, X=Not Applicable, Y=Staged