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 162: party_name hz_parties.party_name%Type,

158: location_id rrs_sites_b.location_id%TYPE,
159: site_party_id rrs_sites_b.site_party_id%TYPE,
160: party_site_id rrs_sites_b.party_site_id%TYPE,
161: le_party_site_id rrs_sites_b.le_party_id%TYPE,
162: party_name hz_parties.party_name%Type,
163: property_location_id rrs_sites_b.property_location_id%TYPE,
164: start_date rrs_sites_b.start_date%TYPE,
165: end_date rrs_sites_b.end_date%TYPE,
166: name rrs_sites_tl.name%TYPE

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

237: RST.NAME
238: Bulk Collect
239: INTO l_site_header_details
240: From RRS_SITES_B RSB, RRS_SITES_TL RST , rrs_lookups_v lkup1,rrs_lookups_v lkup2
241: ,rrs_lookups_v lkup3 , BOM_CALENDARS BC, HZ_PARTIES HP
242: WHERE RSB.SITE_IDENTIFICATION_NUMBER = p_site_id_num
243: and RSB.SITE_ID = RST.SITE_ID
244: and LKUP1.LOOKUP_TYPE = 'RRS_SITE_TYPE'
245: and LKUP1.LOOKUP_CODE = RSB.SITE_TYPE_CODE

Line 1291: subject_party_name hz_parties.party_name%Type,

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

Line 1292: object_party_name hz_parties.party_name%Type,

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

Line 1454: hz_parties subjectparty,

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,
1457: fnd_lookup_values objectpartytypelu,
1458: fnd_lookup_values relationshiprolelu

Line 1455: hz_parties objectparty,

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,
1457: fnd_lookup_values objectpartytypelu,
1458: fnd_lookup_values relationshiprolelu
1459: WHERE HzPuiRelationshipsEO.subject_table_name = 'HZ_PARTIES'

Line 1459: WHERE HzPuiRelationshipsEO.subject_table_name = 'HZ_PARTIES'

1455: hz_parties objectparty,
1456: fnd_lookup_values subjectpartytypelu,
1457: fnd_lookup_values objectpartytypelu,
1458: fnd_lookup_values relationshiprolelu
1459: WHERE HzPuiRelationshipsEO.subject_table_name = 'HZ_PARTIES'
1460: AND HzPuiRelationshipsEO.object_table_name = 'HZ_PARTIES'
1461: AND HzPuiRelationshipsEO.status IN ('A', 'I')
1462: AND HzPuiRelationshipsEO.subject_id = subjectparty.party_id
1463: AND HzPuiRelationshipsEO.object_id = objectparty.party_id

Line 1460: AND HzPuiRelationshipsEO.object_table_name = 'HZ_PARTIES'

1456: fnd_lookup_values subjectpartytypelu,
1457: fnd_lookup_values objectpartytypelu,
1458: fnd_lookup_values relationshiprolelu
1459: WHERE HzPuiRelationshipsEO.subject_table_name = 'HZ_PARTIES'
1460: AND HzPuiRelationshipsEO.object_table_name = 'HZ_PARTIES'
1461: AND HzPuiRelationshipsEO.status IN ('A', 'I')
1462: AND HzPuiRelationshipsEO.subject_id = subjectparty.party_id
1463: AND HzPuiRelationshipsEO.object_id = objectparty.party_id
1464: AND HzPuiRelationshipsEO.relationship_type = reltype.relationship_type

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

Line 1676: subject_party_number hz_parties.party_number%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,
1679: object_party_number hz_parties.party_number%Type,
1680: object_party_known_as hz_parties.known_as%Type,

Line 1677: subject_party_known_as hz_parties.known_as%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,
1679: object_party_number hz_parties.party_number%Type,
1680: object_party_known_as hz_parties.known_as%Type,
1681: relationship_type_id hz_relationship_types.relationship_type_id%Type,

Line 1678: object_party_name hz_parties.party_name%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,
1679: object_party_number hz_parties.party_number%Type,
1680: object_party_known_as hz_parties.known_as%Type,
1681: relationship_type_id hz_relationship_types.relationship_type_id%Type,
1682: relationship_role hz_relationship_types.role%Type,

Line 1679: object_party_number hz_parties.party_number%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,
1679: object_party_number hz_parties.party_number%Type,
1680: object_party_known_as hz_parties.known_as%Type,
1681: relationship_type_id hz_relationship_types.relationship_type_id%Type,
1682: relationship_role hz_relationship_types.role%Type,
1683: subject_type_meaning fnd_lookup_values.meaning%Type,

Line 1680: object_party_known_as hz_parties.known_as%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,
1679: object_party_number hz_parties.party_number%Type,
1680: object_party_known_as hz_parties.known_as%Type,
1681: relationship_type_id hz_relationship_types.relationship_type_id%Type,
1682: relationship_role hz_relationship_types.role%Type,
1683: subject_type_meaning fnd_lookup_values.meaning%Type,
1684: object_type_meaning fnd_lookup_values.meaning%Type,

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

1811: FROM
1812: HZ_CONTACT_POINTS HzPuiContactPointPhoneEO
1813: ,FND_TIMEZONES_VL Ftv
1814: WHERE (CONTACT_POINT_TYPE = 'PHONE' and
1815: OWNER_TABLE_NAME = 'HZ_PARTIES' AND OWNER_TABLE_ID = l_site_party_id
1816: AND Ftv.ENABLED_FLAG(+) = 'Y'
1817: AND HzPuiContactPointPhoneEO.TIMEZONE_ID = Ftv.UPGRADE_TZ_ID(+)
1818: );
1819:

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

1882: and al.view_application_id(+) = 222
1883: and al.language(+) = userenv('LANG')
1884: and al.lookup_type(+) = 'CONTACT_POINT_PURPOSE'
1885: and HzPuiContactPointEmailEO.CONTACT_POINT_PURPOSE = al.LOOKUP_CODE(+)
1886: and (HzPuiContactPointEmailEO.OWNER_TABLE_NAME = 'HZ_PARTIES'
1887: AND HzPuiContactPointEmailEO.OWNER_TABLE_ID = l_site_party_id)
1888: ORDER BY HzPuiContactPointEmailEO.PRIMARY_FLAG DESC, USAGE NULLS LAST, HzPuiContactPointEmailEO.PRIMARY_BY_PURPOSE DESC;
1889:
1890:

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

1938: and al.view_application_id(+) = 222
1939: and al.language(+) = userenv('LANG')
1940: and al.lookup_type(+) = 'CONTACT_POINT_PURPOSE_WEB'
1941: and HzPuiContactPointUrlEO.CONTACT_POINT_PURPOSE = al.LOOKUP_CODE(+)
1942: and (HzPuiContactPointUrlEO.OWNER_TABLE_NAME = 'HZ_PARTIES'
1943: AND HzPuiContactPointUrlEO.OWNER_TABLE_ID = l_site_party_id)
1944: ORDER BY HzPuiContactPointUrlEO.PRIMARY_FLAG DESC, USAGE NULLS LAST, HzPuiContactPointUrlEO.PRIMARY_BY_PURPOSE DESC;
1945:
1946:

Line 2004: hz_parties subjectparty,

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,
2007: fnd_lookup_values objectpartytypelu,
2008: fnd_lookup_values relationshiprolelu

Line 2005: hz_parties objectparty,

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,
2007: fnd_lookup_values objectpartytypelu,
2008: fnd_lookup_values relationshiprolelu
2009: WHERE HzPuiRelationshipsEO.subject_table_name = 'HZ_PARTIES'

Line 2009: WHERE HzPuiRelationshipsEO.subject_table_name = 'HZ_PARTIES'

2005: hz_parties objectparty,
2006: fnd_lookup_values subjectpartytypelu,
2007: fnd_lookup_values objectpartytypelu,
2008: fnd_lookup_values relationshiprolelu
2009: WHERE HzPuiRelationshipsEO.subject_table_name = 'HZ_PARTIES'
2010: AND HzPuiRelationshipsEO.object_table_name = 'HZ_PARTIES'
2011: AND HzPuiRelationshipsEO.status IN ('A', 'I')
2012: AND HzPuiRelationshipsEO.subject_id = subjectparty.party_id
2013: AND HzPuiRelationshipsEO.object_id = objectparty.party_id

Line 2010: AND HzPuiRelationshipsEO.object_table_name = 'HZ_PARTIES'

2006: fnd_lookup_values subjectpartytypelu,
2007: fnd_lookup_values objectpartytypelu,
2008: fnd_lookup_values relationshiprolelu
2009: WHERE HzPuiRelationshipsEO.subject_table_name = 'HZ_PARTIES'
2010: AND HzPuiRelationshipsEO.object_table_name = 'HZ_PARTIES'
2011: AND HzPuiRelationshipsEO.status IN ('A', 'I')
2012: AND HzPuiRelationshipsEO.subject_id = subjectparty.party_id
2013: AND HzPuiRelationshipsEO.object_id = objectparty.party_id
2014: AND HzPuiRelationshipsEO.relationship_type = reltype.relationship_type