View: AR_TA_RECON_INFO

View Text

SELECT CUSTOMER_ID
, GL_DATE
, BEGINNING_BALANCE
, TRX_INV_INV
, TRX_INV_OTHERS
, TRX_CREDIT_MEMO_CM
, TRX_CREDIT_MEMO_OTHERS
, TRX_DED_DM
, TRX_DED_CM
, TRX_DED_OTHERS
, TRX_UCD_DM
, TRX_UCD_OTHERS
, TRX_BALANCING_DM
, TRX_BALANCING_CM
, TRX_BALANCING_OTHERS
, TRX_ON_ACCT_CM
, TRX_ON_ACCT_OTHERS
, TRX_CHARGEBACK_CB
, TRX_CHARGEBACK_OTHERS
, TRX_OTHERS_DM
, TRX_OTHERS_CM
, TRX_OTHERS_INV
, TRX_OTHERS_CB
, TRX_OTHERS_DEP
, TRX_OTHERS_GUAR
, TRX_OTHERS_OTHERS
, TRX_EARNED_DISCOUNT
, TRX_UNEARNED_DISCOUNT
, APPROVED_ADJUSTMENTS
, INVOICE_EXCEPTIONS
, RECEIPTS_APPLIED
, RECEIPTS_UNAPPLIED
, RECEIPTS_UNIDENTIFIED
, RECEIPTS_NSF
, RECEIPTS_STOP
, RECEIPTS_REVERSED
, ENDING_BALANCE
, VARIANCE
, SALES_JOURNAL_CR
, SALES_JOURNAL_DR
, RECEIPT_JOURNAL
, REQUEST_ID
FROM AR_TA_RECON_INFO_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTR( USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns