eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_BES_BO_UTIL_PKG dependencies on HZ_RELATIONSHIPS

Line 239: FROM hz_org_contacts oc, HZ_RELATIONSHIPS r

235: WHEN 'ORGANIZATION' THEN OWNER_TABLE_ID
236: WHEN 'PERSON' THEN OWNER_TABLE_ID
237: WHEN 'PARTY_RELATIONSHIP' THEN
238: (SELECT oc.org_contact_id
239: FROM hz_org_contacts oc, HZ_RELATIONSHIPS r
240: WHERE r.relationship_id = oc.party_relationship_id
241: AND r.subject_type = 'PERSON'
242: AND r.object_type = 'ORGANIZATION'
243: AND r.party_id = p.party_id)

Line 262: FROM hz_org_contacts oc, HZ_RELATIONSHIPS r

258: WHEN 'ORGANIZATION' THEN p.party_id -- identify GrandParentEntityId when PS is parent of CPP, Org parentOf PS
259: WHEN 'PERSON' THEN p.party_id -- identify GrandParentEntityId when PS is parent of CPP, Per parentOf PS
260: WHEN 'PARTY_RELATIONSHIP' THEN -- identify GrandParentEntityId when PS is parent of CPP, Rel parentOf PS
261: (SELECT oc.org_contact_id
262: FROM hz_org_contacts oc, HZ_RELATIONSHIPS r
263: WHERE r.relationship_id = oc.party_relationship_id
264: AND r.party_id = p.party_id
265: AND r.subject_type = 'PERSON'
266: AND r.object_type = 'ORGANIZATION')

Line 275: FROM hz_relationships r, hz_org_contacts oc

271: from HZ_PARTY_SITES ps
272: where ps.party_site_id = PARENT_ID))
273: WHEN 'HZ_ORG_CONTACTS' THEN -- identify GrandParentEntityId when OrgContact is parent of CPP
274: (SELECT r.object_id
275: FROM hz_relationships r, hz_org_contacts oc
276: WHERE oc.org_contact_id = PARENT_ID
277: AND oc.party_relationship_id = r.relationship_id
278: AND subject_type ='PERSON'
279: AND object_type = 'ORGANIZATION')

Line 474: FROM hz_org_contacts oc, HZ_RELATIONSHIPS r

470: WHEN 'ORGANIZATION' THEN p.party_id
471: WHEN 'PERSON' THEN p.party_id
472: WHEN 'PARTY_RELATIONSHIP' THEN
473: (SELECT oc.org_contact_id
474: FROM hz_org_contacts oc, HZ_RELATIONSHIPS r
475: WHERE r.relationship_id = oc.party_relationship_id
476: AND r.party_id = p.party_id
477: AND r.subject_type = 'PERSON'
478: AND r.object_type = 'ORGANIZATION')

Line 763: AND event_id IS NULL) p, hz_org_contacts oc, hz_relationships r

759: ,CREATION_DATE
760: FROM HZ_BUS_OBJ_TRACKING
761: WHERE CHILD_ENTITY_NAME = 'HZ_PER_PROFILES_EXT_VL'
762: AND parent_bo_code = 'PERSON'
763: AND event_id IS NULL) p, hz_org_contacts oc, hz_relationships r
764: WHERE p.PARENT_ID = r.subject_id
765: AND r.subject_type = 'PERSON'
766: AND r.object_type = 'ORGANIZATION'
767: AND r.relationship_id = oc.party_relationship_id

Line 925: FROM HZ_BUS_OBJ_TRACKING t, hz_relationships r, hz_org_contacts oc

921: ,t.LAST_UPDATE_DATE
922: ,RANK()
923: OVER (PARTITION BY PARENT_BO_CODE, PARENT_ID
924: ORDER BY t.LAST_UPDATE_DATE, child_id) as acrrank
925: FROM HZ_BUS_OBJ_TRACKING t, hz_relationships r, hz_org_contacts oc
926: WHERE r.subject_id = PARENT_ID
927: AND oc.party_relationship_id = r.relationship_id
928: AND r.subject_type ='PERSON'
929: AND r.object_type = 'ORGANIZATION'

Line 1053: AND event_id IS NULL) p, hz_org_contacts oc, hz_relationships r

1049: ,CREATION_DATE
1050: FROM HZ_BUS_OBJ_TRACKING
1051: WHERE CHILD_ENTITY_NAME = 'HZ_PERSON_PROFILES'
1052: AND parent_bo_code = 'PERSON'
1053: AND event_id IS NULL) p, hz_org_contacts oc, hz_relationships r
1054: WHERE p.PARENT_ID = r.subject_id
1055: AND r.subject_type = 'PERSON'
1056: AND r.object_type = 'ORGANIZATION'
1057: AND r.relationship_id = oc.party_relationship_id

Line 1217: FROM HZ_BUS_OBJ_TRACKING t, hz_relationships r, hz_org_contacts oc

1213: ,t.LAST_UPDATE_DATE
1214: ,RANK()
1215: OVER (PARTITION BY PARENT_BO_CODE, PARENT_ID
1216: ORDER BY t.LAST_UPDATE_DATE, child_id) as pprank
1217: FROM HZ_BUS_OBJ_TRACKING t, hz_relationships r, hz_org_contacts oc
1218: WHERE r.subject_id = PARENT_ID
1219: AND oc.party_relationship_id = r.relationship_id
1220: AND r.subject_type ='PERSON'
1221: AND r.object_type = 'ORGANIZATION'

Line 1399: FROM hz_org_contacts oc, HZ_RELATIONSHIPS r

1395: WHEN 'ORGANIZATION' THEN p.party_id
1396: WHEN 'PERSON' THEN p.party_id
1397: WHEN 'PARTY_RELATIONSHIP' THEN
1398: (SELECT oc.org_contact_id
1399: FROM hz_org_contacts oc, HZ_RELATIONSHIPS r
1400: WHERE r.relationship_id = oc.party_relationship_id
1401: AND r.party_id = p.party_id
1402: AND r.subject_type = 'PERSON'
1403: AND r.object_type = 'ORGANIZATION')

Line 1590: FROM hz_relationships r, hz_org_contacts oc

1586: WHEN 'ORG' THEN NULL
1587: WHEN 'PERSON' THEN NULL
1588: WHEN 'ORG_CONTACT' THEN
1589: (SELECT r.object_id
1590: FROM hz_relationships r, hz_org_contacts oc
1591: WHERE oc.org_contact_id = PARENT_ID
1592: AND oc.party_relationship_id = r.relationship_id
1593: AND subject_type ='PERSON'
1594: AND object_type = 'ORGANIZATION')

Line 2016: FROM hz_org_contacts oc, HZ_RELATIONSHIPS r

2012: WHEN 'ORGANIZATION' THEN p.party_id
2013: WHEN 'PERSON' THEN p.party_id
2014: WHEN 'PARTY_RELATIONSHIP' THEN
2015: (SELECT oc.org_contact_id
2016: FROM hz_org_contacts oc, HZ_RELATIONSHIPS r
2017: WHERE r.relationship_id = oc.party_relationship_id
2018: AND r.party_id = p.party_id
2019: AND r.subject_type = 'PERSON'
2020: AND r.object_type = 'ORGANIZATION')

Line 3057: FROM hz_relationships r, hz_org_contacts oc

3053: WHEN 'ORG' THEN NULL -- to identify the grandParentEntityId of CP when Org is parentOf CP
3054: WHEN 'PERSON' THEN NULL -- to identify the grandParentEntityId of CP when Per is parentOf CP
3055: WHEN 'ORG_CONTACT' THEN -- to identify the grandParentEntityId of CP when Rel is parentOf CP
3056: (SELECT r.object_id
3057: FROM hz_relationships r, hz_org_contacts oc
3058: WHERE oc.org_contact_id = PARENT_ID
3059: AND oc.party_relationship_id = r.relationship_id
3060: AND subject_type ='PERSON'
3061: AND object_type = 'ORGANIZATION')

Line 3069: FROM hz_org_contacts oc, HZ_RELATIONSHIPS r

3065: WHEN 'ORGANIZATION' THEN p.party_id -- to identify the grandParentEntityId of CP when PS is parentOf CP, when Org is parentOF PS
3066: WHEN 'PERSON' THEN p.party_id -- to identify the grandParentEntityId of CP when PS is parentOf CP, when Per is parentOF PS
3067: WHEN 'PARTY_RELATIONSHIP' THEN -- to identify the grandParentEntityId of CP when PS is parentOf CP, when Rel is parentOF PS
3068: (SELECT oc.org_contact_id
3069: FROM hz_org_contacts oc, HZ_RELATIONSHIPS r
3070: WHERE r.relationship_id = oc.party_relationship_id
3071: AND r.party_id = p.party_id
3072: AND r.subject_type = 'PERSON'
3073: AND r.object_type = 'ORGANIZATION')