View: IBY_PAYEE_ASSIGNED_BANKACCT_V

Product:	IBY - Payments
Description:
Implementation/DBA Data:	APPS.IBY_PAYEE_ASSIGNED_BANKACCT_V

View Text

SELECT INSTR_ASSIGN.ROWID ROW_ID
, INSTR_ASSIGN.INSTRUMENT_PAYMENT_USE_ID INSTR_ASSIGNMENT_ID
, PAYEE.PAYMENT_FUNCTION PAYMENT_FUNCTION
, PAYEE.PAYEE_PARTY_ID PARTY_ID
, PAYEE.ORG_ID ORG_ID
, PAYEE.ORG_TYPE ORG_TYPE
, PAYEE.PARTY_SITE_ID PARTY_SITE_ID
, PAYEE.SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, INSTR_ASSIGN.ORDER_OF_PREFERENCE ORDER_OF_PREFERENCE
, INSTR_ASSIGN.START_DATE START_DATE
, INSTR_ASSIGN.END_DATE END_DATE
, BANKACCT.EXT_BANK_ACCOUNT_ID EXT_BANK_ACCOUNT_ID
, BANKACCT.CURRENCY_CODE CURRENCY_CODE
, BANKACCT.IBAN IBAN
, BANKACCT.BANK_ACCOUNT_NUM ACCOUNT_NUMBER
, BANKACCT.BANK_NAME BANK_NAME
, BANKACCT.BANK_NUMBER BANK_NUMBER
, BANKACCT.BRANCH_NAME BRANCH_NAME
, BANKACCT.BRANCH_NUMBER BRANCH_NUMBER
, BANKACCT.IBAN BIC_NUMBER
, BANKACCT.DESCRIPTION DESCRIPTION
, INSTR_ASSIGN.CREATED_BY CREATED_BY
, INSTR_ASSIGN.CREATION_DATE CREATION_DATE
, INSTR_ASSIGN.LAST_UPDATED_BY LAST_UPDATED_BY
, INSTR_ASSIGN.LAST_UPDATE_DATE LAST_UPDATE_DATE
, INSTR_ASSIGN.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IBY_PMT_INSTR_USES_ALL INSTR_ASSIGN
, IBY_EXTERNAL_PAYEES_ALL PAYEE
, IBY_PAYEE_ALL_BANKACCT_V BANKACCT
WHERE INSTR_ASSIGN.INSTRUMENT_ID=BANKACCT.EXT_BANK_ACCOUNT_ID
AND INSTR_ASSIGN.EXT_PMT_PARTY_ID=PAYEE.EXT_PAYEE_ID
AND INSTR_ASSIGN.INSTRUMENT_TYPE='BANKACCOUNT'
AND INSTR_ASSIGN.PAYMENT_FLOW='DISBURSEMENT'

Columns