VIEW: APPS.IEX_AVAIL_CONTRACTS_V2

Source

View Text - Preformatted

SELECT a.contract_number contract_number, a.khr_id contract_id, a.currency_code currency_code, SUM(a.TRANSACTION_AMOUNT) invoice_amount, SUM(a.AMOUNT_APPLIED) amount_applied, SUM(a.AMOUNT_REMAINING) amount_remaining, SUM(a.AMOUNT_CREDITED) amount_credited, SUM(b.adjustment_amount) adjust_amount From IEX_CS_BILLINGTRX_UV1 a, iex_writeoff_objects b WHERE a.customer_trx_id = b.customer_trx_id(+) and a.invoice_line_id = b.customer_trx_line_id(+) group by a.contract_number,a.khr_id,a.currency_code

View Text - HTML Formatted

SELECT A.CONTRACT_NUMBER CONTRACT_NUMBER
, A.KHR_ID CONTRACT_ID
, A.CURRENCY_CODE CURRENCY_CODE
, SUM(A.TRANSACTION_AMOUNT) INVOICE_AMOUNT
, SUM(A.AMOUNT_APPLIED) AMOUNT_APPLIED
, SUM(A.AMOUNT_REMAINING) AMOUNT_REMAINING
, SUM(A.AMOUNT_CREDITED) AMOUNT_CREDITED
, SUM(B.ADJUSTMENT_AMOUNT) ADJUST_AMOUNT
FROM IEX_CS_BILLINGTRX_UV1 A
, IEX_WRITEOFF_OBJECTS B
WHERE A.CUSTOMER_TRX_ID = B.CUSTOMER_TRX_ID(+)
AND A.INVOICE_LINE_ID = B.CUSTOMER_TRX_LINE_ID(+) GROUP BY A.CONTRACT_NUMBER
, A.KHR_ID
, A.CURRENCY_CODE