View: PA_PROJECT_CONTACTS_V

Product:	PA - Projects
Description:	10SC only
Implementation/DBA Data:	APPS.PA_PROJECT_CONTACTS_V

View Text

SELECT PC.ROWID
, PC.PROJECT_ID
, PC.CUSTOMER_ID
, PC.CONTACT_ID
, PC.PROJECT_CONTACT_TYPE_CODE
, PC.LAST_UPDATE_DATE
, PC.LAST_UPDATED_BY
, PC.CREATION_DATE
, PC.CREATED_BY
, PC.LAST_UPDATE_LOGIN
, LU.MEANING
, SUBSTRB(PARTY.PERSON_LAST_NAME
, 1
, 50) || '
, '||SUBSTRB(PARTY.PERSON_FIRST_NAME
, 1
, 40)
, ORG_CONT.JOB_TITLE
, PC.RECORD_VERSION_NUMBER
, PC.BILL_SHIP_CUSTOMER_ID
FROM PA_PROJECT_CONTACTS PC
, PA_LOOKUPS LU
, HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
, HZ_RELATIONSHIPS REL
, HZ_ORG_CONTACTS ORG_CONT
, HZ_PARTIES PARTY
WHERE LU.LOOKUP_TYPE = 'PROJECT CONTACT TYPE'
AND LU.LOOKUP_CODE = PC.PROJECT_CONTACT_TYPE_CODE
AND ACCT_ROLE.CUST_ACCOUNT_ID = PC.BILL_SHIP_CUSTOMER_ID
AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = PC.CONTACT_ID
AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
AND REL.RELATIONSHIP_ID = ORG_CONT.PARTY_RELATIONSHIP_ID
AND PARTY.PARTY_ID = REL.SUBJECT_ID
AND TRUNC(SYSDATE) BETWEEN LU.START_DATE_ACTIVE
AND NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE))
AND REL.SUBJECT_TYPE = 'PERSON'
AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Columns