VIEW: APPS.PAFV_CUSTOMER_CONTACTS

Source

View Text - Preformatted

SELECT ppa.project_id , ppa.name,ppa.segment1 , ppc.customer_id , hz_p.party_name , ppc.contact_id , /* tca uptake rco.first_name||' '||rco.last_name , */ hz_p1.person_first_name||' '||hz_p1.person_last_name , ppc.project_contact_type_code , '_LA:ppc.project_contact_type_code:PA_LOOKUPS:PROJECT CONTACT TYPE:MEANING' , ppc.LAST_UPDATE_DATE , ppc.LAST_UPDATED_BY , ppc.CREATION_DATE , ppc.CREATED_BY FROM pa_project_contacts ppc , pa_projects_all ppa , /* Commented for tca uptake ra_customers rc */ hz_cust_accounts hz_c, hz_parties hz_p, /* Commented for tca uptake ra_contacts rco */ hz_cust_account_roles hz_r, hz_parties hz_p1, hz_org_contacts org_cont, hz_relationships rel WHERE ppc.project_id = ppa.project_id /* Commented for tca uptake and ppc.customer_id = rc.customer_id */ AND hz_c.cust_account_id = ppc.customer_id AND hz_c.party_id = hz_p.party_id /* Commented for tca uptake and ppc.contact_id = rco.contact_id */ and hz_r.cust_account_id = ppc.customer_id and hz_r.cust_account_role_id = ppc.contact_id and hz_r.party_id = rel.party_id and hz_r.role_type = 'CONTACT' and rel.relationship_id = org_cont.party_relationship_id and OBJECT_TABLE_NAME = 'HZ_PARTIES' AND DIRECTIONAL_FLAG = 'F' and hz_p1.party_id = rel.subject_id and '_SEC:ppa.org_id' is not null WITH READ ONLY

View Text - HTML Formatted

SELECT PPA.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PPC.CUSTOMER_ID
, HZ_P.PARTY_NAME
, PPC.CONTACT_ID
, /* TCA UPTAKE RCO.FIRST_NAME||' '||RCO.LAST_NAME
, */ HZ_P1.PERSON_FIRST_NAME||' '||HZ_P1.PERSON_LAST_NAME
, PPC.PROJECT_CONTACT_TYPE_CODE
, '_LA:PPC.PROJECT_CONTACT_TYPE_CODE:PA_LOOKUPS:PROJECT CONTACT TYPE:MEANING'
, PPC.LAST_UPDATE_DATE
, PPC.LAST_UPDATED_BY
, PPC.CREATION_DATE
, PPC.CREATED_BY
FROM PA_PROJECT_CONTACTS PPC
, PA_PROJECTS_ALL PPA
, /* COMMENTED FOR TCA UPTAKE RA_CUSTOMERS RC */ HZ_CUST_ACCOUNTS HZ_C
, HZ_PARTIES HZ_P
, /* COMMENTED FOR TCA UPTAKE RA_CONTACTS RCO */ HZ_CUST_ACCOUNT_ROLES HZ_R
, HZ_PARTIES HZ_P1
, HZ_ORG_CONTACTS ORG_CONT
, HZ_RELATIONSHIPS REL
WHERE PPC.PROJECT_ID = PPA.PROJECT_ID /* COMMENTED FOR TCA UPTAKE
AND PPC.CUSTOMER_ID = RC.CUSTOMER_ID */
AND HZ_C.CUST_ACCOUNT_ID = PPC.CUSTOMER_ID
AND HZ_C.PARTY_ID = HZ_P.PARTY_ID /* COMMENTED FOR TCA UPTAKE
AND PPC.CONTACT_ID = RCO.CONTACT_ID */
AND HZ_R.CUST_ACCOUNT_ID = PPC.CUSTOMER_ID
AND HZ_R.CUST_ACCOUNT_ROLE_ID = PPC.CONTACT_ID
AND HZ_R.PARTY_ID = REL.PARTY_ID
AND HZ_R.ROLE_TYPE = 'CONTACT'
AND REL.RELATIONSHIP_ID = ORG_CONT.PARTY_RELATIONSHIP_ID
AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND DIRECTIONAL_FLAG = 'F'
AND HZ_P1.PARTY_ID = REL.SUBJECT_ID
AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY