Product: | JL - Latin America Localizations |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.JL_BR_AP_INT_COLLECT_EXT_V |
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 (+)