VIEW: APPS.IBY_PAYEE_ASSIGNED_BANKACCT_V

Source

View Text - Preformatted

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_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(+)

View Text - HTML Formatted

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_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(+)