IBY_EXT_FD_PRBA_1_0

Details

Schema: FUSION
Object owner: IBY
Object type: VIEW

Columns

Name
BANK_ACCOUNT_ID BANK_NAME BANK_NUMBER BRANCH_PARTY_ID BANK_BRANCH_NAME BRANCH_NUMBER BANK_BRANCH_TYPE BANK_BRANCH_TYPE_MEANING BANK_ACCOUNT_NAME BANK_ACCOUNT_NUMBER ACCOUNT_SUFFIX EFT_SWIFT_CODE IBAN_NUMBER CHECK_DIGITS BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE_MEANING CURRENCY_CODE BANK_BRANCH_ADDRESS_ID BANK_ACCOUNT_ATTR_CAT REGIONAL_FINANCE_CENTER_ID AGENCY_LOCATION_CODE ABBREVIATED_AGENCY_CODE FEDERAL_EMPLOYER_ID_NUMBER BRANCH_LEVEL_EFT_USER_NUMBER ACCOUNT_LEVEL_EFT_USER_NUMBER BANK_ACCOUNT_NUM_ELECTRONIC BANK_ACCOUNT_NAME_ALT INT_BANK_ALT_NAME INT_BANK_BRANCH_ALT_NAME ACCOUNT_HOLDER_NAME ACCOUNT_HOLDER_NAME_ALT PAYMENT_ID BANK_BRANCH_HOME_COUNTRY EFT_REQUESTER_IDENTIFIER SECONDARY_ACCOUNT_REFERENCE

Name

BANK_ACCOUNT_ID

BANK_NAME

BANK_NUMBER

BRANCH_PARTY_ID

BANK_BRANCH_NAME

BRANCH_NUMBER

BANK_BRANCH_TYPE

BANK_BRANCH_TYPE_MEANING

BANK_ACCOUNT_NAME

BANK_ACCOUNT_NUMBER

ACCOUNT_SUFFIX

EFT_SWIFT_CODE

IBAN_NUMBER

CHECK_DIGITS

BANK_ACCOUNT_TYPE

BANK_ACCOUNT_TYPE_MEANING

CURRENCY_CODE

BANK_BRANCH_ADDRESS_ID

BANK_ACCOUNT_ATTR_CAT

REGIONAL_FINANCE_CENTER_ID

AGENCY_LOCATION_CODE

ABBREVIATED_AGENCY_CODE

FEDERAL_EMPLOYER_ID_NUMBER

BRANCH_LEVEL_EFT_USER_NUMBER

ACCOUNT_LEVEL_EFT_USER_NUMBER

BANK_ACCOUNT_NUM_ELECTRONIC

BANK_ACCOUNT_NAME_ALT

INT_BANK_ALT_NAME

INT_BANK_BRANCH_ALT_NAME

ACCOUNT_HOLDER_NAME

ACCOUNT_HOLDER_NAME_ALT

PAYMENT_ID

BANK_BRANCH_HOME_COUNTRY

EFT_REQUESTER_IDENTIFIER

SECONDARY_ACCOUNT_REFERENCE

Query

SQL_Statement
SELECT pmt.internal_bank_account_id, pmt.int_bank_name , pmt.int_bank_number , pmt.int_bank_branch_party_id , pmt.int_bank_branch_name , pmt.int_bank_branch_number , NULL bank_branch_type , NULL bank_branch_type_meaning , pmt.int_bank_account_name , pmt.int_bank_account_number , bank_acct.account_suffix, pmt.int_eft_swift_code , pmt.int_bank_account_iban , bank_acct.check_digits , bank_acct.bank_account_type , bank_account_type_lookup.meaning , bank_acct.currency_code , pmt.int_bank_branch_location_id , bank_acct.attribute_category , pmt.int_bank_branch_rfc_identifier, pmt.int_bank_acct_agency_loc_code , pmt.payer_abbreviated_agency_code , pmt.payer_federal_us_employer_id , pmt.int_bank_branch_eft_user_num , bank_acct.eft_user_num , pmt.INT_BANK_ACCOUNT_NUM_ELEC , pmt.int_bank_account_alt_name , pmt.int_bank_alt_name , pmt.int_bank_branch_alt_name , bank_acct.account_holder_name , bank_acct.account_holder_name_alt , pmt.payment_id , bank_branch_profile.home_country , bank_acct.eft_requester_identifier, bank_acct.secondary_account_reference FROM iby_payments_all pmt , ce_bank_accounts bank_acct , ce_lookups bank_account_type_lookup, hz_organization_profiles bank_branch_profile WHERE bank_acct.bank_account_id = pmt.internal_bank_account_id AND bank_acct.bank_account_type = bank_account_type_lookup.lookup_code(+) AND bank_account_type_lookup.lookup_type(+) = 'BANK_ACCOUNT_TYPE' AND bank_acct.bank_branch_id = bank_branch_profile.party_id AND bank_branch_profile.effective_latest_change = 'Y' AND TRUNC(SYSDATE) BETWEEN bank_branch_profile.effective_start_date AND bank_branch_profile.effective_end_date

SQL_Statement

SELECT pmt.internal_bank_account_id,

pmt.int_bank_name ,

pmt.int_bank_number ,

pmt.int_bank_branch_party_id ,

pmt.int_bank_branch_name ,

pmt.int_bank_branch_number ,

NULL bank_branch_type ,

NULL bank_branch_type_meaning ,

pmt.int_bank_account_name ,

pmt.int_bank_account_number ,

bank_acct.account_suffix,

pmt.int_eft_swift_code ,

pmt.int_bank_account_iban ,

bank_acct.check_digits ,

bank_acct.bank_account_type ,

bank_account_type_lookup.meaning ,

bank_acct.currency_code ,

pmt.int_bank_branch_location_id ,

bank_acct.attribute_category ,

pmt.int_bank_branch_rfc_identifier,

pmt.int_bank_acct_agency_loc_code ,

pmt.payer_abbreviated_agency_code ,

pmt.payer_federal_us_employer_id ,

pmt.int_bank_branch_eft_user_num ,

bank_acct.eft_user_num ,

pmt.INT_BANK_ACCOUNT_NUM_ELEC ,

pmt.int_bank_account_alt_name ,

pmt.int_bank_alt_name ,

pmt.int_bank_branch_alt_name ,

bank_acct.account_holder_name ,

bank_acct.account_holder_name_alt ,

pmt.payment_id ,

bank_branch_profile.home_country ,

bank_acct.eft_requester_identifier,

bank_acct.secondary_account_reference

FROM iby_payments_all pmt ,

ce_bank_accounts bank_acct ,

ce_lookups bank_account_type_lookup,

hz_organization_profiles bank_branch_profile

WHERE bank_acct.bank_account_id = pmt.internal_bank_account_id

AND bank_acct.bank_account_type =

bank_account_type_lookup.lookup_code(+)

AND bank_account_type_lookup.lookup_type(+) = 'BANK_ACCOUNT_TYPE'

AND bank_acct.bank_branch_id = bank_branch_profile.party_id

AND bank_branch_profile.effective_latest_change = 'Y'

AND TRUNC(SYSDATE) BETWEEN bank_branch_profile.effective_start_date AND

bank_branch_profile.effective_end_date