Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Wednesday, 11 May 2016

Query to Get Drilled-down Transactions

SELECT hp.party_name,                                             --"Customer Name"
       ca.account_number,                                         --"Customer Number" trx_type,                                        --"Transaction Type"
       cta.trx_number,                                            --"Transaction Number"
       cta.trx_date,                                              --"Transaction Date"
       ctla.line_number,                                          --"Payment Due Date"
       ctla.description,                                          --"Description"
       ctla.uom_code,                                             --"UOM"
       ctla.quantity_invoiced,                                    --"Quantity"
       ctla.unit_selling_price,                                   --"Unit Price"
       (ctla.quantity_invoiced * ctla.unit_selling_price) amount  --"Amount"
  FROM hz_parties hp,
       hz_cust_accounts ca,
       ra_cust_trx_types_all ctta,
       ra_customer_trx_all cta,
       ra_customer_trx_lines_all ctla
 WHERE hp.party_id               = ca.party_id
       AND ca.cust_account_id    = cta.bill_to_customer_id
       AND ctta.cust_trx_type_id = cta.cust_trx_type_id
       AND cta.customer_trx_id   = ctla.customer_trx_id
--       AND hp.party_name         LIKE 'S%'
       --AND cta.trx_number        = '55443'

 ORDER BY ctla.line_number;
Share this article :


  1. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check for Never Before Offers and Discount Coupon Codes.

  2. Hello I am so delighted I located your blog, I really located you by mistake, while I was watching on google for something else, Anyways I am here now and could just like to say thank for a tremendous post and a all round entertaining website. Please do keep up the great work. 정보이용료 현금화