SELECT cust.customer_number, cust.customer_name, cash.receipt_number,
gcc.segment1 || '.' || gcc.segment2 || '.' || gcc.segment3 || '.' ||
gcc.segment4 || '.' || gcc.segment5|| '.' || gcc.segmsegment6 || '.' || gcc.segmsegment7 ,
ara.amount_applied, ara.status,ara.display
--*/SUM(ara.amount_applied)
FROM ar_receivable_applications_all ara,
gl_code_combinations gcc,
ar_cash_receipts_all cash,
ra_customers cust
WHERE ara.org_id =
AND cash.cash_receipt_id = ara.cash_receipt_id AND cash.pay_from_customer (+) = cust.customer_id
AND gcc.code_combination_id = ara.code_combination_id