IBY_PAYEE_ASSIGNED_BANKACCT

Details

Schema: FUSION
Object owner: IBY
Object type: VIEW

Columns

Name
ROW_ID INSTR_ASSIGNMENT_ID PAYMENT_FUNCTION PARTY_ID ORG_ID ORG_TYPE PARTY_SITE_ID SUPPLIER_SITE_ID ORDER_OF_PREFERENCE START_DATE END_DATE EXT_BANK_ACCOUNT_ID CURRENCY_CODE IBAN ACCOUNT_NUMBER BANK_NAME BANK_NUMBER BRANCH_NAME BRANCH_NUMBER BIC_NUMBER DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Name

ROW_ID

INSTR_ASSIGNMENT_ID

PAYMENT_FUNCTION

PARTY_ID

ORG_ID

ORG_TYPE

PARTY_SITE_ID

SUPPLIER_SITE_ID

ORDER_OF_PREFERENCE

START_DATE

END_DATE

EXT_BANK_ACCOUNT_ID

CURRENCY_CODE

IBAN

ACCOUNT_NUMBER

BANK_NAME

BANK_NUMBER

BRANCH_NAME

BRANCH_NUMBER

BIC_NUMBER

DESCRIPTION

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement
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, CEBRANCH.BANK_NAME BANK_NAME, CEBRANCH.BANK_NUMBER BANK_NUMBER, CEBRANCH.BANK_branch_name BRANCH_NAME, CEBRANCH.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_EXT_BANK_ACCOUNTS BANKACCT, CE_ALL_BANK_BRANCHES_V CEBRANCH 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='DISBURSEMENTS' AND BANKACCT.branch_id=cebranch.branch_party_id(+)

SQL_Statement

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, CEBRANCH.BANK_NAME BANK_NAME, CEBRANCH.BANK_NUMBER BANK_NUMBER, CEBRANCH.BANK_branch_name BRANCH_NAME, CEBRANCH.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_EXT_BANK_ACCOUNTS BANKACCT, CE_ALL_BANK_BRANCHES_V CEBRANCH 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='DISBURSEMENTS' AND BANKACCT.branch_id=cebranch.branch_party_id(+)