1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Supplier bank details query

Discussion in 'Oracle Apps Technical' started by Raviprakash, Oct 20, 2014.

  1. Raviprakash

    Raviprakash Forum Genius

    Messages:
    14
    Likes Received:
    2
    Trophy Points:
    785
    SELECT
    aps.vendor_name "VERDOR NAME",
    aps.segment1 "Vendor Number",
    apss.vendor_site_code "VENDOR SITE CODE",
    aps.pay_group_lookup_code "VENDOR_PAYGROUP",
    apss.pay_group_lookup_code "SITE_PAYGROUP",
    aps.vat_code "VENDOR_VAT_CODE",
    apss.vat_code "SITE_VAT_CODE",
    aps.vat_registration_num "VENDOR_REG_NUM",
    apss.vat_registration_num "SITE_REG_NUM",
    apt.name "VENDOR_TERMS",
    apt1.name "SITE_TERMS",
    aps.payment_method_lookup_code "SUPPLIER_PAY_METHOD",
    apss.payment_method_lookup_code "SITE_PAY_METHOD",
    ieb.bank_name "BANK NAME",
    iebb.bank_branch_name "BANK BRANCH NAME",
    iebb.branch_number "BRANCH NUMBER",
    ieba.BANK_ACCOUNT_NUM "BANK ACCOUNT NUMBER",
    ieba.BANK_ACCOUNT_NAME "BANK ACCOUNT NAME"
    FROM apps.ap_suppliers aps,
    apps.ap_supplier_sites_all apss,
    apps.iby_ext_bank_accounts ieba,
    apps.iby_account_owners iao,
    apps.iby_ext_banks_v ieb,
    apps.iby_ext_bank_branches_v iebb,
    ap_terms apt,
    ap_terms apt1
    ,iby_external_payees_all iepa -- added by
    WHERE aps.vendor_id = apss.vendor_id
    AND aps.terms_id = apt.term_id
    AND apss.terms_id = apt1.term_id(+)
    and iao.account_owner_party_id = aps.party_id
    and ieba.ext_bank_account_id = iao.ext_bank_account_id
    and ieb.bank_party_id = iebb.bank_party_id
    and ieba.branch_id = iebb.branch_party_id
    and ieba.bank_id = ieb.bank_party_id
    AND aps.end_date_active IS NULL
    AND apss.inactive_date IS NULL
    and apss.org_id in (29,4281)
    and apss.vendor_site_id = iepa.supplier_site_id--added by