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.RRS_SITE_INFO dependencies on HZ_RELATIONSHIPS

Line 1288: start_date hz_relationships.start_date%Type,

1284: TYPE local_rrs_trade_area_grp_tab IS TABLE OF local_rrs_trade_area_grp_rec;
1285: l_trade_area_groups_details local_rrs_trade_area_grp_tab;
1286:
1287: TYPE local_rrs_relationship_rec is RECORD (
1288: start_date hz_relationships.start_date%Type,
1289: end_date hz_relationships.end_date%Type,
1290: comments hz_relationships.comments%Type,
1291: subject_party_name hz_parties.party_name%Type,
1292: object_party_name hz_parties.party_name%Type,

Line 1289: end_date hz_relationships.end_date%Type,

1285: l_trade_area_groups_details local_rrs_trade_area_grp_tab;
1286:
1287: TYPE local_rrs_relationship_rec is RECORD (
1288: start_date hz_relationships.start_date%Type,
1289: end_date hz_relationships.end_date%Type,
1290: comments hz_relationships.comments%Type,
1291: subject_party_name hz_parties.party_name%Type,
1292: object_party_name hz_parties.party_name%Type,
1293: relationship_role hz_relationship_types.role%Type,

Line 1290: comments hz_relationships.comments%Type,

1286:
1287: TYPE local_rrs_relationship_rec is RECORD (
1288: start_date hz_relationships.start_date%Type,
1289: end_date hz_relationships.end_date%Type,
1290: comments hz_relationships.comments%Type,
1291: subject_party_name hz_parties.party_name%Type,
1292: object_party_name hz_parties.party_name%Type,
1293: relationship_role hz_relationship_types.role%Type,
1294: relationship_role_meaning fnd_lookup_values.description%Type

Line 1452: FROM hz_relationships HzPuiRelationshipsEO,

1448: reltype.role relationship_role,
1449: relationshiprolelu.description relationship_role_meaning
1450: BULK COLLECT
1451: INTO l_relationship_details
1452: FROM hz_relationships HzPuiRelationshipsEO,
1453: hz_relationship_types reltype,
1454: hz_parties subjectparty,
1455: hz_parties objectparty,
1456: fnd_lookup_values subjectpartytypelu,

Line 1662: relationship_id hz_relationships.relationship_id%Type,

1658: l_url_details local_rrs_site_url_tab;
1659:
1660:
1661: TYPE local_rrs_site_person_rec is RECORD (
1662: relationship_id hz_relationships.relationship_id%Type,
1663: subject_type hz_relationships.subject_type%Type,
1664: object_id hz_relationships.object_id%Type,
1665: object_type hz_relationships.object_type%Type,
1666: object_table_name hz_relationships.object_table_name%Type,

Line 1663: subject_type hz_relationships.subject_type%Type,

1659:
1660:
1661: TYPE local_rrs_site_person_rec is RECORD (
1662: relationship_id hz_relationships.relationship_id%Type,
1663: subject_type hz_relationships.subject_type%Type,
1664: object_id hz_relationships.object_id%Type,
1665: object_type hz_relationships.object_type%Type,
1666: object_table_name hz_relationships.object_table_name%Type,
1667: relationship_party_id hz_relationships.party_id%Type,

Line 1664: object_id hz_relationships.object_id%Type,

1660:
1661: TYPE local_rrs_site_person_rec is RECORD (
1662: relationship_id hz_relationships.relationship_id%Type,
1663: subject_type hz_relationships.subject_type%Type,
1664: object_id hz_relationships.object_id%Type,
1665: object_type hz_relationships.object_type%Type,
1666: object_table_name hz_relationships.object_table_name%Type,
1667: relationship_party_id hz_relationships.party_id%Type,
1668: relationship_type hz_relationships.relationship_type%Type,

Line 1665: object_type hz_relationships.object_type%Type,

1661: TYPE local_rrs_site_person_rec is RECORD (
1662: relationship_id hz_relationships.relationship_id%Type,
1663: subject_type hz_relationships.subject_type%Type,
1664: object_id hz_relationships.object_id%Type,
1665: object_type hz_relationships.object_type%Type,
1666: object_table_name hz_relationships.object_table_name%Type,
1667: relationship_party_id hz_relationships.party_id%Type,
1668: relationship_type hz_relationships.relationship_type%Type,
1669: relationship_code hz_relationships.relationship_code%Type,

Line 1666: object_table_name hz_relationships.object_table_name%Type,

1662: relationship_id hz_relationships.relationship_id%Type,
1663: subject_type hz_relationships.subject_type%Type,
1664: object_id hz_relationships.object_id%Type,
1665: object_type hz_relationships.object_type%Type,
1666: object_table_name hz_relationships.object_table_name%Type,
1667: relationship_party_id hz_relationships.party_id%Type,
1668: relationship_type hz_relationships.relationship_type%Type,
1669: relationship_code hz_relationships.relationship_code%Type,
1670: start_date hz_relationships.start_date%Type,

Line 1667: relationship_party_id hz_relationships.party_id%Type,

1663: subject_type hz_relationships.subject_type%Type,
1664: object_id hz_relationships.object_id%Type,
1665: object_type hz_relationships.object_type%Type,
1666: object_table_name hz_relationships.object_table_name%Type,
1667: relationship_party_id hz_relationships.party_id%Type,
1668: relationship_type hz_relationships.relationship_type%Type,
1669: relationship_code hz_relationships.relationship_code%Type,
1670: start_date hz_relationships.start_date%Type,
1671: end_date hz_relationships.end_date%Type,

Line 1668: relationship_type hz_relationships.relationship_type%Type,

1664: object_id hz_relationships.object_id%Type,
1665: object_type hz_relationships.object_type%Type,
1666: object_table_name hz_relationships.object_table_name%Type,
1667: relationship_party_id hz_relationships.party_id%Type,
1668: relationship_type hz_relationships.relationship_type%Type,
1669: relationship_code hz_relationships.relationship_code%Type,
1670: start_date hz_relationships.start_date%Type,
1671: end_date hz_relationships.end_date%Type,
1672: comments hz_relationships.comments%Type,

Line 1669: relationship_code hz_relationships.relationship_code%Type,

1665: object_type hz_relationships.object_type%Type,
1666: object_table_name hz_relationships.object_table_name%Type,
1667: relationship_party_id hz_relationships.party_id%Type,
1668: relationship_type hz_relationships.relationship_type%Type,
1669: relationship_code hz_relationships.relationship_code%Type,
1670: start_date hz_relationships.start_date%Type,
1671: end_date hz_relationships.end_date%Type,
1672: comments hz_relationships.comments%Type,
1673: status hz_relationships.status%Type,

Line 1670: start_date hz_relationships.start_date%Type,

1666: object_table_name hz_relationships.object_table_name%Type,
1667: relationship_party_id hz_relationships.party_id%Type,
1668: relationship_type hz_relationships.relationship_type%Type,
1669: relationship_code hz_relationships.relationship_code%Type,
1670: start_date hz_relationships.start_date%Type,
1671: end_date hz_relationships.end_date%Type,
1672: comments hz_relationships.comments%Type,
1673: status hz_relationships.status%Type,
1674: actual_content_source hz_relationships.actual_content_source%Type,

Line 1671: end_date hz_relationships.end_date%Type,

1667: relationship_party_id hz_relationships.party_id%Type,
1668: relationship_type hz_relationships.relationship_type%Type,
1669: relationship_code hz_relationships.relationship_code%Type,
1670: start_date hz_relationships.start_date%Type,
1671: end_date hz_relationships.end_date%Type,
1672: comments hz_relationships.comments%Type,
1673: status hz_relationships.status%Type,
1674: actual_content_source hz_relationships.actual_content_source%Type,
1675: subject_party_name hz_parties.party_name%Type,

Line 1672: comments hz_relationships.comments%Type,

1668: relationship_type hz_relationships.relationship_type%Type,
1669: relationship_code hz_relationships.relationship_code%Type,
1670: start_date hz_relationships.start_date%Type,
1671: end_date hz_relationships.end_date%Type,
1672: comments hz_relationships.comments%Type,
1673: status hz_relationships.status%Type,
1674: actual_content_source hz_relationships.actual_content_source%Type,
1675: subject_party_name hz_parties.party_name%Type,
1676: subject_party_number hz_parties.party_number%Type,

Line 1673: status hz_relationships.status%Type,

1669: relationship_code hz_relationships.relationship_code%Type,
1670: start_date hz_relationships.start_date%Type,
1671: end_date hz_relationships.end_date%Type,
1672: comments hz_relationships.comments%Type,
1673: status hz_relationships.status%Type,
1674: actual_content_source hz_relationships.actual_content_source%Type,
1675: subject_party_name hz_parties.party_name%Type,
1676: subject_party_number hz_parties.party_number%Type,
1677: subject_party_known_as hz_parties.known_as%Type,

Line 1674: actual_content_source hz_relationships.actual_content_source%Type,

1670: start_date hz_relationships.start_date%Type,
1671: end_date hz_relationships.end_date%Type,
1672: comments hz_relationships.comments%Type,
1673: status hz_relationships.status%Type,
1674: actual_content_source hz_relationships.actual_content_source%Type,
1675: subject_party_name hz_parties.party_name%Type,
1676: subject_party_number hz_parties.party_number%Type,
1677: subject_party_known_as hz_parties.known_as%Type,
1678: object_party_name hz_parties.party_name%Type,

Line 2002: FROM hz_relationships HzPuiRelationshipsEO,

1998: objectpartytypelu.meaning object_type_meaning,
1999: relationshiprolelu.description relationship_role_meaning
2000: BULK COLLECT
2001: INTO l_person_details
2002: FROM hz_relationships HzPuiRelationshipsEO,
2003: hz_relationship_types reltype,
2004: hz_parties subjectparty,
2005: hz_parties objectparty,
2006: fnd_lookup_values subjectpartytypelu,