Oracle Applications Order Management Technical Review
oe_order_lines_all
SHIP_FROM_ORG_ID WAREHOUSE_ID or INVENTORY ORGANIZATION ID
SHIP_TO_ORG_ID HZ_CUST_SITE_USES_ALL.SITE_USE_ID
INVOICE_TO_ORG_ID HZ_CUST_SITE_USES_ALL.SITE_USE_ID
SOLD_TO_ORG_ID CUSTOMER_ID or HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID PRICE_LIST_ID QP_LIST_HEADERS_B.PRICE_LIST_ID
INVENTORY_ITEM_ID MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID
PAYMENT_TERM_ID RA_TERMS.TERM_ID
LINE_CATEGORY_CODE ORDER, RETURN
SALESREP_ID JTF_RS_SALESREPS.SALESREP_ID
ORDER_TYPE_ID OE_TRNSACTION_TYPES_ALL.TRANSACTION_TYPE_ID
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.
BATCH_ID
CUSTOMER_ID HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID
ORDER_HEADER_ID
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.
WSH_DELIVERY_DETAILS:
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
DELIVER_TO_LOCATION_ID HZ_LOCATIONS.LOCATION_ID
SHIP_TO_LOCATION_ID HZ_LOCATIONS.LOCATION_ID
SHIP_FROM_LOCATION_ID WAREHOUSE_ID
CUSTOMER_ID HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID
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
