JL_BR_AP_COLLECTION_DOCS

Details

Schema: FUSION
Object owner: JL
Object type: VIEW

Columns

Name
ROW_ID BANK_COLLECTION_ID LAST_UPDATED_BY LAST_UPDATE_DATE CREATED_BY CREATION_DATE LAST_UPDATE_LOGIN INVOICE_ID PAYMENT_NUM HOLD_FLAG ISSUE_DATE DOCUMENT_NUMBER DRAWER_GUARANTOR INSTRUCTION_1 INSTRUCTION_2 CURRENCY_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 VENDOR_SITE_ID FILE_CONTROL STATUS_LOOKUP_CODE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE21 ATTRIBUTE22 ATTRIBUTE23 ATTRIBUTE24 ATTRIBUTE25 ATTRIBUTE26 ATTRIBUTE27 ATTRIBUTE28 ATTRIBUTE29 ATTRIBUTE30 ENTRY_SEQUENTIAL_NUMBER SET_OF_BOOKS_ID VENDOR_ID BANK_BRANCH_ID ORG_ID BANK_NUMBER BANK_NAME BANK_BRANCH_NAME BRANCH_NUMBER VENDOR_NAME SEGMENT1 VENDOR_SITE_CODE SUPPLIER_INSCRIPTION_NUMBER BANK_PARTY_ID BRANCH_PARTY_ID BARCODE ELECTRONIC_FORMAT_FLAG OBJECT_VERSION_NUMBER INVOICE_NUM BARCODE_TYPE_CODE

Name

ROW_ID

BANK_COLLECTION_ID

LAST_UPDATED_BY

LAST_UPDATE_DATE

CREATED_BY

CREATION_DATE

LAST_UPDATE_LOGIN

INVOICE_ID

PAYMENT_NUM

HOLD_FLAG

ISSUE_DATE

DOCUMENT_NUMBER

DRAWER_GUARANTOR

INSTRUCTION_1

INSTRUCTION_2

CURRENCY_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

VENDOR_SITE_ID

FILE_CONTROL

STATUS_LOOKUP_CODE

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

ATTRIBUTE21

ATTRIBUTE22

ATTRIBUTE23

ATTRIBUTE24

ATTRIBUTE25

ATTRIBUTE26

ATTRIBUTE27

ATTRIBUTE28

ATTRIBUTE29

ATTRIBUTE30

ENTRY_SEQUENTIAL_NUMBER

SET_OF_BOOKS_ID

VENDOR_ID

BANK_BRANCH_ID

ORG_ID

BANK_NUMBER

BANK_NAME

BANK_BRANCH_NAME

BRANCH_NUMBER

VENDOR_NAME

SEGMENT1

VENDOR_SITE_CODE

SUPPLIER_INSCRIPTION_NUMBER

BANK_PARTY_ID

BRANCH_PARTY_ID

BARCODE

ELECTRONIC_FORMAT_FLAG

OBJECT_VERSION_NUMBER

INVOICE_NUM

BARCODE_TYPE_CODE

Query

SQL_Statement
SELECT JLDOC.ROWID ROW_ID, 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), '') SUPPLIER_INSCRIPTION_NUMBER , JLDOC.BANK_PARTY_ID, JLDOC.BRANCH_PARTY_ID ,JLDOC.BARCODE, JLDOC.ELECTRONIC_FORMAT_FLAG ,JLDOC.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER ,JLDOC.INVOICE_NUM INVOICE_NUM ,JLDOC.BARCODE_TYPE_CODE BARCODE_TYPE_CODE FROM JL_BR_AP_COLLECTION_DOCS JLDOC, CE_BANK_BRANCHES_V BB , POZ_SUPPLIERS_V PV, POZ_SUPPLIER_SITES_ALL_X 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

SQL_Statement

SELECT JLDOC.ROWID ROW_ID, 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), '') SUPPLIER_INSCRIPTION_NUMBER , JLDOC.BANK_PARTY_ID, JLDOC.BRANCH_PARTY_ID ,JLDOC.BARCODE, JLDOC.ELECTRONIC_FORMAT_FLAG

,JLDOC.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER

,JLDOC.INVOICE_NUM INVOICE_NUM

,JLDOC.BARCODE_TYPE_CODE BARCODE_TYPE_CODE

FROM JL_BR_AP_COLLECTION_DOCS JLDOC, CE_BANK_BRANCHES_V BB

, POZ_SUPPLIERS_V PV, POZ_SUPPLIER_SITES_ALL_X 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