SELECT hp.party_name, --"Customer Name"
ca.account_number, --"Customer Number"
ctta.name 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;
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 https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.
ReplyDelete