Monday, January 22, 2018

Join Order Management & Quoting Tables in Oracle | SQL Query

SELECT oha.header_id
             , oha.order_number
             , ola.line_Id
            , ola.ship_from_org_id organization_id
             , ola.inventory_item_id
            , ola.ordered_quantity
           , ola.order_quantity_uom
          , ola.line_type_id  xx_line_type_id
           , aql.order_line_type_id
         , ola.request_date
         , ola.creation_date
         , ola.ship_to_org_id
        , ola.sold_to_org_id
          ,ola.subinventory

    FROM   aso_quote_headers_all aqh
         , aso_quote_lines_all aql
         , aso_shipments shp
         , oe_order_headers_all oha
         , ont.oe_order_lines_all ola
    WHERE  aqh.quote_header_Id = '&quote_header_id'
    AND    aql.quote_header_id = aqh.quote_header_id
    AND    shp.quote_header_id = aql.quote_header_id
    AND    shp.quote_line_id = aql.quote_line_id
    AND    oha.source_document_id = aqh.quote_header_id
    AND    ola.header_id = oha.header_id
    AND    ola.source_document_line_Id = shp.shipment_id ;

👋 Hi, I'm Suriya — QA Engineer with 4+ years of experience in manual, API & automation testing.

📬 Contact Me | LinkedIn | GitHub

📌 Follow for: Real-Time Test Cases, Bug Reports, Selenium Frameworks.

6 comments:

  1. Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check oracleappstechnical.com

    ReplyDelete
  2. I wanted to thank you for this excellent read!! I definitely loved every little bit of it. I have you bookmarked your site to check out the new stuff you post. ordering system

    ReplyDelete
  3. Pretty good post. I just stumbled upon your blog and wanted to say that I have enjoyed reading your blog posts. Anyway, I'll be subscribing to your feed and I hope you post again soon. Big thanks for the useful info. Sales quotation

    ReplyDelete
    Replies
    1. Thank you so much for your kind words! I'm really glad to hear that you enjoyed reading my blog posts. Your support means a lot. I’ll definitely keep sharing more useful content—so stay tuned!

      Delete