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_STAGE_MAP_TRANSFORM dependencies on HZ_RELATIONSHIPS

Line 1085: --bug 4500011 replaced hz_party_relationships with hz_relationships

1081: l_party_type VARCHAR2(30);
1082: l_org_contact_id NUMBER;
1083: l_sql_err_message VARCHAR2(2000);
1084:
1085: --bug 4500011 replaced hz_party_relationships with hz_relationships
1086: CURSOR c_contact IS
1087: SELECT oc.org_contact_id
1088: FROM HZ_RELATIONSHIPS pr, HZ_ORG_CONTACTS oc
1089: WHERE pr.relationship_id = oc.party_relationship_id

Line 1088: FROM HZ_RELATIONSHIPS pr, HZ_ORG_CONTACTS oc

1084:
1085: --bug 4500011 replaced hz_party_relationships with hz_relationships
1086: CURSOR c_contact IS
1087: SELECT oc.org_contact_id
1088: FROM HZ_RELATIONSHIPS pr, HZ_ORG_CONTACTS oc
1089: WHERE pr.relationship_id = oc.party_relationship_id
1090: AND pr.subject_id = p_party_id
1091: AND pr.subject_table_name = 'HZ_PARTIES'
1092: AND pr.object_table_name = 'HZ_PARTIES'

Line 1421: FROM HZ_DQM_STAGE_GT g, HZ_RELATIONSHIPS r,

1417: oc.ORG_CONTACT_ID , r.OBJECT_ID, r.PARTY_ID, g.PARTY_INDEX, r.STATUS
1418: ,rtrim(pp.person_first_name || ' ' || pp.person_last_name)
1419: ,oc.CONTACT_NUMBER
1420: ,oc.JOB_TITLE
1421: FROM HZ_DQM_STAGE_GT g, HZ_RELATIONSHIPS r,
1422: HZ_ORG_CONTACTS oc, HZ_PERSON_PROFILES pp
1423: WHERE oc.party_relationship_id = r.relationship_id
1424: AND r.object_id = g.party_id
1425: AND r.subject_id = pp.party_id

Line 1547: HZ_RELATIONSHIPS r, HZ_PERSON_PROFILES pp

1543: , H_TX2(1)
1544: , H_TX11(1)
1545: , H_TX22(1)
1546: FROM HZ_ORG_CONTACTS oc, HZ_DQM_SYNC_INTERFACE d,
1547: HZ_RELATIONSHIPS r, HZ_PERSON_PROFILES pp
1548: WHERE d.ENTITY = 'CONTACTS'
1549: AND oc.org_contact_id = p_org_contact_id
1550: AND oc.org_contact_id = d.RECORD_ID
1551: AND oc.party_relationship_id = r.relationship_id

Line 1663: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r

1659:
1660: l_party_id := -1;
1661:
1662: SELECT r.object_id INTO l_party_id
1663: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
1664: WHERE oc.org_contact_id = p_org_contact_id
1665: AND oc.party_relationship_id = r.relationship_id
1666: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1667: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 1682: HZ_RELATIONSHIPS r, HZ_PERSON_PROFILES pp

1678: ,H_TX2(1)
1679: ,H_TX11(1)
1680: ,H_TX22(1)
1681: FROM HZ_ORG_CONTACTS oc,
1682: HZ_RELATIONSHIPS r, HZ_PERSON_PROFILES pp
1683: WHERE
1684: oc.org_contact_id = p_org_contact_id
1685: AND oc.party_relationship_id = r.relationship_id
1686: AND r.subject_id = pp.party_id

Line 2150: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r

2146:
2147: IF l_party_type = 'PARTY_RELATIONSHIP' THEN
2148: BEGIN
2149: SELECT r.object_id, org_contact_id INTO l_party_id,l_org_contact_id
2150: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
2151: WHERE r.party_id = l_party_id1
2152: AND r.relationship_id = oc.party_relationship_id
2153: AND r.directional_flag = 'F'
2154: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 2177: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r

2173: l_org_contact_id:=NULL;
2174: ELSE
2175: BEGIN
2176: SELECT r.object_id, org_contact_id INTO l_party_id,l_org_contact_id
2177: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
2178: WHERE r.party_id = l_ot_id
2179: AND r.relationship_id = oc.party_relationship_id
2180: AND r.directional_flag = 'F'
2181: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 2761: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r

2757:
2758: IF l_party_type = 'PARTY_RELATIONSHIP' THEN
2759: BEGIN
2760: SELECT r.object_id, org_contact_id INTO l_party_id,l_org_contact_id
2761: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
2762: WHERE r.party_id = l_party_id1
2763: AND r.relationship_id = oc.party_relationship_id
2764: AND r.directional_flag = 'F'
2765: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 3736: FROM HZ_DQM_SYNC_INTERFACE dsi, HZ_RELATIONSHIPS r,

3732: ,dsi.ROWID
3733: ,rtrim(pp.person_first_name || ' ' || pp.person_last_name)
3734: ,oc.CONTACT_NUMBER
3735: ,oc.JOB_TITLE
3736: FROM HZ_DQM_SYNC_INTERFACE dsi, HZ_RELATIONSHIPS r,
3737: HZ_ORG_CONTACTS oc, HZ_PERSON_PROFILES pp
3738: WHERE oc.party_relationship_id = r.relationship_id
3739: AND dsi.record_id = oc.org_contact_id
3740: AND r.subject_id = pp.party_id

Line 4480: hz_relationships r, hz_person_profiles pp

4476: ,rtrim(pp.person_first_name || ' ' || pp.person_last_name)
4477: ,oc.CONTACT_NUMBER
4478: ,oc.JOB_TITLE
4479: FROM hz_org_contacts oc, hz_imp_contacts_sg ocsg, hz_imp_batch_details bd,
4480: hz_relationships r, hz_person_profiles pp
4481: WHERE ocsg.batch_mode_flag = p_batch_mode_flag
4482: AND oc.party_relationship_id = r.relationship_id
4483: AND ocsg.batch_id = p_batch_id
4484: AND ocsg.sub_orig_system = p_os

Line 4510: ,hz_relationships r, hz_person_profiles pp

4506: ,rtrim(pp.person_first_name || ' ' || pp.person_last_name)
4507: ,oc.CONTACT_NUMBER
4508: ,oc.JOB_TITLE
4509: FROM hz_org_contacts oc, hz_imp_relships_sg rsg, hz_imp_batch_details bd
4510: ,hz_relationships r, hz_person_profiles pp
4511: WHERE rsg.batch_mode_flag = p_batch_mode_flag
4512: AND rsg.batch_id = p_batch_id
4513: AND rsg.sub_orig_system = p_os
4514: AND rsg.relationship_id = oc.party_relationship_id