VIEW: APPS.PA_PROJECT_CONTACTS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'