[Home] [Help]
| Product: | AP - Payables |
|---|---|
| Description: | (Release 10SC only) |
| Implementation/DBA Data: | Not implemented in this database |
SELECT DISTINCT ABAU.ROWID ROW_ID
, ABAU.ATTRIBUTE1 ATTRIBUTE1
, ABAU.ATTRIBUTE10 ATTRIBUTE10
, ABAU.ATTRIBUTE11 ATTRIBUTE11
, ABAU.ATTRIBUTE12 ATTRIBUTE12
, ABAU.ATTRIBUTE13 ATTRIBUTE13
, ABAU.ATTRIBUTE14 ATTRIBUTE14
, ABAU.ATTRIBUTE15 ATTRIBUTE15
, ABAU.ATTRIBUTE2 ATTRIBUTE2
, ABAU.ATTRIBUTE3 ATTRIBUTE3
, ABAU.ATTRIBUTE4 ATTRIBUTE4
, ABAU.ATTRIBUTE5 ATTRIBUTE5
, ABAU.ATTRIBUTE6 ATTRIBUTE6
, ABAU.ATTRIBUTE7 ATTRIBUTE7
, ABAU.ATTRIBUTE8 ATTRIBUTE8
, ABAU.ATTRIBUTE9 ATTRIBUTE9
, ABAU.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ABAU.BANK_ACCOUNT_USES_ID BANK_ACCOUNT_USES_ID
, ABAU.CREATED_BY CREATED_BY
, ABAU.CREATION_DATE CREATION_DATE
, ABAU.CUSTOMER_ID CUSTOMER_ID
, ABAU.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, ABAU.END_DATE END_DATE
, ABAU.EXTERNAL_BANK_ACCOUNT_ID EXTERNAL_BANK_ACCOUNT_ID
, ABAU.LAST_UPDATED_BY LAST_UPDATED_BY
, ABAU.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ABAU.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ABAU.PRIMARY_FLAG PRIMARY_FLAG
, ABAU.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, ABAU.PROGRAM_ID PROGRAM_ID
, ABAU.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ABAU.REQUEST_ID REQUEST_ID
, ABAU.START_DATE START_DATE
, ABAU.VENDOR_ID VENDOR_ID
, ABAU.VENDOR_SITE_ID VENDOR_SITE_ID
, ABA.BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, ABA.BANK_ACCOUNT_NAME_ALT BANK_ACCOUNT_NAME_ALT
, ABA.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, ABA.BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE
, ABA.ACCOUNT_TYPE ACCOUNT_TYPE
, ABA.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ABA.CURRENCY_CODE CURRENCY_CODE
, ABA.DESCRIPTION BANK_ACCOUNT_DESCRIPTION
, ABA.CHECK_DIGITS CHECK_DIGITS
, ABA.MULTI_CURRENCY_FLAG MULTI_CURRENCY_FLAG
, ABB.BANK_NAME BANK_NAME
, ABB.BANK_NAME_ALT BANK_NAME_ALT
, ABB.BANK_NUMBER BANK_NUMBER
, ABB.BANK_BRANCH_NAME BANK_BRANCH_NAME
, ABB.BANK_BRANCH_NAME_ALT BANK_BRANCH_NAME_ALT
, ABB.BANK_NUM BANK_NUM
, ABB.INSTITUTION_TYPE INSTITUTION_TYPE
, ABB.BANK_BRANCH_TYPE BANK_BRANCH_TYPE
, PV.VENDOR_NAME VENDOR_NAME
, PV.VENDOR_NAME_ALT VENDOR_NAME_ALT
, PV.SEGMENT1 VENDOR_NUMBER
, PV.VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE_LOOKUP_CODE
, PVS.VENDOR_SITE_CODE VENDOR_SITE_CODE
, PVS.VENDOR_SITE_CODE_ALT VENDOR_SITE_CODE_ALT
, ABB.END_DATE BRANCH_END_DATE
, ABA.INACTIVE_DATE ACCT_INACTIVE_DATE
, ABA.ORG_ID
FROM AP_BANK_ACCOUNT_USES ABAU
, AP_BANK_ACCOUNTS_ALL ABA
, AP_BANK_BRANCHES ABB
, PO_VENDORS PV
, PO_VENDOR_SITES_ALL PVS
WHERE ABAU.EXTERNAL_BANK_ACCOUNT_ID = ABA.BANK_ACCOUNT_ID
AND ABA.BANK_BRANCH_ID = ABB.BANK_BRANCH_ID
AND ABAU.VENDOR_ID = PV.VENDOR_ID
AND ABAU.VENDOR_ID = PVS.VENDOR_ID(+)
AND ABAU.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID(+)