Product: | JL - Latin America Localizations |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.JL_BR_AP_COLLECTION_DOCS_V |
SELECT JLDOC.ROWID
, JLDOC.BANK_COLLECTION_ID
, JLDOC.LAST_UPDATED_BY
, JLDOC.LAST_UPDATE_DATE
, JLDOC.CREATED_BY
, JLDOC.CREATION_DATE
, JLDOC.LAST_UPDATE_LOGIN
, JLDOC.INVOICE_ID
, JLDOC.PAYMENT_NUM
, JLDOC.HOLD_FLAG
, JLDOC.ISSUE_DATE
, JLDOC.DOCUMENT_NUMBER
, JLDOC.DRAWER_GUARANTOR
, JLDOC.INSTRUCTION_1
, JLDOC.INSTRUCTION_2
, JLDOC.CURRENCY_CODE
, JLDOC.DUE_DATE
, JLDOC.AMOUNT
, JLDOC.DISCOUNT_DATE
, JLDOC.DISCOUNT_AMOUNT
, JLDOC.ARREARS_DATE
, JLDOC.ARREARS_CODE
, JLDOC.ARREARS_INTEREST
, JLDOC.ABATE_AMOUNT
, JLDOC.PAID_AMOUNT
, JLDOC.PAYMENT_LOCATION
, JLDOC.DOCUMENT_TYPE
, JLDOC.ACCEPTANCE
, JLDOC.PROCESSING_DATE
, JLDOC.BANK_USE
, JLDOC.PORTFOLIO
, JLDOC.PENALTY_FEE_AMOUNT
, JLDOC.PENALTY_FEE_DATE
, JLDOC.OTHER_ACCRETIONS
, JLDOC.OUR_NUMBER
, JLDOC.TRANSFEROR_CODE
, JLDOC.VENDOR_SITE_ID
, JLDOC.FILE_CONTROL
, JLDOC.STATUS_LOOKUP_CODE
, JLDOC.ATTRIBUTE_CATEGORY
, JLDOC.ATTRIBUTE1
, JLDOC.ATTRIBUTE2
, JLDOC.ATTRIBUTE3
, JLDOC.ATTRIBUTE4
, JLDOC.ATTRIBUTE5
, JLDOC.ATTRIBUTE6
, JLDOC.ATTRIBUTE7
, JLDOC.ATTRIBUTE8
, JLDOC.ATTRIBUTE9
, JLDOC.ATTRIBUTE10
, JLDOC.ATTRIBUTE11
, JLDOC.ATTRIBUTE12
, JLDOC.ATTRIBUTE13
, JLDOC.ATTRIBUTE14
, JLDOC.ATTRIBUTE15
, JLDOC.ATTRIBUTE16
, JLDOC.ATTRIBUTE17
, JLDOC.ATTRIBUTE18
, JLDOC.ATTRIBUTE19
, JLDOC.ATTRIBUTE20
, JLDOC.ATTRIBUTE21
, JLDOC.ATTRIBUTE22
, JLDOC.ATTRIBUTE23
, JLDOC.ATTRIBUTE24
, JLDOC.ATTRIBUTE25
, JLDOC.ATTRIBUTE26
, JLDOC.ATTRIBUTE27
, JLDOC.ATTRIBUTE28
, JLDOC.ATTRIBUTE29
, JLDOC.ATTRIBUTE30
, JLDOC.ENTRY_SEQUENTIAL_NUMBER
, JLDOC.SET_OF_BOOKS_ID
, JLDOC.VENDOR_ID
, JLDOC.BANK_BRANCH_ID
, JLDOC.ORG_ID
, BB.BANK_NUMBER
, BB.BANK_NAME
, BB.BANK_BRANCH_NAME
, BB.BRANCH_NUMBER
, PV.VENDOR_NAME
, PV.SEGMENT1
, PVS.VENDOR_SITE_CODE
, DECODE(PVS.GLOBAL_ATTRIBUTE9
, '1'
, '000'|| SUBSTR(LTRIM(NVL(PVS.GLOBAL_ATTRIBUTE10
, '000000000'))
, 1
, 9)|| SUBSTR(LTRIM(NVL(PVS.GLOBAL_ATTRIBUTE12
, '00'))
, 1
, 2)
, '2'
, SUBSTR(LTRIM(NVL(PVS.GLOBAL_ATTRIBUTE10
, '00000000'))
, 2
, 8)|| SUBSTR(LTRIM(NVL(PVS.GLOBAL_ATTRIBUTE11
, '0000'))
, 1
, 4)|| SUBSTR(LTRIM(NVL(PVS.GLOBAL_ATTRIBUTE12
, '00'))
, 1
, 2)
, '')
, JLDOC.BANK_PARTY_ID
, JLDOC.BRANCH_PARTY_ID
, JLDOC.BARCODE
, JLDOC.ELECTRONIC_FORMAT_FLAG
FROM JL_BR_AP_COLLECTION_DOCS JLDOC
, CE_BANK_BRANCHES_V BB
, PO_VENDORS PV
, PO_VENDOR_SITES PVS
WHERE BB.BANK_PARTY_ID (+) = JLDOC.BANK_PARTY_ID
AND BB.BRANCH_PARTY_ID (+) = JLDOC.BRANCH_PARTY_ID
AND PV.VENDOR_ID (+) = JLDOC.VENDOR_ID
AND PVS.VENDOR_SITE_ID (+) = JLDOC.VENDOR_SITE_ID