View: PA_PARTY_RESOURCE_DETAILS_V

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

View Text

SELECT HZP.PARTY_ID PARTY_ID
, HZP.PARTY_NAME PARTY_NAME
, HZP.PARTY_TYPE PARTY_TYPE
, HZP.EMAIL_ADDRESS EMAIL_ADDRESS
, HZP.PRIMARY_PHONE_NUMBER PHONE_NUMBER
, HZP.ADDRESS1 ADDRESS1
, HZP.ADDRESS2 ADDRESS2
, HZP.ADDRESS3 ADDRESS3
, HZP.ADDRESS4 ADDRESS4
, HZP.CITY CITY
, HZP.COUNTY COUNTY
, HZP.STATE STATE
, HZP.PROVINCE PROVINCE
, HZP.POSTAL_CODE POSTAL_CODE
, HZP.COUNTRY COUNTRY
, HZO.PARTY_ID ORG_PARTY_ID
, HZO.PARTY_NAME ORG_NAME
, HZR.START_DATE
, HZR.END_DATE
FROM HZ_PARTIES HZP
, HZ_PARTIES HZO
, HZ_RELATIONSHIPS HZR
WHERE HZP.PARTY_TYPE = 'PERSON'
AND HZO.PARTY_TYPE = 'ORGANIZATION'
AND HZR.RELATIONSHIP_CODE IN ('EMPLOYEE_OF'
, 'CONTACT_OF')
AND HZR.STATUS = 'A'
AND HZR.SUBJECT_ID = HZP.PARTY_ID
AND HZR.OBJECT_ID = HZO.PARTY_ID
AND HZR.SUBJECT_TYPE = 'PERSON'
AND HZR.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND HZR.SUBJECT_TABLE_NAME = 'HZ_PARTIES' UNION ALL SELECT HZO.PARTY_ID PARTY_ID
, HZO.PARTY_NAME PARTY_NAME
, HZO.PARTY_TYPE PARTY_TYPE
, HZO.EMAIL_ADDRESS EMAIL_ADDRESS
, HZO.PRIMARY_PHONE_NUMBER PHONE_NUMBER
, HZO.ADDRESS1 ADDRESS1
, HZO.ADDRESS2 ADDRESS2
, HZO.ADDRESS3 ADDRESS3
, HZO.ADDRESS4 ADDRESS4
, HZO.CITY CITY
, HZO.COUNTY COUNTY
, HZO.STATE STATE
, HZO.PROVINCE PROVINCE
, HZO.POSTAL_CODE POSTAL_CODE
, HZO.COUNTRY COUNTRY
, -999 ORG_PARTY_ID
, NULL ORG_NAME
, HZO.CREATION_DATE
, TO_DATE(NULL)
FROM HZ_PARTIES HZO
WHERE HZO.PARTY_TYPE = 'ORGANIZATION'

Columns