R12 Customer Contacts Query

SELECT hcasa.org_id,
  role_acct.account_number,
  hcasa.orig_system_reference,
  rel.subject_id,rel.object_id
  ,party.party_id                                           party_id,
  rel_party.party_id                                      rel_party_id,
  acct_role.cust_account_id                         ,
  acct_role.cust_acct_site_id                        ,
  party.person_pre_name_adjunct                 contact_prefix,
  substr(party.person_first_name, 1, 40)       contact_first_name,
  substr(party.person_middle_name, 1, 40)  contact_middle_name,
  substr(party.person_last_name, 1, 50)        contact_last_name,
  party.person_name_suffix                           contact_suffix,
  acct_role.status, org_cont.job_title             contact_job_title,
  org_cont.job_title_code                              contact_job_title_code,
  rel_party.address1                                       contact_address1,
  rel_party.address2                                       contact_address2,
  rel_party.address3                                       contact_address3,
  rel_party.address4                                       contact_address4,
  rel_party.country                                         contact_country,
  rel_party.state                                              contact_state,
  rel_party.city                                               contact_city,
  rel_party.county                                          contact_county,
  rel_party.postal_code                                  contact_postal_code
FROM    hz_contact_points                         cont_point,
        hz_cust_account_roles                         acct_role,
        hz_parties                                             party,
        hz_parties                                             rel_party,
        hz_relationships                                   rel,
        hz_org_contacts                                   org_cont,
        hz_cust_accounts                                 role_acct,
        hz_contact_restrictions                        cont_res,
        hz_person_language                            per_lang,
        hz_cust_acct_sites_all                        hcasa
WHERE   acct_role.party_id                   = rel.party_id
  and   acct_role.role_type                        = 'CONTACT'
  and   org_cont.party_relationship_id      = rel.relationship_id
  and   rel.subject_id                                  = party.party_id
  and   rel_party.party_id                           = rel.party_id
  and   cont_point.owner_table_id(+)        = rel_party.party_id
  and   cont_point.contact_point_type(+)   = 'EMAIL'
  and   cont_point.primary_flag(+)            = 'Y'
  and   acct_role.cust_account_id              = role_acct.cust_account_id
  and   role_acct.party_id                          =  rel.object_id
  and   party.party_id                                 = per_lang.party_id(+)
  and   per_lang.native_language(+)         = 'Y'
  and   party.party_id                                 = cont_res.subject_id(+)
  and   cont_res.subject_table(+)               = 'HZ_PARTIES'
  and   role_acct.cust_account_id              =  hcasa.cust_account_id
  and   hcasa.cust_acct_site_id                  =  acct_role.cust_acct_site_id
--  and   acct_role.cust_account_id           =  p_customer_id --3177
--  and   acct_role.cust_acct_site_id         =  p_address_id
--  and   hcasa.org_id                                =  90

Basics of R12

How to Initialize Apps in BACK END ?


Ans.


BEGIN
fnd_global.apps_initialize(user_id => fnd_global.USER_ID,resp_id => fnd_global.RESP_ID,resp_appl_id => fnd_global.RESP_APPL_ID);
end;