View: JL_BR_AR_BT_BASE_V

View Text

SELECT /* SELECTION 1 - ENDORSEMENT_CREDIT */ OCCURRENCE_ID OCCURRENCE_ID
, DOCUMENT_ID DOCUMENT_ID
, BANK_OCCURRENCE_CODE BANK_OCCURRENCE_CODE
, BANK_NUMBER BANK_NUMBER
, BANK_OCCURRENCE_TYPE BANK_OCCURRENCE_TYPE
, OCCURRENCE_DATE OCCURRENCE_DATE
, OCCURRENCE_STATUS OCCURRENCE_STATUS
, ORIGINAL_REMITTANCE_MEDIA ORIGINAL_REMITTANCE_MEDIA
, REMITTANCE_MEDIA REMITTANCE_MEDIA
, SELECTION_DATE SELECTION_DATE
, BORDERO_ID BORDERO_ID
, PORTFOLIO_CODE PORTFOLIO_CODE
, TRADE_NOTE_NUMBER TRADE_NOTE_NUMBER
, DUE_DATE DUE_DATE
, DOCUMENT_AMOUNT DOCUMENT_AMOUNT
, BANK_INSTRUCTION_CODE1 BANK_INSTRUCTION_CODE1
, BANK_INSTRUCTION_CODE2 BANK_INSTRUCTION_CODE2
, NUM_DAYS_INSTRUCTION NUM_DAYS_INSTRUCTION
, INTEREST_PERCENT INTEREST_PERCENT
, INTEREST_PERIOD INTEREST_PERIOD
, INTEREST_AMOUNT INTEREST_AMOUNT
, GRACE_DAYS GRACE_DAYS
, DISCOUNT_LIMIT_DATE DISCOUNT_LIMIT_DATE
, DISCOUNT_AMOUNT DISCOUNT_AMOUNT
, CUSTOMER_ID CUSTOMER_ID
, SITE_USE_ID SITE_USE_ID
, ABATEMENT_AMOUNT ABATEMENT_AMOUNT
, FLAG_POST_GL FLAG_POST_GL
, GL_DATE GL_DATE
, GL_POSTED_DATE GL_POSTED_DATE
, BANK_CHARGE_AMOUNT BANK_CHARGE_AMOUNT
, DISCOUNT_CRED_ACCT_CCID DISCOUNT_CRED_ACCT_CCID
, 'ENDOCR' ACCT_LINE_TYPE
, SUBSTR(JL_BR_AR_REMIT_COLL_OCCUR.GET_ACCT_LINE_TYPE_NAME('ENDOCR')
, 1
, 80) ACCT_LINE_TYPE_NAME
, ENDORSEMENT_CREDIT_CCID ENDORSEMENT_CREDIT_CCID
, ENDORSEMENT_CREDIT_AMOUNT ENDORSEMENT_CREDIT_AMOUNT
, TO_NUMBER(NULL) ENDORSEMENT_DEBIT_CCID
, TO_NUMBER(NULL) ENDORSEMENT_DEBIT_AMOUNT
, TO_NUMBER(NULL) BANK_CHARGES_CREDIT_CCID
, TO_NUMBER(NULL) BANK_CHARGES_CREDIT_AMOUNT
, TO_NUMBER(NULL) BANK_CHARGES_DEBIT_CCID
, TO_NUMBER(NULL) BANK_CHARGES_DEBIT_AMOUNT
, REQUEST_ID REQUEST_ID
, RETURN_INFO RETURN_INFO
, INTEREST_INDICATOR INTEREST_INDICATOR
, RETURN_REQUEST_ID RETURN_REQUEST_ID
, GL_CANCEL_DATE GL_CANCEL_DATE
, ORG_ID ORG_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM JL_BR_AR_OCCURRENCE_DOCS
WHERE ENDORSEMENT_CREDIT_CCID IS NOT NULL UNION ALL SELECT /* SELECTION 2 - ENDORSEMENT_DEBIT */ OCCURRENCE_ID OCCURRENCE_ID
, DOCUMENT_ID DOCUMENT_ID
, BANK_OCCURRENCE_CODE BANK_OCCURRENCE_CODE
, BANK_NUMBER BANK_NUMBER
, BANK_OCCURRENCE_TYPE BANK_OCCURRENCE_TYPE
, OCCURRENCE_DATE OCCURRENCE_DATE
, OCCURRENCE_STATUS OCCURRENCE_STATUS
, ORIGINAL_REMITTANCE_MEDIA ORIGINAL_REMITTANCE_MEDIA
, REMITTANCE_MEDIA REMITTANCE_MEDIA
, SELECTION_DATE SELECTION_DATE
, BORDERO_ID BORDERO_ID
, PORTFOLIO_CODE PORTFOLIO_CODE
, TRADE_NOTE_NUMBER TRADE_NOTE_NUMBER
, DUE_DATE DUE_DATE
, DOCUMENT_AMOUNT DOCUMENT_AMOUNT
, BANK_INSTRUCTION_CODE1 BANK_INSTRUCTION_CODE1
, BANK_INSTRUCTION_CODE2 BANK_INSTRUCTION_CODE2
, NUM_DAYS_INSTRUCTION NUM_DAYS_INSTRUCTION
, INTEREST_PERCENT INTEREST_PERCENT
, INTEREST_PERIOD INTEREST_PERIOD
, INTEREST_AMOUNT INTEREST_AMOUNT
, GRACE_DAYS GRACE_DAYS
, DISCOUNT_LIMIT_DATE DISCOUNT_LIMIT_DATE
, DISCOUNT_AMOUNT DISCOUNT_AMOUNT
, CUSTOMER_ID CUSTOMER_ID
, SITE_USE_ID SITE_USE_ID
, ABATEMENT_AMOUNT ABATEMENT_AMOUNT
, FLAG_POST_GL FLAG_POST_GL
, GL_DATE GL_DATE
, GL_POSTED_DATE GL_POSTED_DATE
, BANK_CHARGE_AMOUNT BANK_CHARGE_AMOUNT
, DISCOUNT_CRED_ACCT_CCID DISCOUNT_CRED_ACCT_CCID
, 'ENDODR' ACCT_LINE_TYPE
, SUBSTR(JL_BR_AR_REMIT_COLL_OCCUR.GET_ACCT_LINE_TYPE_NAME('ENDODR')
, 1
, 80) ACCT_LINE_TYPE_NAME
, TO_NUMBER(NULL) ENDORSEMENT_CREDIT_CCID
, TO_NUMBER(NULL) ENDORSEMENT_CREDIT_AMOUNT
, ENDORSEMENT_DEBIT_CCID ENDORSEMENT_DEBIT_CCID
, ENDORSEMENT_DEBIT_AMOUNT ENDORSEMENT_DEBIT_AMOUNT
, TO_NUMBER(NULL) BANK_CHARGES_CREDIT_CCID
, TO_NUMBER(NULL) BANK_CHARGES_CREDIT_AMOUNT
, TO_NUMBER(NULL) BANK_CHARGES_DEBIT_CCID
, TO_NUMBER(NULL) BANK_CHARGES_DEBIT_AMOUNT
, REQUEST_ID REQUEST_ID
, RETURN_INFO RETURN_INFO
, INTEREST_INDICATOR INTEREST_INDICATOR
, RETURN_REQUEST_ID RETURN_REQUEST_ID
, GL_CANCEL_DATE GL_CANCEL_DATE
, ORG_ID ORG_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM JL_BR_AR_OCCURRENCE_DOCS
WHERE ENDORSEMENT_DEBIT_CCID IS NOT NULL UNION ALL SELECT /* SELECTION 3 BANK_CHARGES_CREDIT */ OCCURRENCE_ID OCCURRENCE_ID
, DOCUMENT_ID DOCUMENT_ID
, BANK_OCCURRENCE_CODE BANK_OCCURRENCE_CODE
, BANK_NUMBER BANK_NUMBER
, BANK_OCCURRENCE_TYPE BANK_OCCURRENCE_TYPE
, OCCURRENCE_DATE OCCURRENCE_DATE
, OCCURRENCE_STATUS OCCURRENCE_STATUS
, ORIGINAL_REMITTANCE_MEDIA ORIGINAL_REMITTANCE_MEDIA
, REMITTANCE_MEDIA REMITTANCE_MEDIA
, SELECTION_DATE SELECTION_DATE
, BORDERO_ID BORDERO_ID
, PORTFOLIO_CODE PORTFOLIO_CODE
, TRADE_NOTE_NUMBER TRADE_NOTE_NUMBER
, DUE_DATE DUE_DATE
, DOCUMENT_AMOUNT DOCUMENT_AMOUNT
, BANK_INSTRUCTION_CODE1 BANK_INSTRUCTION_CODE1
, BANK_INSTRUCTION_CODE2 BANK_INSTRUCTION_CODE2
, NUM_DAYS_INSTRUCTION NUM_DAYS_INSTRUCTION
, INTEREST_PERCENT INTEREST_PERCENT
, INTEREST_PERIOD INTEREST_PERIOD
, INTEREST_AMOUNT INTEREST_AMOUNT
, GRACE_DAYS GRACE_DAYS
, DISCOUNT_LIMIT_DATE DISCOUNT_LIMIT_DATE
, DISCOUNT_AMOUNT DISCOUNT_AMOUNT
, CUSTOMER_ID CUSTOMER_ID
, SITE_USE_ID SITE_USE_ID
, ABATEMENT_AMOUNT ABATEMENT_AMOUNT
, FLAG_POST_GL FLAG_POST_GL
, GL_DATE GL_DATE
, GL_POSTED_DATE GL_POSTED_DATE
, BANK_CHARGE_AMOUNT BANK_CHARGE_AMOUNT
, DISCOUNT_CRED_ACCT_CCID DISCOUNT_CRED_ACCT_CCID
, 'BCCR' ACCT_LINE_TYPE
, SUBSTR(JL_BR_AR_REMIT_COLL_OCCUR.GET_ACCT_LINE_TYPE_NAME('BCCR')
, 1
, 80) ACCT_LINE_TYPE_NAME
, TO_NUMBER(NULL) ENDORSEMENT_CREDIT_CCID
, TO_NUMBER(NULL) ENDORSEMENT_CREDIT_AMOUNT
, TO_NUMBER(NULL) ENDORSEMENT_DEBIT_CCID
, TO_NUMBER(NULL) ENDORSEMENT_DEBIT_AMOUNT
, BANK_CHARGES_CREDIT_CCID BANK_CHARGES_CREDIT_CCID
, BANK_CHARGES_CREDIT_AMOUNT BANK_CHARGES_CREDIT_AMOUNT
, TO_NUMBER(NULL) BANK_CHARGES_DEBIT_CCID
, TO_NUMBER(NULL) BANK_CHARGES_DEBIT_AMOUNT
, REQUEST_ID REQUEST_ID
, RETURN_INFO RETURN_INFO
, INTEREST_INDICATOR INTEREST_INDICATOR
, RETURN_REQUEST_ID RETURN_REQUEST_ID
, GL_CANCEL_DATE GL_CANCEL_DATE
, ORG_ID ORG_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM JL_BR_AR_OCCURRENCE_DOCS
WHERE BANK_CHARGES_CREDIT_CCID IS NOT NULL UNION ALL SELECT /* SELECTION 4 BANK_CHARGES_DEBIT */ OCCURRENCE_ID OCCURRENCE_ID
, DOCUMENT_ID DOCUMENT_ID
, BANK_OCCURRENCE_CODE BANK_OCCURRENCE_CODE
, BANK_NUMBER BANK_NUMBER
, BANK_OCCURRENCE_TYPE BANK_OCCURRENCE_TYPE
, OCCURRENCE_DATE OCCURRENCE_DATE
, OCCURRENCE_STATUS OCCURRENCE_STATUS
, ORIGINAL_REMITTANCE_MEDIA ORIGINAL_REMITTANCE_MEDIA
, REMITTANCE_MEDIA REMITTANCE_MEDIA
, SELECTION_DATE SELECTION_DATE
, BORDERO_ID BORDERO_ID
, PORTFOLIO_CODE PORTFOLIO_CODE
, TRADE_NOTE_NUMBER TRADE_NOTE_NUMBER
, DUE_DATE DUE_DATE
, DOCUMENT_AMOUNT DOCUMENT_AMOUNT
, BANK_INSTRUCTION_CODE1 BANK_INSTRUCTION_CODE1
, BANK_INSTRUCTION_CODE2 BANK_INSTRUCTION_CODE2
, NUM_DAYS_INSTRUCTION NUM_DAYS_INSTRUCTION
, INTEREST_PERCENT INTEREST_PERCENT
, INTEREST_PERIOD INTEREST_PERIOD
, INTEREST_AMOUNT INTEREST_AMOUNT
, GRACE_DAYS GRACE_DAYS
, DISCOUNT_LIMIT_DATE DISCOUNT_LIMIT_DATE
, DISCOUNT_AMOUNT DISCOUNT_AMOUNT
, CUSTOMER_ID CUSTOMER_ID
, SITE_USE_ID SITE_USE_ID
, ABATEMENT_AMOUNT ABATEMENT_AMOUNT
, FLAG_POST_GL FLAG_POST_GL
, GL_DATE GL_DATE
, GL_POSTED_DATE GL_POSTED_DATE
, BANK_CHARGE_AMOUNT BANK_CHARGE_AMOUNT
, DISCOUNT_CRED_ACCT_CCID DISCOUNT_CRED_ACCT_CCID
, 'BCDR' ACCT_LINE_TYPE
, SUBSTR(JL_BR_AR_REMIT_COLL_OCCUR.GET_ACCT_LINE_TYPE_NAME('BCDR')
, 1
, 80) ACCT_LINE_TYPE_NAME
, TO_NUMBER(NULL) ENDORSEMENT_CREDIT_CCID
, TO_NUMBER(NULL) ENDORSEMENT_CREDIT_AMOUNT
, TO_NUMBER(NULL) ENDORSEMENT_DEBIT_CCID
, TO_NUMBER(NULL) ENDORSEMENT_DEBIT_AMOUNT
, TO_NUMBER(NULL) BANK_CHARGES_CREDIT_CCID
, TO_NUMBER(NULL) BANK_CHARGES_CREDIT_AMOUNT
, BANK_CHARGES_DEBIT_CCID BANK_CHARGES_DEBIT_CCID
, BANK_CHARGES_DEBIT_AMOUNT BANK_CHARGES_DEBIT_AMOUNT
, REQUEST_ID REQUEST_ID
, RETURN_INFO RETURN_INFO
, INTEREST_INDICATOR INTEREST_INDICATOR
, RETURN_REQUEST_ID RETURN_REQUEST_ID
, GL_CANCEL_DATE GL_CANCEL_DATE
, ORG_ID ORG_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM JL_BR_AR_OCCURRENCE_DOCS
WHERE BANK_CHARGES_DEBIT_CCID IS NOT NULL

Columns