IBY_EXT_BANK_ACCOUNTS_INT_V

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name

ROW_ID EXT_BANK_ACCOUNT_ID BANK_PARTY_ID COUNTRY_CODE BANK_NAME BANK_NUMBER BRANCH_PARTY_ID BANK_BRANCH_NAME BRANCH_NUMBER BRANCH_TYPE BANK_BRANCH_ADDRESS_ID EFT_SWIFT_CODE BANK_ACCOUNT_ID BANK_ACCOUNT_NAME BANK_ACCOUNT_NUMBER BANK_ACCT_NUM_HASH1 BANK_ACCT_NUM_HASH2 CURRENCY_CODE DESCRIPTION CHECK_DIGITS MULTI_CURRENCY_ALLOWED_FLAG ALTERNATE_ACCOUNT_NAME SHORT_ACCT_NAME ACCOUNT_SUFFIX IBAN_NUMBER IBAN_NUMBER_HASH1 IBAN_NUMBER_HASH2 PRIMARY_ACCT_OWNER_PARTY_ID PRIMARY_ACCT_OWNER_NAME ACCOUNT_CLASSIFICATION BANK_ACCOUNT_TYPE AGENCY_LOCATION_CODE START_DATE END_DATE PAYMENT_FACTOR_FLAG FOREIGN_PAYMENT_USE_FLAG EXCHANGE_RATE_AGREEMENT_NUM EXCHANGE_RATE_AGREEMENT_TYPE EXCHANGE_RATE HEDGING_CONTRACT_REFERENCE SECONDARY_ACCOUNT_REFERENCE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 OBJECT_VERSION_NUMBER BANK_ACCOUNT_NUM_ELECTRONIC

Query

SQL_Statement

SELECT eb.rowid , eb.ext_bank_account_id , eb.bank_id , eb.country_code , decode(eb.bank_branch_party_flag, 'N', eb.bank_name, bp.party_name) , decode(eb.bank_branch_party_flag, 'N', eb.bank_number, bapr.bank_or_branch_number) , eb.branch_id , decode(eb.bank_branch_party_flag, 'N', eb.bank_branch_name, br.party_name) , decode(eb.bank_branch_party_flag, 'N', eb.branch_number, brpr.bank_or_branch_number) , branchca.class_code , s.location_id , decode(eb.bank_branch_party_flag, 'N', eb.eft_swift_code, branchcp.eft_swift_code) , eb.ext_bank_account_id , eb.bank_account_name , eb.bank_account_num , eb.bank_account_num_hash1 , eb.bank_account_num_hash2 , 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.iban , eb.iban_hash1 , eb.iban_hash2 , 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 , eb.bank_account_num_electronic FROM hz_organization_profiles bapr, hz_organization_profiles brpr , hz_parties bp , hz_party_sites s , iby_account_owners ow , hz_parties br , hz_parties op , iby_ext_bank_accounts eb , hz_code_assignments branchca , hz_contact_points branchcp WHERE eb.bank_id = bp.party_id(+) AND eb.bank_id = bapr.party_id(+) AND eb.branch_id = br.party_id(+) AND eb.branch_id = brpr.party_id(+) 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.party_id = s.party_id(+)) AND(s.identifying_address_flag(+) = 'Y') AND(s.status(+) = 'A') AND(branchcp.owner_table_name(+) = 'HZ_PARTIES') AND(branchcp.owner_table_id(+) = eb.branch_id) AND(branchcp.contact_point_type(+) = 'EFT') AND(NVL(branchcp.status(+), 'A') = 'A') AND(branchca.class_category(+) = 'BANK_INSTITUTION_TYPE') AND(branchca.owner_table_name(+) = 'HZ_PARTIES') AND(branchca.owner_table_id(+) = eb.branch_id) AND bapr.effective_latest_change(+) = 'Y' AND brpr.effective_latest_change(+) = 'Y' AND TRUNC(sysdate) BETWEEN bapr.effective_start_date(+) AND bapr.effective_end_date(+) AND TRUNC(sysdate) BETWEEN brpr.effective_start_date(+) AND brpr.effective_end_date(+) AND TRUNC(sysdate) BETWEEN branchca.start_date_active(+) AND branchca.end_date_active(+) AND TRUNC(sysdate) BETWEEN s.start_date_active(+) AND s.end_date_active(+)