View: IBY_EXT_BANK_ACCOUNTS_V

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

View Text

SELECT EB.ROWID
, EB.EXT_BANK_ACCOUNT_ID
, EB.BANK_ID
, EB.COUNTRY_CODE
, BP.PARTY_NAME
, BAPR.BANK_OR_BRANCH_NUMBER
, EB.BRANCH_ID
, BR.BANK_BRANCH_NAME
, BR.BRANCH_NUMBER
, BR.BANK_BRANCH_TYPE
, S.LOCATION_ID
, BR.EFT_SWIFT_CODE
, EB.EXT_BANK_ACCOUNT_ID
, EB.BANK_ACCOUNT_NAME
, EB.MASKED_BANK_ACCOUNT_NUM
, EB.CURRENCY_CODE
, EB.DESCRIPTION
, EB.CHECK_DIGITS
, DECODE(EB.CURRENCY_CODE
, NULL
, 'Y'
, 'N')
, EB.BANK_ACCOUNT_NAME_ALT
, EB.SHORT_ACCT_NAME
, EB.ACCOUNT_SUFFIX
, EB.MASKED_IBAN
, OW.ACCOUNT_OWNER_PARTY_ID
, OP.PARTY_NAME
, EB.ACCOUNT_CLASSIFICATION
, EB.BANK_ACCOUNT_TYPE
, EB.AGENCY_LOCATION_CODE
, EB.START_DATE
, EB.END_DATE
, EB.PAYMENT_FACTOR_FLAG
, EB.FOREIGN_PAYMENT_USE_FLAG
, EB.EXCHANGE_RATE_AGREEMENT_NUM
, EB.EXCHANGE_RATE_AGREEMENT_TYPE
, EB.EXCHANGE_RATE
, EB.HEDGING_CONTRACT_REFERENCE
, EB.SECONDARY_ACCOUNT_REFERENCE
, EB.ATTRIBUTE_CATEGORY
, EB.ATTRIBUTE1
, EB.ATTRIBUTE2
, EB.ATTRIBUTE3
, EB.ATTRIBUTE4
, EB.ATTRIBUTE5
, EB.ATTRIBUTE6
, EB.ATTRIBUTE7
, EB.ATTRIBUTE8
, EB.ATTRIBUTE9
, EB.ATTRIBUTE10
, EB.ATTRIBUTE11
, EB.ATTRIBUTE12
, EB.ATTRIBUTE13
, EB.ATTRIBUTE14
, EB.ATTRIBUTE15
, EB.OBJECT_VERSION_NUMBER
FROM HZ_ORGANIZATION_PROFILES BAPR
, HZ_PARTIES BP
, HZ_PARTY_SITES S
, IBY_ACCOUNT_OWNERS OW
, CE_BANK_BRANCHES_V BR
, HZ_PARTIES OP
, IBY_EXT_BANK_ACCOUNTS EB
WHERE EB.BANK_ID = BP.PARTY_ID(+)
AND EB.BANK_ID = BAPR.PARTY_ID(+)
AND EB.BRANCH_ID = BR.BRANCH_PARTY_ID(+)
AND SYSDATE BETWEEN NVL(BAPR.EFFECTIVE_START_DATE
, SYSDATE)
AND NVL(BAPR.EFFECTIVE_END_DATE
, SYSDATE)
AND EB.EXT_BANK_ACCOUNT_ID = OW.EXT_BANK_ACCOUNT_ID(+)
AND OW.PRIMARY_FLAG(+) = 'Y'
AND NVL(OW.END_DATE
, SYSDATE+10)>SYSDATE
AND OW.ACCOUNT_OWNER_PARTY_ID = OP.PARTY_ID(+)
AND (BR.BRANCH_PARTY_ID = S.PARTY_ID(+))
AND (S.IDENTIFYING_ADDRESS_FLAG(+) = 'Y')

Columns