VIEW: AR.AR_AUTOREC_EXCEPTIONS#

Source

View Text - Preformatted

select BATCH_ID BATCH_ID, REQUEST_ID REQUEST_ID, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID, PAYING_CUSTOMER_ID PAYING_CUSTOMER_ID, PAYING_SITE_USE_ID PAYING_SITE_USE_ID, DUE_DATE DUE_DATE, CUST_BANK_ACCT_ID CUST_BANK_ACCT_ID, REMIT_BANK_ACCT_ID REMIT_BANK_ACCT_ID, CUST_MIN_REC_AMOUNT CUST_MIN_REC_AMOUNT, BANK_MIN_REC_AMOUNT BANK_MIN_REC_AMOUNT, EXCEPTION_CODE EXCEPTION_CODE, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, ADDITIONAL_MESSAGE ADDITIONAL_MESSAGE, CASH_RECEIPT_ID CASH_RECEIPT_ID, REMIT_BANK_ACCT_USE_ID REMIT_BANK_ACCT_USE_ID from "AR"."AR_AUTOREC_EXCEPTIONS"

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, REQUEST_ID REQUEST_ID
, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, PAYING_CUSTOMER_ID PAYING_CUSTOMER_ID
, PAYING_SITE_USE_ID PAYING_SITE_USE_ID
, DUE_DATE DUE_DATE
, CUST_BANK_ACCT_ID CUST_BANK_ACCT_ID
, REMIT_BANK_ACCT_ID REMIT_BANK_ACCT_ID
, CUST_MIN_REC_AMOUNT CUST_MIN_REC_AMOUNT
, BANK_MIN_REC_AMOUNT BANK_MIN_REC_AMOUNT
, EXCEPTION_CODE EXCEPTION_CODE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, ADDITIONAL_MESSAGE ADDITIONAL_MESSAGE
, CASH_RECEIPT_ID CASH_RECEIPT_ID
, REMIT_BANK_ACCT_USE_ID REMIT_BANK_ACCT_USE_ID
FROM "AR"."AR_AUTOREC_EXCEPTIONS"