View: POS_SUP_AP_BANK_ACCOUNTS_V

Product:	POS - iSupplier Portal
Description:	An internal view for supplier bank accounts in Oracle Payables
Implementation/DBA Data:	APPS.POS_SUP_AP_BANK_ACCOUNTS_V

View Text

SELECT X1.BANK_ACCOUNT_ID
, X1.BANK_ACCOUNT_NAME
, X1.BANK_ACCOUNT_NUMBER AS BANK_ACCOUNT_NUM
, X1.CURRENCY_CODE
, X1.BRANCH_PARTY_ID AS BANK_BRANCH_ID
, PMAP.VENDOR_ID
FROM IBY_EXT_BANK_ACCOUNTS_V X1
, POS_SUPPLIER_MAPPINGS PMAP
WHERE X1.PRIMARY_ACCT_OWNER_PARTY_ID = PMAP.PARTY_ID

Columns