SELECT
aps.vendor_name|| ‘ ~ ‘|| ass.vendor_site_code
“Payee_Identifier”
,accts.ext_bank_account_id “Payee_Bank_Account_Identifier”
,bank.party_name “bank_name”
,branch.bank_branch_name “Branch_Name”
,accts.country_code “account_country_code”
,accts.bank_account_name “Account_Name”
,accts.bank_account_num
“Account_Number”
“Account_Number”
,accts.currency_code “Account_Currency_Code”
,NULL
“Allow_International_Payments”
“Allow_International_Payments”
,uses.start_date “Account_start_date”
,uses.end_date “Account_end_date”
,accts.iban “IBAN”
,accts.check_digits “check_digits”
,accts.bank_account_name_alt “Account_Alternate_Name”
,accts.bank_account_type “Bank_account_type”
,accts.account_suffix “Account_Suffix”
,accts.description “DESCRIPTION”
,accts.agency_location_code “Agency_Location_Code”
,accts.exchange_rate_agreement_num “Exchange_Rate_Agreement_Number”
,accts.exchange_rate_agreement_type
“Exchange_Rate_Agreement_Type”
,accts.exchange_rate “EXCHANGE_RATE”
,accts.secondary_account_reference
“SECONDARY_ACCOUNT_REFERENCE”
FROM ap_suppliers aps
,ap_supplier_sites_all ass
,iby_pmt_instr_uses_all uses
,iby_external_payees_all payee
,iby_ext_bank_accounts accts
,hz_parties bank
,ce_bank_branches_v branch
WHERE
uses.instrument_type = ‘BANKACCOUNT’
uses.instrument_type = ‘BANKACCOUNT’
AND
aps.vendor_id = ass.vendor_id
aps.vendor_id = ass.vendor_id
AND
aps.party_id =
payee.payee_party_id
aps.party_id =
payee.payee_party_id
AND
payee.ext_payee_id =
uses.ext_pmt_party_id
payee.ext_payee_id =
uses.ext_pmt_party_id
AND
payee.payment_function = ‘PAYABLES_DISB’
payee.payment_function = ‘PAYABLES_DISB’
AND
uses.instrument_id =
accts.ext_bank_account_id
uses.instrument_id =
accts.ext_bank_account_id
AND
accts.bank_id = bank.party_id
accts.bank_id = bank.party_id
–AND
accts.bank_id =
bankprofile.party_id
accts.bank_id =
bankprofile.party_id
AND
accts.branch_id =
branch.branch_party_id
accts.branch_id =
branch.branch_party_id
AND
aps.end_date_active IS NULL
aps.end_date_active IS NULL
AND
ass.inactive_date IS NULL
ass.inactive_date IS NULL
Recommended Posts
