VIEW: APPS.JL_BR_AP_INT_COLLECT_EXT_V

Source

View Text - Preformatted

SELECT JLINT.ROWID , 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 , FLV1.MEANING , BB2.BANK_NAME , BB2.BANK_BRANCH_NAME , FLV2.MEANING , FLV3.MEANING , FC.CURRENCY_CODE ,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 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 (+)

View Text - HTML Formatted

SELECT JLINT.ROWID
, 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
, FLV1.MEANING
, BB2.BANK_NAME
, BB2.BANK_BRANCH_NAME
, FLV2.MEANING
, FLV3.MEANING
, FC.CURRENCY_CODE
, 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
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 (+)