View: PV_RESOURCE_INFO_V

Product:	PV - Partner Management
Description:
Implementation/DBA Data:	APPS.PV_RESOURCE_INFO_V

View Text

SELECT A.USER_ID
, A.RESOURCE_ID
, A.CONTACT_ID
, A.CATEGORY
, C.RELATIONSHIP_CODE
, D.PARTY_ID
, D.PARTY_NAME
, E.PARTY_ID
, E.PARTY_NAME
FROM JTF_RS_RESOURCE_EXTNS A
, HZ_ORG_CONTACTS B
, HZ_RELATIONSHIPS C
, HZ_PARTIES D
, HZ_PARTIES E
WHERE A.CONTACT_ID IS NOT NULL
AND B.ORG_CONTACT_ID = A.CONTACT_ID
AND C.RELATIONSHIP_ID = B.PARTY_RELATIONSHIP_ID
AND D.PARTY_ID = C.SUBJECT_ID
AND E.PARTY_ID = C.OBJECT_ID
AND C.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND C.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND C.DIRECTIONAL_FLAG = 'F'

Columns