View: PAFV_CUSTOMER_CONTACTS

Product:	PA - Projects
Description:	Business view to show information about the customer contacts for the projects.
Implementation/DBA Data:	APPS.PAFV_CUSTOMER_CONTACTS

View Text

SELECT PPA.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PPC.CUSTOMER_ID
, HZ_P.PARTY_NAME
, PPC.CONTACT_ID
, HZ_P1.PERSON_FIRST_NAME||' '||HZ_P1.PERSON_LAST_NAME
, PPC.PROJECT_CONTACT_TYPE_CODE
, ' _LA: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
, HZ_CUST_ACCOUNTS HZ_C
, HZ_PARTIES HZ_P
, 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
AND HZ_C.CUST_ACCOUNT_ID = PPC.CUSTOMER_ID
AND HZ_C.PARTY_ID = HZ_P.PARTY_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

Columns