Tech Trainings

Oracle Fusion ERP – Query to Fetch Customer Profile Query – Site Level

April 13, 2023 by admin

SELECT
    hp.party_number,
    hp.party_name,
    hca.account_number,
    hps.party_site_number,
    hcpc.name                 profile_class_name,
    hcpf.cust_account_profile_id,
    hcpf.profile_class_id,
    hca.orig_system_reference account_orig_ref,
    hcpf.send_statements,
    rt.term_id,
    rt.name                   payment_term,
    hcpf.creation_date,
    hcpf.created_by
FROM
    hz_customer_profiles_f  hcpf,
    hz_cust_accounts        hca,
    hz_cust_profile_classes hcpc,
    hz_party_sites          hps,
    hz_parties              hp,
    hz_cust_acct_sites_all  hcas,
    ra_terms_tl             rt,
    hz_cust_site_uses_all   hcsu
WHERE
        1 = 1
    AND hcpf.cust_account_id = hca.cust_account_id
    AND hcpc.profile_class_id = hcpf.profile_class_id
    AND hp.party_id = hps.party_id
    AND hp.party_id = hca.party_id
    AND hcpf.site_use_id = hcsu.site_use_id
    AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id
    AND hcas.party_site_id = hps.party_site_id
    AND hps.party_site_id = hcas.party_site_id
    AND hcpf.standard_terms = rt.term_id
    AND rt.language = 'US'

Comments |0|