R12供应商和银行

SELECT ass.vendor_id         vendor_id, 
             ass.party_id          party_id, 
             bank.party_id         bank_id, 
bank.party_name bank_name,
             branch.party_id       branch_id, 
             branch.party_name     bank_branch_name, 
             ieba.bank_account_num bank_account_num 
        FROM ap_suppliers          ass, 
             hz_parties            hp, 
             iby_account_owners    iao, 
             iby_ext_bank_accounts ieba, 
             hz_parties            bank, 
             hz_parties            branch 
       WHERE ass.party_id            = hp.party_id 
         AND hp.party_id             = iao.account_owner_party_id(+) 
         AND iao.ext_bank_account_id = ieba.ext_bank_account_id(+) 
         AND ieba.bank_id            = bank.party_id(+) 
         AND ieba.branch_id          = branch.party_id(+) 
         AND ass.vendor_id           = p_vendor_id 
       ORDER BY ieba.creation_date;