Friday, June 3, 2011

Oracle Order Capture - an Overview.

I would say Order Capture is a virtual module in Oracle CRM. The application code for Oracle Order Capture is ASO.

Order capture is mainly used by Oracle iStore and Oracle Quoting modules. Order capture is a set of APIs being used by these modules in converting the Cart or Quote to Sales order.

The IBE or QOT purely depends on the ASO to convert the cart or quote to Sales Order in Order Management.

The two important tables in ASO,

ASO_QUOTE_HEADERS_ALL
ASO_QUOTE_LINES_ALL

ASO_QUOTE_HEADERS_ALL -- Will have the header level details for Cart or Quote
ASO_QUOTE_LINES_ALL -- will have the line level details for Cart or Quote.


When the Quote or Cart is converted to Sales order, the data from ASO_QUOTE_HEADERS_ALL flows to OE_ORDER_HEADERS_ALL and the data from ASO_QUOTE_LINES_ALL flows to OE_ORDER_LINES_ALL.


ASO_PRICE_ADJUSTMENTS is the another important table which stores the adjustments(modifier) details on the cart or Quote.

There are status column in the ASO headers table to identify the status of the Quote or Cart and the source column to identify the source of the Quote.
Posted by Deep at 9:46 AM
Labels: , ,

3 comments:

  1. AnonymousAugust 29, 2011

    Does anyone know which key tables can be used to join the ASO_QUOTE_HEADERS_ALL flows to OE_ORDER_HEADERS_ALL tables?

    ReplyDelete
  2. Oracle Apps TipsSeptember 03, 2011

    Goal

    How to find the Order Line details relating to a know Quote Line?

    Solution

    If the last line is left commented-out, the following query simply gives a list of the relationships between Order Headers and Quote Headers.

    If you uncomment the last line and enter a Quote Number when prompted, you should get a single Order / Quote relationship:


    select a.order_number, b.quote_number
    from oe_order_headers_all a, aso_quote_headers_all b
    where a.header_id = b.order_id
    -- and b.quote_number = &QuoteNo;


    The following queries relate Order Lines with Quote Lines:


    select a.quote_header_id, a.quote_number, a.order_id, b.order_number,
    b.header_id, c.line_id, e.quote_line_id, e.line_number, f.shipment_id
    from aso_quote_headers_all a, oe_order_headers_all b, oe_order_lines_all c,
    aso_quote_lines_all e, aso_shipments f
    where a.order_id = b.Header_id
    and a.order_id = c.header_id
    and b.header_id = c.header_id
    and a.quote_header_id = e.quote_header_id
    and a.quote_header_id = f.quote_header_id
    and e.quote_line_id = f.quote_line_id
    and f.order_line_id = c.line_id
    -- and a.quote_number = &QuoteNo;


    or (if no Shipment details):


    select a.quote_header_id, a.quote_number, a.order_id, b.order_number,
    b.header_id, c.line_id, e.quote_line_id, e.line_number
    from aso_quote_headers_all a, oe_order_headers_all b, oe_order_lines_all c,
    aso_quote_lines_all e
    where a.order_id = b.Header_id
    and a.order_id = c.header_id
    and b.header_id = c.header_id
    and a.quote_header_id = e.quote_header_id
    -- and a.quote_number = &QuoteNo;

    ReplyDelete
  3. UnknownApril 06, 2017

    michael kors outlet online
    burberry outlet online
    louboutin outlet
    hermes bags
    adidas outlet online
    yeezy shoes
    polo ralph lauren outlet
    hermes bags
    tory burch outlet online
    michael kors outlet store
    xushengda0406

    ReplyDelete

Subscribe to: Post Comments (Atom)