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_VD

Source

View Text - Preformatted


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, null, 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 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 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 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
, NULL
, 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
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 SYSDATE BETWEEN NVL(TRUNC(BANK_BRANCH_PROFILE.EFFECTIVE_START_DATE)
, SYSDATE-1)
AND NVL(TRUNC(BANK_BRANCH_PROFILE.EFFECTIVE_END_DATE)
, SYSDATE+1)