VIEW: APPS.JL_BR_AP_COLLECTION_DOCS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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