JL_BR_AP_INT_COLLECT_EXT

Details

Schema: FUSION
Object owner: JL
Object type: VIEW

Columns

Name
ROW_ID FILE_CONTROL ENTRY_SEQUENTIAL_NUMBER REGISTRY_CODE RETURN_CODE SERVICE_CODE RECORDING_DATE ISSUE_DATE DOCUMENT_NUMBER DRAWER_GUARANTOR INSTRUCTION_1 INSTRUCTION_2 CNAB_CODE DUE_DATE AMOUNT DISCOUNT_DATE DISCOUNT_AMOUNT ARREARS_DATE ARREARS_CODE ARREARS_INTEREST ABATE_AMOUNT PAID_AMOUNT PAYMENT_LOCATION DOCUMENT_TYPE ACCEPTANCE PROCESSING_DATE BANK_USE PORTFOLIO PENALTY_FEE_AMOUNT PENALTY_FEE_DATE OTHER_ACCRETIONS OUR_NUMBER TRANSFEROR_CODE OCCURRENCE OCCURRENCE_DATE DRAWEE_NAME DRAWEE_BANK_CODE DRAWEE_BANK_NAME DRAWEE_BRANCH_CODE DRAWEE_ACCOUNT_NUMBER DRAWEE_INSCRIPTION_TYPE DRAWEE_INSCRIPTION_NUMBER TRANSFEROR_NAME TRANSFEROR_BANK_CODE TRANSFEROR_BRANCH_CODE TRANSFEROR_ACCOUNT_NUMBER TRANSFEROR_INSCRIPTION_TYPE TRANSFEROR_INSCRIPTION_NUMBER ACCOUNTING_BALANCING_SEGMENT SET_OF_BOOKS_ID ERROR_CODE ORG_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN DRAWEE_BRANCH_NAME DRAWEE_INSCRIPTION_TYPE_TMP TRANSFEROR_BANK_NAME TRANSFEROR_BRANCH_NAME TRANSFEROR_INSCRIPTION_TYPE_TM ERROR_DESCRIPTION CURRENCY_CODE_TMP ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 BARCODE ELECTRONIC_FORMAT_FLAG OBJECT_VERSION_NUMBER BARCODE_TYPE_CODE VALIDATION_STATUS_CODE INVOICE_NUM

Name

ROW_ID

FILE_CONTROL

ENTRY_SEQUENTIAL_NUMBER

REGISTRY_CODE

RETURN_CODE

SERVICE_CODE

RECORDING_DATE

ISSUE_DATE

DOCUMENT_NUMBER

DRAWER_GUARANTOR

INSTRUCTION_1

INSTRUCTION_2

CNAB_CODE

DUE_DATE

AMOUNT

DISCOUNT_DATE

DISCOUNT_AMOUNT

ARREARS_DATE

ARREARS_CODE

ARREARS_INTEREST

ABATE_AMOUNT

PAID_AMOUNT

PAYMENT_LOCATION

DOCUMENT_TYPE

ACCEPTANCE

PROCESSING_DATE

BANK_USE

PORTFOLIO

PENALTY_FEE_AMOUNT

PENALTY_FEE_DATE

OTHER_ACCRETIONS

OUR_NUMBER

TRANSFEROR_CODE

OCCURRENCE

OCCURRENCE_DATE

DRAWEE_NAME

DRAWEE_BANK_CODE

DRAWEE_BANK_NAME

DRAWEE_BRANCH_CODE

DRAWEE_ACCOUNT_NUMBER

DRAWEE_INSCRIPTION_TYPE

DRAWEE_INSCRIPTION_NUMBER

TRANSFEROR_NAME

TRANSFEROR_BANK_CODE

TRANSFEROR_BRANCH_CODE

TRANSFEROR_ACCOUNT_NUMBER

TRANSFEROR_INSCRIPTION_TYPE

TRANSFEROR_INSCRIPTION_NUMBER

ACCOUNTING_BALANCING_SEGMENT

SET_OF_BOOKS_ID

ERROR_CODE

ORG_ID

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

DRAWEE_BRANCH_NAME

DRAWEE_INSCRIPTION_TYPE_TMP

TRANSFEROR_BANK_NAME

TRANSFEROR_BRANCH_NAME

TRANSFEROR_INSCRIPTION_TYPE_TM

ERROR_DESCRIPTION

CURRENCY_CODE_TMP

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

BARCODE

ELECTRONIC_FORMAT_FLAG

OBJECT_VERSION_NUMBER

BARCODE_TYPE_CODE

VALIDATION_STATUS_CODE

INVOICE_NUM

Query

SQL_Statement
SELECT JLINT.ROWID ROW_ID, JLINT.FILE_CONTROL , JLINT.ENTRY_SEQUENTIAL_NUMBER , JLINT.REGISTRY_CODE , JLINT.RETURN_CODE , JLINT.SERVICE_CODE , JLINT.RECORDING_DATE , JLINT.ISSUE_DATE , JLINT.DOCUMENT_NUMBER , JLINT.DRAWER_GUARANTOR , JLINT.INSTRUCTION_1 , JLINT.INSTRUCTION_2 , JLINT.CNAB_CODE , JLINT.DUE_DATE , JLINT.AMOUNT , JLINT.DISCOUNT_DATE , JLINT.DISCOUNT_AMOUNT , JLINT.ARREARS_DATE , JLINT.ARREARS_CODE , JLINT.ARREARS_INTEREST , JLINT.ABATE_AMOUNT , JLINT.PAID_AMOUNT , JLINT.PAYMENT_LOCATION , JLINT.DOCUMENT_TYPE , JLINT.ACCEPTANCE , JLINT.PROCESSING_DATE , JLINT.BANK_USE , JLINT.PORTFOLIO , JLINT.PENALTY_FEE_AMOUNT , JLINT.PENALTY_FEE_DATE , JLINT.OTHER_ACCRETIONS , JLINT.OUR_NUMBER , JLINT.TRANSFEROR_CODE , JLINT.OCCURRENCE , JLINT.OCCURRENCE_DATE , JLINT.DRAWEE_NAME , JLINT.DRAWEE_BANK_CODE , JLINT.DRAWEE_BANK_NAME , JLINT.DRAWEE_BRANCH_CODE , JLINT.DRAWEE_ACCOUNT_NUMBER , JLINT.DRAWEE_INSCRIPTION_TYPE , JLINT.DRAWEE_INSCRIPTION_NUMBER , JLINT.TRANSFEROR_NAME , JLINT.TRANSFEROR_BANK_CODE , JLINT.TRANSFEROR_BRANCH_CODE , JLINT.TRANSFEROR_ACCOUNT_NUMBER , JLINT.TRANSFEROR_INSCRIPTION_TYPE , JLINT.TRANSFEROR_INSCRIPTION_NUMBER , JLINT.ACCOUNTING_BALANCING_SEGMENT , JLINT.SET_OF_BOOKS_ID , JLINT.ERROR_CODE , JLINT.ORG_ID , JLINT.LAST_UPDATE_DATE , JLINT.LAST_UPDATED_BY , JLINT.CREATION_DATE , JLINT.CREATED_BY , JLINT.LAST_UPDATE_LOGIN , BB1.BANK_BRANCH_NAME DRAWEE_BRANCH_NAME, FLV1.MEANING DRAWEE_INSCRIPTION_TYPE_TMP, BB2.BANK_NAME TRANSFEROR_BANK_NAME, BB2.BANK_BRANCH_NAME TRANSFEROR_BRANCH_NAME, FLV2.MEANING TRANSFEROR_INSCRIPTION_TYPE_TM, FLV3.MEANING ERROR_DESCRIPTION, FC.CURRENCY_CODE CURRENCY_CODE_TMP,JLINT.ATTRIBUTE_CATEGORY , JLINT.ATTRIBUTE1 ,JLINT.ATTRIBUTE2 ,JLINT.ATTRIBUTE3 ,JLINT.ATTRIBUTE4 ,JLINT.ATTRIBUTE5 ,JLINT.ATTRIBUTE6 , JLINT.ATTRIBUTE7 ,JLINT.ATTRIBUTE8 ,JLINT.ATTRIBUTE9 ,JLINT.ATTRIBUTE10 ,JLINT.ATTRIBUTE11 ,JLINT.ATTRIBUTE12 , JLINT.ATTRIBUTE13 ,JLINT.ATTRIBUTE14 ,JLINT.ATTRIBUTE15 ,JLINT.BARCODE, JLINT.ELECTRONIC_FORMAT_FLAG ,JLINT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, JLINT.BARCODE_TYPE_CODE BARCODE_TYPE_CODE, JLINT.VALIDATION_STATUS_CODE VALIDATION_STATUS_CODE, JLINT.INVOICE_NUM INVOICE_NUM FROM JL_BR_AP_INT_COLLECT_EXT JLINT, CE_BANK_BRANCHES_V BB1, CE_BANK_BRANCHES_V BB2, FND_LOOKUPS FLV1, FND_LOOKUPS FLV2, FND_LOOKUPS FLV3, FND_CURRENCIES_VL FC WHERE JLINT.DRAWEE_BANK_CODE = BB1.BANK_NUMBER (+) AND JLINT.DRAWEE_BRANCH_CODE = BB1.BRANCH_NUMBER (+) AND FLV1.LOOKUP_TYPE (+) = 'JLBR_INSCRIPTION_TYPE' AND JLINT.DRAWEE_INSCRIPTION_TYPE = FLV1.LOOKUP_CODE (+) AND JLINT.TRANSFEROR_BANK_CODE = BB2.BANK_NUMBER (+) AND JLINT.TRANSFEROR_BRANCH_CODE = BB2.BRANCH_NUMBER (+) AND FLV2.LOOKUP_TYPE (+) = 'JLBR_INSCRIPTION_TYPE' AND JLINT.TRANSFEROR_INSCRIPTION_TYPE = FLV2.LOOKUP_CODE (+) AND FLV3.LOOKUP_TYPE (+) = 'JLBR_COLLECT_IMPORT_ERROR' AND JLINT.ERROR_CODE = FLV3.LOOKUP_CODE (+) AND JLINT.CNAB_CODE = FC.GLOBAL_ATTRIBUTE1 (+)

SQL_Statement

SELECT JLINT.ROWID ROW_ID, JLINT.FILE_CONTROL , JLINT.ENTRY_SEQUENTIAL_NUMBER , JLINT.REGISTRY_CODE , JLINT.RETURN_CODE , JLINT.SERVICE_CODE , JLINT.RECORDING_DATE , JLINT.ISSUE_DATE , JLINT.DOCUMENT_NUMBER , JLINT.DRAWER_GUARANTOR , JLINT.INSTRUCTION_1 , JLINT.INSTRUCTION_2 , JLINT.CNAB_CODE , JLINT.DUE_DATE , JLINT.AMOUNT , JLINT.DISCOUNT_DATE , JLINT.DISCOUNT_AMOUNT , JLINT.ARREARS_DATE , JLINT.ARREARS_CODE , JLINT.ARREARS_INTEREST , JLINT.ABATE_AMOUNT , JLINT.PAID_AMOUNT , JLINT.PAYMENT_LOCATION , JLINT.DOCUMENT_TYPE , JLINT.ACCEPTANCE , JLINT.PROCESSING_DATE , JLINT.BANK_USE , JLINT.PORTFOLIO , JLINT.PENALTY_FEE_AMOUNT , JLINT.PENALTY_FEE_DATE , JLINT.OTHER_ACCRETIONS , JLINT.OUR_NUMBER , JLINT.TRANSFEROR_CODE , JLINT.OCCURRENCE , JLINT.OCCURRENCE_DATE , JLINT.DRAWEE_NAME , JLINT.DRAWEE_BANK_CODE , JLINT.DRAWEE_BANK_NAME , JLINT.DRAWEE_BRANCH_CODE , JLINT.DRAWEE_ACCOUNT_NUMBER , JLINT.DRAWEE_INSCRIPTION_TYPE , JLINT.DRAWEE_INSCRIPTION_NUMBER , JLINT.TRANSFEROR_NAME , JLINT.TRANSFEROR_BANK_CODE , JLINT.TRANSFEROR_BRANCH_CODE , JLINT.TRANSFEROR_ACCOUNT_NUMBER , JLINT.TRANSFEROR_INSCRIPTION_TYPE , JLINT.TRANSFEROR_INSCRIPTION_NUMBER , JLINT.ACCOUNTING_BALANCING_SEGMENT , JLINT.SET_OF_BOOKS_ID , JLINT.ERROR_CODE , JLINT.ORG_ID , JLINT.LAST_UPDATE_DATE , JLINT.LAST_UPDATED_BY , JLINT.CREATION_DATE , JLINT.CREATED_BY , JLINT.LAST_UPDATE_LOGIN , BB1.BANK_BRANCH_NAME DRAWEE_BRANCH_NAME, FLV1.MEANING DRAWEE_INSCRIPTION_TYPE_TMP, BB2.BANK_NAME TRANSFEROR_BANK_NAME, BB2.BANK_BRANCH_NAME TRANSFEROR_BRANCH_NAME, FLV2.MEANING TRANSFEROR_INSCRIPTION_TYPE_TM, FLV3.MEANING ERROR_DESCRIPTION, FC.CURRENCY_CODE CURRENCY_CODE_TMP,JLINT.ATTRIBUTE_CATEGORY , JLINT.ATTRIBUTE1 ,JLINT.ATTRIBUTE2 ,JLINT.ATTRIBUTE3 ,JLINT.ATTRIBUTE4 ,JLINT.ATTRIBUTE5 ,JLINT.ATTRIBUTE6 , JLINT.ATTRIBUTE7 ,JLINT.ATTRIBUTE8 ,JLINT.ATTRIBUTE9 ,JLINT.ATTRIBUTE10 ,JLINT.ATTRIBUTE11 ,JLINT.ATTRIBUTE12 , JLINT.ATTRIBUTE13 ,JLINT.ATTRIBUTE14 ,JLINT.ATTRIBUTE15 ,JLINT.BARCODE, JLINT.ELECTRONIC_FORMAT_FLAG ,JLINT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, JLINT.BARCODE_TYPE_CODE BARCODE_TYPE_CODE, JLINT.VALIDATION_STATUS_CODE VALIDATION_STATUS_CODE, JLINT.INVOICE_NUM INVOICE_NUM FROM JL_BR_AP_INT_COLLECT_EXT JLINT, CE_BANK_BRANCHES_V BB1, CE_BANK_BRANCHES_V BB2, FND_LOOKUPS FLV1, FND_LOOKUPS FLV2, FND_LOOKUPS FLV3, FND_CURRENCIES_VL FC WHERE JLINT.DRAWEE_BANK_CODE = BB1.BANK_NUMBER (+) AND JLINT.DRAWEE_BRANCH_CODE = BB1.BRANCH_NUMBER (+) AND FLV1.LOOKUP_TYPE (+) = 'JLBR_INSCRIPTION_TYPE' AND JLINT.DRAWEE_INSCRIPTION_TYPE = FLV1.LOOKUP_CODE (+) AND JLINT.TRANSFEROR_BANK_CODE = BB2.BANK_NUMBER (+) AND JLINT.TRANSFEROR_BRANCH_CODE = BB2.BRANCH_NUMBER (+) AND FLV2.LOOKUP_TYPE (+) = 'JLBR_INSCRIPTION_TYPE' AND JLINT.TRANSFEROR_INSCRIPTION_TYPE = FLV2.LOOKUP_CODE (+) AND FLV3.LOOKUP_TYPE (+) = 'JLBR_COLLECT_IMPORT_ERROR' AND JLINT.ERROR_CODE = FLV3.LOOKUP_CODE (+) AND JLINT.CNAB_CODE = FC.GLOBAL_ATTRIBUTE1 (+)