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 1307: start_date hz_relationships.start_date%Type,

1303: TYPE local_rrs_trade_area_grp_tab IS TABLE OF local_rrs_trade_area_grp_rec;
1304: l_trade_area_groups_details local_rrs_trade_area_grp_tab;
1305:
1306: TYPE local_rrs_relationship_rec is RECORD (
1307: start_date hz_relationships.start_date%Type,
1308: end_date hz_relationships.end_date%Type,
1309: comments hz_relationships.comments%Type,
1310: subject_party_name hz_parties.party_name%Type,
1311: object_party_name hz_parties.party_name%Type,

Line 1308: end_date hz_relationships.end_date%Type,

1304: l_trade_area_groups_details local_rrs_trade_area_grp_tab;
1305:
1306: TYPE local_rrs_relationship_rec is RECORD (
1307: start_date hz_relationships.start_date%Type,
1308: end_date hz_relationships.end_date%Type,
1309: comments hz_relationships.comments%Type,
1310: subject_party_name hz_parties.party_name%Type,
1311: object_party_name hz_parties.party_name%Type,
1312: relationship_role hz_relationship_types.role%Type,

Line 1309: comments hz_relationships.comments%Type,

1305:
1306: TYPE local_rrs_relationship_rec is RECORD (
1307: start_date hz_relationships.start_date%Type,
1308: end_date hz_relationships.end_date%Type,
1309: comments hz_relationships.comments%Type,
1310: subject_party_name hz_parties.party_name%Type,
1311: object_party_name hz_parties.party_name%Type,
1312: relationship_role hz_relationship_types.role%Type,
1313: relationship_role_meaning fnd_lookup_values.description%Type

Line 1519: FROM hz_relationships HzPuiRelationshipsEO,

1515: reltype.role relationship_role,
1516: relationshiprolelu.description relationship_role_meaning
1517: BULK COLLECT
1518: INTO l_relationship_details
1519: FROM hz_relationships HzPuiRelationshipsEO,
1520: hz_relationship_types reltype,
1521: hz_parties subjectparty,
1522: hz_parties objectparty,
1523: fnd_lookup_values subjectpartytypelu,

Line 1730: relationship_id hz_relationships.relationship_id%Type,

1726: l_url_details local_rrs_site_url_tab;
1727:
1728:
1729: TYPE local_rrs_site_person_rec is RECORD (
1730: relationship_id hz_relationships.relationship_id%Type,
1731: subject_type hz_relationships.subject_type%Type,
1732: object_id hz_relationships.object_id%Type,
1733: object_type hz_relationships.object_type%Type,
1734: object_table_name hz_relationships.object_table_name%Type,

Line 1731: subject_type hz_relationships.subject_type%Type,

1727:
1728:
1729: TYPE local_rrs_site_person_rec is RECORD (
1730: relationship_id hz_relationships.relationship_id%Type,
1731: subject_type hz_relationships.subject_type%Type,
1732: object_id hz_relationships.object_id%Type,
1733: object_type hz_relationships.object_type%Type,
1734: object_table_name hz_relationships.object_table_name%Type,
1735: relationship_party_id hz_relationships.party_id%Type,

Line 1732: object_id hz_relationships.object_id%Type,

1728:
1729: TYPE local_rrs_site_person_rec is RECORD (
1730: relationship_id hz_relationships.relationship_id%Type,
1731: subject_type hz_relationships.subject_type%Type,
1732: object_id hz_relationships.object_id%Type,
1733: object_type hz_relationships.object_type%Type,
1734: object_table_name hz_relationships.object_table_name%Type,
1735: relationship_party_id hz_relationships.party_id%Type,
1736: relationship_type hz_relationships.relationship_type%Type,

Line 1733: object_type hz_relationships.object_type%Type,

1729: TYPE local_rrs_site_person_rec is RECORD (
1730: relationship_id hz_relationships.relationship_id%Type,
1731: subject_type hz_relationships.subject_type%Type,
1732: object_id hz_relationships.object_id%Type,
1733: object_type hz_relationships.object_type%Type,
1734: object_table_name hz_relationships.object_table_name%Type,
1735: relationship_party_id hz_relationships.party_id%Type,
1736: relationship_type hz_relationships.relationship_type%Type,
1737: relationship_code hz_relationships.relationship_code%Type,

Line 1734: object_table_name hz_relationships.object_table_name%Type,

1730: relationship_id hz_relationships.relationship_id%Type,
1731: subject_type hz_relationships.subject_type%Type,
1732: object_id hz_relationships.object_id%Type,
1733: object_type hz_relationships.object_type%Type,
1734: object_table_name hz_relationships.object_table_name%Type,
1735: relationship_party_id hz_relationships.party_id%Type,
1736: relationship_type hz_relationships.relationship_type%Type,
1737: relationship_code hz_relationships.relationship_code%Type,
1738: start_date hz_relationships.start_date%Type,

Line 1735: relationship_party_id hz_relationships.party_id%Type,

1731: subject_type hz_relationships.subject_type%Type,
1732: object_id hz_relationships.object_id%Type,
1733: object_type hz_relationships.object_type%Type,
1734: object_table_name hz_relationships.object_table_name%Type,
1735: relationship_party_id hz_relationships.party_id%Type,
1736: relationship_type hz_relationships.relationship_type%Type,
1737: relationship_code hz_relationships.relationship_code%Type,
1738: start_date hz_relationships.start_date%Type,
1739: end_date hz_relationships.end_date%Type,

Line 1736: relationship_type hz_relationships.relationship_type%Type,

1732: object_id hz_relationships.object_id%Type,
1733: object_type hz_relationships.object_type%Type,
1734: object_table_name hz_relationships.object_table_name%Type,
1735: relationship_party_id hz_relationships.party_id%Type,
1736: relationship_type hz_relationships.relationship_type%Type,
1737: relationship_code hz_relationships.relationship_code%Type,
1738: start_date hz_relationships.start_date%Type,
1739: end_date hz_relationships.end_date%Type,
1740: comments hz_relationships.comments%Type,

Line 1737: relationship_code hz_relationships.relationship_code%Type,

1733: object_type hz_relationships.object_type%Type,
1734: object_table_name hz_relationships.object_table_name%Type,
1735: relationship_party_id hz_relationships.party_id%Type,
1736: relationship_type hz_relationships.relationship_type%Type,
1737: relationship_code hz_relationships.relationship_code%Type,
1738: start_date hz_relationships.start_date%Type,
1739: end_date hz_relationships.end_date%Type,
1740: comments hz_relationships.comments%Type,
1741: status hz_relationships.status%Type,

Line 1738: start_date hz_relationships.start_date%Type,

1734: object_table_name hz_relationships.object_table_name%Type,
1735: relationship_party_id hz_relationships.party_id%Type,
1736: relationship_type hz_relationships.relationship_type%Type,
1737: relationship_code hz_relationships.relationship_code%Type,
1738: start_date hz_relationships.start_date%Type,
1739: end_date hz_relationships.end_date%Type,
1740: comments hz_relationships.comments%Type,
1741: status hz_relationships.status%Type,
1742: actual_content_source hz_relationships.actual_content_source%Type,

Line 1739: end_date hz_relationships.end_date%Type,

1735: relationship_party_id hz_relationships.party_id%Type,
1736: relationship_type hz_relationships.relationship_type%Type,
1737: relationship_code hz_relationships.relationship_code%Type,
1738: start_date hz_relationships.start_date%Type,
1739: end_date hz_relationships.end_date%Type,
1740: comments hz_relationships.comments%Type,
1741: status hz_relationships.status%Type,
1742: actual_content_source hz_relationships.actual_content_source%Type,
1743: subject_party_name hz_parties.party_name%Type,

Line 1740: comments hz_relationships.comments%Type,

1736: relationship_type hz_relationships.relationship_type%Type,
1737: relationship_code hz_relationships.relationship_code%Type,
1738: start_date hz_relationships.start_date%Type,
1739: end_date hz_relationships.end_date%Type,
1740: comments hz_relationships.comments%Type,
1741: status hz_relationships.status%Type,
1742: actual_content_source hz_relationships.actual_content_source%Type,
1743: subject_party_name hz_parties.party_name%Type,
1744: subject_party_number hz_parties.party_number%Type,

Line 1741: status hz_relationships.status%Type,

1737: relationship_code hz_relationships.relationship_code%Type,
1738: start_date hz_relationships.start_date%Type,
1739: end_date hz_relationships.end_date%Type,
1740: comments hz_relationships.comments%Type,
1741: status hz_relationships.status%Type,
1742: actual_content_source hz_relationships.actual_content_source%Type,
1743: subject_party_name hz_parties.party_name%Type,
1744: subject_party_number hz_parties.party_number%Type,
1745: subject_party_known_as hz_parties.known_as%Type,

Line 1742: actual_content_source hz_relationships.actual_content_source%Type,

1738: start_date hz_relationships.start_date%Type,
1739: end_date hz_relationships.end_date%Type,
1740: comments hz_relationships.comments%Type,
1741: status hz_relationships.status%Type,
1742: actual_content_source hz_relationships.actual_content_source%Type,
1743: subject_party_name hz_parties.party_name%Type,
1744: subject_party_number hz_parties.party_number%Type,
1745: subject_party_known_as hz_parties.known_as%Type,
1746: object_party_name hz_parties.party_name%Type,

Line 2077: FROM hz_relationships HzPuiRelationshipsEO,

2073: objectpartytypelu.meaning object_type_meaning,
2074: relationshiprolelu.description relationship_role_meaning
2075: BULK COLLECT
2076: INTO l_person_details
2077: FROM hz_relationships HzPuiRelationshipsEO,
2078: hz_relationship_types reltype,
2079: hz_parties subjectparty,
2080: hz_parties objectparty,
2081: fnd_lookup_values subjectpartytypelu,