Search from 700 + Posts

Mar 29, 2013

Query to Join Order Management Tables with Oracle Quoting tables

Query to Join Order Management Tables with Oracle Quoting tables

SELECT ooh.header_id
         , ooh.order_number
         , ool.line_Id
         , ool.ship_from_org_id organization_id
         , ool.inventory_item_id
         , ool.ordered_quantity
         , ool.order_quantity_uom
     , ool.line_type_id  xx_line_type_id
     , qtl.order_line_type_id
   , ool.request_date
     , ool.creation_date
     , ool.ship_to_org_id
     , ool.sold_to_org_id
      , ool.subinventory

    FROM   aso.aso_quote_headers_all qte
         , aso.aso_quote_lines_all qtl
         , aso.aso_shipments shp
         , ont.oe_order_headers_all ooh
         , ont.oe_order_lines_all ool
    WHERE  qte.quote_header_Id = 382
    AND    qtl.quote_header_id = qte.quote_header_id
    AND    shp.quote_header_id = qtl.quote_header_id
    AND    shp.quote_line_id = qtl.quote_line_id
    AND    ooh.orig_sys_document_ref like qte.quote_number||':%'
    AND    ooh.source_document_id = qte.quote_header_id
    AND    ool.header_id = ooh.header_id
    AND    ool.source_document_line_Id = shp.shipment_id ;

7 comments:

  1. This is an awesome blog for this technology. Keep updating the information in this technology and
    it will be useful for the freshers who seeks for the information.
    oracle training in chennai
    orcale course in chennai
    Advanced excel training in chennai
    android training in chennai
    dot net training in chennai
    oracle training in porur
    oracle training in adyar

    ReplyDelete
  2. This is an awesome blog for this technology. Keep updating the information in this technology and
    it will be useful for the freshers who seeks for the information.
    oracle training in chennai
    orcale course in chennai
    Advanced excel training in chennai
    android training in chennai
    dot net training in chennai
    oracle training in porur
    oracle training in adyar

    ReplyDelete