eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IBY_EXT_FD_PRBA_1_0_V

Source

View Text - Preformatted


SELECT bank_acct.bank_account_id, bank_and_branch.bank_name, bank_and_branch.bank_number, bank_and_branch.branch_party_id, bank_and_branch.bank_branch_name, bank_and_branch.branch_number, bank_and_branch.bank_branch_type, bank_branch_type_lookup.meaning, bank_acct.bank_account_name, bank_acct.bank_account_num, bank_acct.account_suffix, bank_and_branch.eft_swift_code, bank_acct.iban_number, bank_acct.check_digits, bank_acct.bank_account_type, bank_account_type_lookup.meaning, bank_acct.currency_code, party_site.location_id, bank_acct.attribute_category, RFC_ID_CA.class_code, bank_acct.agency_location_code, IBY_FD_EXTRACT_GEN_PVT.get_Abbreviated_Agency_Code(iby_utility_pvt.get_view_param('PMT_INSTR_ID')), IBY_FD_EXTRACT_GEN_PVT.get_FEIN(iby_utility_pvt.get_view_param('PMT_INSTR_ID')), bank_and_branch.eft_user_number, bank_acct.eft_user_num, bank_acct.BANK_ACCOUNT_NUM_ELECTRONIC, bank_acct.bank_account_name_alt, bank_and_branch.bank_name_alt, bank_and_branch.bank_branch_name_alt, bank_branch_profile.home_country FROM ce_bank_branches_v bank_and_branch, HZ_CODE_ASSIGNMENTS RFC_ID_CA, ce_bank_accounts bank_acct, hz_party_sites party_site, ar_lookups bank_branch_type_lookup, ce_lookups bank_account_type_lookup, hz_organization_profiles bank_branch_profile WHERE bank_acct.bank_id = bank_and_branch.bank_party_id AND bank_acct.bank_branch_id = bank_and_branch.branch_party_id AND bank_and_branch.branch_party_id = party_site.party_id(+) AND party_site.identifying_address_flag(+) = 'Y' AND bank_and_branch.bank_branch_type = bank_branch_type_lookup.lookup_code(+) AND bank_branch_type_lookup.lookup_type(+) = 'BANK_BRANCH_TYPE' AND bank_acct.bank_account_type = bank_account_type_lookup.lookup_code(+) AND bank_account_type_lookup.lookup_type(+) = 'BANK_ACCOUNT_TYPE' And RFC_ID_CA.CLASS_CATEGORY(+) = 'RFC_IDENTIFIER' And RFC_ID_CA.OWNER_TABLE_NAME(+) = 'HZ_PARTIES' And RFC_ID_CA.OWNER_TABLE_ID(+) = bank_and_branch.Branch_PARTY_ID AND bank_acct.bank_branch_id = bank_branch_profile.party_id AND SYSDATE between nvl(TRUNC(bank_branch_profile.effective_start_date), sysdate-1) and NVL(TRUNC(bank_branch_profile.effective_end_date), SYSDATE+1)

View Text - HTML Formatted

SELECT BANK_ACCT.BANK_ACCOUNT_ID
, BANK_AND_BRANCH.BANK_NAME
, BANK_AND_BRANCH.BANK_NUMBER
, BANK_AND_BRANCH.BRANCH_PARTY_ID
, BANK_AND_BRANCH.BANK_BRANCH_NAME
, BANK_AND_BRANCH.BRANCH_NUMBER
, BANK_AND_BRANCH.BANK_BRANCH_TYPE
, BANK_BRANCH_TYPE_LOOKUP.MEANING
, BANK_ACCT.BANK_ACCOUNT_NAME
, BANK_ACCT.BANK_ACCOUNT_NUM
, BANK_ACCT.ACCOUNT_SUFFIX
, BANK_AND_BRANCH.EFT_SWIFT_CODE
, BANK_ACCT.IBAN_NUMBER
, BANK_ACCT.CHECK_DIGITS
, BANK_ACCT.BANK_ACCOUNT_TYPE
, BANK_ACCOUNT_TYPE_LOOKUP.MEANING
, BANK_ACCT.CURRENCY_CODE
, PARTY_SITE.LOCATION_ID
, BANK_ACCT.ATTRIBUTE_CATEGORY
, RFC_ID_CA.CLASS_CODE
, BANK_ACCT.AGENCY_LOCATION_CODE
, IBY_FD_EXTRACT_GEN_PVT.GET_ABBREVIATED_AGENCY_CODE(IBY_UTILITY_PVT.GET_VIEW_PARAM('PMT_INSTR_ID'))
, IBY_FD_EXTRACT_GEN_PVT.GET_FEIN(IBY_UTILITY_PVT.GET_VIEW_PARAM('PMT_INSTR_ID'))
, BANK_AND_BRANCH.EFT_USER_NUMBER
, BANK_ACCT.EFT_USER_NUM
, BANK_ACCT.BANK_ACCOUNT_NUM_ELECTRONIC
, BANK_ACCT.BANK_ACCOUNT_NAME_ALT
, BANK_AND_BRANCH.BANK_NAME_ALT
, BANK_AND_BRANCH.BANK_BRANCH_NAME_ALT
, BANK_BRANCH_PROFILE.HOME_COUNTRY
FROM CE_BANK_BRANCHES_V BANK_AND_BRANCH
, HZ_CODE_ASSIGNMENTS RFC_ID_CA
, CE_BANK_ACCOUNTS BANK_ACCT
, HZ_PARTY_SITES PARTY_SITE
, AR_LOOKUPS BANK_BRANCH_TYPE_LOOKUP
, CE_LOOKUPS BANK_ACCOUNT_TYPE_LOOKUP
, HZ_ORGANIZATION_PROFILES BANK_BRANCH_PROFILE
WHERE BANK_ACCT.BANK_ID = BANK_AND_BRANCH.BANK_PARTY_ID
AND BANK_ACCT.BANK_BRANCH_ID = BANK_AND_BRANCH.BRANCH_PARTY_ID
AND BANK_AND_BRANCH.BRANCH_PARTY_ID = PARTY_SITE.PARTY_ID(+)
AND PARTY_SITE.IDENTIFYING_ADDRESS_FLAG(+) = 'Y'
AND BANK_AND_BRANCH.BANK_BRANCH_TYPE = BANK_BRANCH_TYPE_LOOKUP.LOOKUP_CODE(+)
AND BANK_BRANCH_TYPE_LOOKUP.LOOKUP_TYPE(+) = 'BANK_BRANCH_TYPE'
AND BANK_ACCT.BANK_ACCOUNT_TYPE = BANK_ACCOUNT_TYPE_LOOKUP.LOOKUP_CODE(+)
AND BANK_ACCOUNT_TYPE_LOOKUP.LOOKUP_TYPE(+) = 'BANK_ACCOUNT_TYPE'
AND RFC_ID_CA.CLASS_CATEGORY(+) = 'RFC_IDENTIFIER'
AND RFC_ID_CA.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND RFC_ID_CA.OWNER_TABLE_ID(+) = BANK_AND_BRANCH.BRANCH_PARTY_ID
AND BANK_ACCT.BANK_BRANCH_ID = BANK_BRANCH_PROFILE.PARTY_ID
AND SYSDATE BETWEEN NVL(TRUNC(BANK_BRANCH_PROFILE.EFFECTIVE_START_DATE)
, SYSDATE-1)
AND NVL(TRUNC(BANK_BRANCH_PROFILE.EFFECTIVE_END_DATE)
, SYSDATE+1)