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_PARTIES

Line 166: party_name hz_parties.party_name%Type,

162: location_id rrs_sites_b.location_id%TYPE,
163: site_party_id rrs_sites_b.site_party_id%TYPE,
164: party_site_id rrs_sites_b.party_site_id%TYPE,
165: le_party_site_id rrs_sites_b.le_party_id%TYPE,
166: party_name hz_parties.party_name%Type,
167: property_location_id rrs_sites_b.property_location_id%TYPE,
168: start_date rrs_sites_b.start_date%TYPE,
169: end_date rrs_sites_b.end_date%TYPE,
170: name rrs_sites_tl.name%TYPE

Line 249: ,rrs_lookups_v lkup3 , BOM_CALENDARS BC, HZ_PARTIES HP

245: RST.NAME
246: Bulk Collect
247: INTO l_site_header_details
248: From RRS_SITES_B RSB, RRS_SITES_TL RST , rrs_lookups_v lkup1,rrs_lookups_v lkup2
249: ,rrs_lookups_v lkup3 , BOM_CALENDARS BC, HZ_PARTIES HP
250: WHERE RSB.SITE_IDENTIFICATION_NUMBER = p_site_id_num
251: and RSB.SITE_ID = RST.SITE_ID
252: and LKUP1.LOOKUP_TYPE = 'RRS_SITE_TYPE'
253: and LKUP1.LOOKUP_CODE = RSB.SITE_TYPE_CODE

Line 1310: subject_party_name hz_parties.party_name%Type,

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
1314: );

Line 1311: object_party_name hz_parties.party_name%Type,

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
1314: );
1315: TYPE local_rrs_relationship_tab IS TABLE OF local_rrs_relationship_rec;

Line 1521: hz_parties subjectparty,

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,
1524: fnd_lookup_values objectpartytypelu,
1525: fnd_lookup_values relationshiprolelu

Line 1522: hz_parties objectparty,

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,
1524: fnd_lookup_values objectpartytypelu,
1525: fnd_lookup_values relationshiprolelu
1526: WHERE HzPuiRelationshipsEO.subject_table_name = 'HZ_PARTIES'

Line 1526: WHERE HzPuiRelationshipsEO.subject_table_name = 'HZ_PARTIES'

1522: hz_parties objectparty,
1523: fnd_lookup_values subjectpartytypelu,
1524: fnd_lookup_values objectpartytypelu,
1525: fnd_lookup_values relationshiprolelu
1526: WHERE HzPuiRelationshipsEO.subject_table_name = 'HZ_PARTIES'
1527: AND HzPuiRelationshipsEO.object_table_name = 'HZ_PARTIES'
1528: AND HzPuiRelationshipsEO.status IN ('A', 'I')
1529: AND HzPuiRelationshipsEO.subject_id = subjectparty.party_id
1530: AND HzPuiRelationshipsEO.object_id = objectparty.party_id

Line 1527: AND HzPuiRelationshipsEO.object_table_name = 'HZ_PARTIES'

1523: fnd_lookup_values subjectpartytypelu,
1524: fnd_lookup_values objectpartytypelu,
1525: fnd_lookup_values relationshiprolelu
1526: WHERE HzPuiRelationshipsEO.subject_table_name = 'HZ_PARTIES'
1527: AND HzPuiRelationshipsEO.object_table_name = 'HZ_PARTIES'
1528: AND HzPuiRelationshipsEO.status IN ('A', 'I')
1529: AND HzPuiRelationshipsEO.subject_id = subjectparty.party_id
1530: AND HzPuiRelationshipsEO.object_id = objectparty.party_id
1531: AND HzPuiRelationshipsEO.relationship_type = reltype.relationship_type

Line 1743: subject_party_name hz_parties.party_name%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,
1747: object_party_number hz_parties.party_number%Type,

Line 1744: subject_party_number hz_parties.party_number%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,
1747: object_party_number hz_parties.party_number%Type,
1748: object_party_known_as hz_parties.known_as%Type,

Line 1745: subject_party_known_as hz_parties.known_as%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,
1747: object_party_number hz_parties.party_number%Type,
1748: object_party_known_as hz_parties.known_as%Type,
1749: relationship_type_id hz_relationship_types.relationship_type_id%Type,

Line 1746: object_party_name hz_parties.party_name%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,
1747: object_party_number hz_parties.party_number%Type,
1748: object_party_known_as hz_parties.known_as%Type,
1749: relationship_type_id hz_relationship_types.relationship_type_id%Type,
1750: relationship_role hz_relationship_types.role%Type,

Line 1747: object_party_number hz_parties.party_number%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,
1747: object_party_number hz_parties.party_number%Type,
1748: object_party_known_as hz_parties.known_as%Type,
1749: relationship_type_id hz_relationship_types.relationship_type_id%Type,
1750: relationship_role hz_relationship_types.role%Type,
1751: subject_type_meaning fnd_lookup_values.meaning%Type,

Line 1748: object_party_known_as hz_parties.known_as%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,
1747: object_party_number hz_parties.party_number%Type,
1748: object_party_known_as hz_parties.known_as%Type,
1749: relationship_type_id hz_relationship_types.relationship_type_id%Type,
1750: relationship_role hz_relationship_types.role%Type,
1751: subject_type_meaning fnd_lookup_values.meaning%Type,
1752: object_type_meaning fnd_lookup_values.meaning%Type,

Line 1898: OWNER_TABLE_NAME = 'HZ_PARTIES' AND OWNER_TABLE_ID = l_site_party_id

1894: FROM
1895: HZ_CONTACT_POINTS HzPuiContactPointPhoneEO
1896: ,FND_TIMEZONES_VL Ftv
1897: WHERE (CONTACT_POINT_TYPE = 'PHONE' and
1898: OWNER_TABLE_NAME = 'HZ_PARTIES' AND OWNER_TABLE_ID = l_site_party_id
1899: AND Ftv.ENABLED_FLAG(+) = 'Y'
1900: AND HzPuiContactPointPhoneEO.TIMEZONE_ID = Ftv.UPGRADE_TZ_ID(+)
1901: );
1902:

Line 1965: and (HzPuiContactPointEmailEO.OWNER_TABLE_NAME = 'HZ_PARTIES'

1961: and al.view_application_id(+) = 222
1962: and al.language(+) = userenv('LANG')
1963: and al.lookup_type(+) = 'CONTACT_POINT_PURPOSE'
1964: and HzPuiContactPointEmailEO.CONTACT_POINT_PURPOSE = al.LOOKUP_CODE(+)
1965: and (HzPuiContactPointEmailEO.OWNER_TABLE_NAME = 'HZ_PARTIES'
1966: AND HzPuiContactPointEmailEO.OWNER_TABLE_ID = l_site_party_id)
1967: ORDER BY HzPuiContactPointEmailEO.PRIMARY_FLAG DESC, USAGE NULLS LAST, HzPuiContactPointEmailEO.PRIMARY_BY_PURPOSE DESC;
1968:
1969: x_site_email_tab := rrs_site_email_tab();

Line 2019: and (HzPuiContactPointUrlEO.OWNER_TABLE_NAME = 'HZ_PARTIES'

2015: and al.view_application_id(+) = 222
2016: and al.language(+) = userenv('LANG')
2017: and al.lookup_type(+) = 'CONTACT_POINT_PURPOSE_WEB'
2018: and HzPuiContactPointUrlEO.CONTACT_POINT_PURPOSE = al.LOOKUP_CODE(+)
2019: and (HzPuiContactPointUrlEO.OWNER_TABLE_NAME = 'HZ_PARTIES'
2020: AND HzPuiContactPointUrlEO.OWNER_TABLE_ID = l_site_party_id)
2021: ORDER BY HzPuiContactPointUrlEO.PRIMARY_FLAG DESC, USAGE NULLS LAST, HzPuiContactPointUrlEO.PRIMARY_BY_PURPOSE DESC;
2022:
2023: x_site_url_tab := rrs_site_url_tab();

Line 2079: hz_parties subjectparty,

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,
2082: fnd_lookup_values objectpartytypelu,
2083: fnd_lookup_values relationshiprolelu

Line 2080: hz_parties objectparty,

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,
2082: fnd_lookup_values objectpartytypelu,
2083: fnd_lookup_values relationshiprolelu
2084: WHERE HzPuiRelationshipsEO.subject_table_name = 'HZ_PARTIES'

Line 2084: WHERE HzPuiRelationshipsEO.subject_table_name = 'HZ_PARTIES'

2080: hz_parties objectparty,
2081: fnd_lookup_values subjectpartytypelu,
2082: fnd_lookup_values objectpartytypelu,
2083: fnd_lookup_values relationshiprolelu
2084: WHERE HzPuiRelationshipsEO.subject_table_name = 'HZ_PARTIES'
2085: AND HzPuiRelationshipsEO.object_table_name = 'HZ_PARTIES'
2086: AND HzPuiRelationshipsEO.status IN ('A', 'I')
2087: AND HzPuiRelationshipsEO.subject_id = subjectparty.party_id
2088: AND HzPuiRelationshipsEO.object_id = objectparty.party_id

Line 2085: AND HzPuiRelationshipsEO.object_table_name = 'HZ_PARTIES'

2081: fnd_lookup_values subjectpartytypelu,
2082: fnd_lookup_values objectpartytypelu,
2083: fnd_lookup_values relationshiprolelu
2084: WHERE HzPuiRelationshipsEO.subject_table_name = 'HZ_PARTIES'
2085: AND HzPuiRelationshipsEO.object_table_name = 'HZ_PARTIES'
2086: AND HzPuiRelationshipsEO.status IN ('A', 'I')
2087: AND HzPuiRelationshipsEO.subject_id = subjectparty.party_id
2088: AND HzPuiRelationshipsEO.object_id = objectparty.party_id
2089: AND HzPuiRelationshipsEO.relationship_type = reltype.relationship_type