Oracle EBS-SQL ，AR-2:检查应收收款核销额

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