View: PA_CUSTOMER_CONTACT_NAMES_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_CUSTOMER_CONTACT_NAMES_V

View Text

SELECT DISTINCT SUBSTRB(PARTY.PERSON_LAST_NAME
, 1
, 50)||'
, '||SUBSTRB(PARTY.PERSON_FIRST_NAME
, 1
, 40)
, ORG_CONT.JOB_TITLE
, ACCT_ROLE.CUST_ACCOUNT_ROLE_ID
, ACCT_ROLE.CUST_ACCOUNT_ID
, ROLE_RESP.RESPONSIBILITY_TYPE
, ACCT_ROLE.CUST_ACCT_SITE_ID
FROM HZ_PARTIES PARTY
, HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
, HZ_RELATIONSHIPS REL
, HZ_ORG_CONTACTS ORG_CONT
, HZ_ROLE_RESPONSIBILITY ROLE_RESP
, HZ_CUST_ACCT_SITES ACCT_SITE
WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = ROLE_RESP.CUST_ACCOUNT_ROLE_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 NVL(ACCT_ROLE.CURRENT_ROLE_STATE
, 'A') = 'A'
AND ACCT_ROLE.CUST_ACCT_SITE_ID IS NULL
AND REL.SUBJECT_TYPE = 'PERSON'
AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES' UNION ALL SELECT DISTINCT SUBSTRB(PARTY.PERSON_LAST_NAME
, 1
, 50)||'
, '||SUBSTRB(PARTY.PERSON_FIRST_NAME
, 1
, 40)
, ORG_CONT.JOB_TITLE
, ACCT_ROLE.CUST_ACCOUNT_ROLE_ID
, ACCT_ROLE.CUST_ACCOUNT_ID
, ROLE_RESP.RESPONSIBILITY_TYPE
, ACCT_ROLE.CUST_ACCT_SITE_ID
FROM HZ_PARTIES PARTY
, HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
, HZ_RELATIONSHIPS REL
, HZ_ORG_CONTACTS ORG_CONT
, HZ_ROLE_RESPONSIBILITY ROLE_RESP
, HZ_CUST_ACCT_SITES ACCT_SITE
WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = ROLE_RESP.CUST_ACCOUNT_ROLE_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 NVL(ACCT_ROLE.CURRENT_ROLE_STATE
, 'A') = 'A'
AND ACCT_ROLE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
AND REL.SUBJECT_TYPE = 'PERSON'
AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES' ORDER BY 1

Columns