Sales order header information sales order Query R12

Sales order header information



/* Formatted on 7/8/2014 9:35:02 AM (QP5 v5.115.810.9015) */
SELECT ooh.order_number,
       ooh.header_id hdr_id,
       DECODE (ooh.order_category_code,
          'MIXED', 'Mixed',
          'ORDER', 'Regular',
          'RETURN', 'Return',
          ooh.order_category_code)
          category,
       ott.name ord_typ,
       ooh.ordered_date,
       ooh.transactional_curr_code curr,
       os2.name sdt,
       ooh.source_document_id sdi,
       os1.name os,
       ooh.orig_sys_document_ref osdr,
       ooh.sold_to_org_id sold_to,
       ooh.invoice_to_org_id invoice_to,
       ooh.cust_po_number cust_po,
       ooh.payment_type_code pay_type,
       ooh.flow_status_code hdr_flow_status,
       ooh.open_flag,
       ooh.booked_flag,
       ooh.cancelled_flag,
       NVL (ooh.upgraded_flag, 'N') upgraded_flag
FROM oe_order_headers_all ooh,
     oe_transaction_types_tl ott,
     oe_order_sources os1,
     oe_order_sources os2
WHERE    1 = 1
      AND ooh.order_number = &order_number
      AND ooh.order_type_id = ott.transaction_type_id
      AND ooh.order_source_id = os1.order_source_id(+)
      AND ooh.source_document_type_id = os2.order_source_id(+)
      AND ott.language = (SELECT fl.language_code
                          FROM fnd_languages fl
                          WHERE fl.installed_flag = 'B');

1 comments :

All the best who are completing their MBA. oracle financials sector having huge openings for finance background students. here we have oracle fusion hcm and oracle fusion financials online training institute for all the Indian and foreigner students. we have 10+ years of experience in handling oracle technology
related projects. we have proven skill in online training and giving job assistance after the training.

for more information please visit:


Oracle Fusion HCM Online Training

Reply

Post a Comment