View: AR_TA_REMIT_HIST

View Text

SELECT HISTORY_LINE_ID
, TRANSMISSION_REQUEST_ID
, BATCH_NAME
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CUSTOMER_ID
, CHECK_NUMBER
, REMITTANCE_AMOUNT
, TRX_NUMBER
, TRX_AMOUNT
, CUSTOMER_REF_NUMBER
, MATCHED_TRX_NUMBER
, MATCHED_TRX_ID
, MATCHED_TRX_TYPE
, AMOUNT_APPLIED
, DISCOUNT_AMT
, NEW_TRX_ID
, NEW_TRX_TYPE
, AMOUNT
, PARENT_HISTORY_LINE_ID
, RULE_PROCEDURE
, RULE_PROCESS
, CUSTOMER_BANK_ACCOUNT_ID
, RECORD_TYPE
, ORGANISATION_SEG
, CUSTOMER_SEG
, LOB_SEG
, FLEX_SEG
, PROFILE_ID
, RULE_SET_ID
, TRX_SET_ID
, PAYMENT_TYPE
, EVENT_TYPE
, UCD_EVENT_TYPE
, PROMOTION_NUMBER
, ADJUSTMENT_TOLERANCE
, ADJUSTMENT_ACTIVITY_ID
, ADJUSTMENT_ID
, ADJUSTMENT_NUMBER
, ADJUSTMENT_STATUS
, CREATED_FROM
, CURRENCY_CODE
, RULE_ID
, CASH_RECEIPT_ID
, PROMOTION_ID
, PROMOTION_PAYMENT_ID
, PROMOTION_PAYMENT_MATCH_TYPE
, ORG_ID
, BATCH_SEQUENCE
, RECEIPT_SEQUENCE
, APPLICATION_SEQUENCE
, EDI_REASS_TRACE_NUMBER
, EDI_TRX_HANDLING_CODE
, EDI_ASSOCIATION_FLAG
, CUST_DED_REASON_CODE
, BAL_NEW_REF
, APPLICATION_STATUS
, OPEN_RECEIVABLES_FLAG
, LOCKBOX_NUMBER
, DISCOUNT_BASIS_USED
, FULL_DISCOUNT_FLAG
, DISCOUNT_DATE_BASIS_USED
, DISCOUNT_DATE_USED
, DISCOUNT_GRACE_DAYS_USED
, UNEARNED_DISCOUNT
, MATCHED_TRX_PAYSCHD_ID
, NEW_TRX_PAYSCHD_ID
, POSTMARK_DATE
, DEPOSIT_DATE
, RECEIPT_DATE
, APPLY_DATE
, ITEM_NUMBER
FROM AR_TA_REMIT_HIST_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