VIEW: APPS.PV_RESOURCE_INFO_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'