Total Pageviews

July 21, 2017

7/21/2017 10:12:00 AM

Oracle Applications Order Management Technical Review

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
 
Related Posts Plugin for WordPress, Blogger...