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 FND_LOOKUP_VALUES

Line 1313: relationship_role_meaning fnd_lookup_values.description%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;
1316: l_relationship_details local_rrs_relationship_tab;
1317:

Line 1523: fnd_lookup_values subjectpartytypelu,

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'
1527: AND HzPuiRelationshipsEO.object_table_name = 'HZ_PARTIES'

Line 1524: fnd_lookup_values objectpartytypelu,

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'
1527: AND HzPuiRelationshipsEO.object_table_name = 'HZ_PARTIES'
1528: AND HzPuiRelationshipsEO.status IN ('A', 'I')

Line 1525: fnd_lookup_values relationshiprolelu

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'
1527: AND HzPuiRelationshipsEO.object_table_name = 'HZ_PARTIES'
1528: AND HzPuiRelationshipsEO.status IN ('A', 'I')
1529: AND HzPuiRelationshipsEO.subject_id = subjectparty.party_id

Line 1699: MEANING FND_LOOKUP_VALUES.MEANING%Type,

1695: EMAIL_FORMAT HZ_CONTACT_POINTS.EMAIL_FORMAT%Type,
1696: EMAIL_ADDRESS HZ_CONTACT_POINTS.EMAIL_ADDRESS%Type,
1697: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1698: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1699: MEANING FND_LOOKUP_VALUES.MEANING%Type,
1700: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,
1701: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type
1702: );
1703: TYPE local_rrs_site_email_tab IS TABLE OF local_rrs_site_email_rec;

Line 1722: MEANING FND_LOOKUP_VALUES.MEANING%Type,

1718: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1719: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1720: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,
1721: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type,
1722: MEANING FND_LOOKUP_VALUES.MEANING%Type,
1723: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type
1724: );
1725: TYPE local_rrs_site_url_tab IS TABLE OF local_rrs_site_url_rec;
1726: l_url_details local_rrs_site_url_tab;

Line 1751: subject_type_meaning fnd_lookup_values.meaning%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,
1753: relationship_role_meaning fnd_lookup_values.description%Type
1754: );
1755: TYPE local_rrs_site_person_tab IS TABLE OF local_rrs_site_person_rec;

Line 1752: object_type_meaning fnd_lookup_values.meaning%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,
1753: relationship_role_meaning fnd_lookup_values.description%Type
1754: );
1755: TYPE local_rrs_site_person_tab IS TABLE OF local_rrs_site_person_rec;
1756: l_person_details local_rrs_site_person_tab;

Line 1753: relationship_role_meaning fnd_lookup_values.description%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,
1753: relationship_role_meaning fnd_lookup_values.description%Type
1754: );
1755: TYPE local_rrs_site_person_tab IS TABLE OF local_rrs_site_person_rec;
1756: l_person_details local_rrs_site_person_tab;
1757:

Line 1958: fnd_lookup_values al

1954: HzPuiContactPointEmailEO.ACTUAL_CONTENT_SOURCE
1955: BULK COLLECT
1956: INTO l_email_details
1957: FROM HZ_CONTACT_POINTS HzPuiContactPointEmailEO,
1958: fnd_lookup_values al
1959: WHERE HzPuiContactPointEmailEO.CONTACT_POINT_TYPE ='EMAIL'
1960: and HzPuiContactPointEmailEO.STATUS = 'A'
1961: and al.view_application_id(+) = 222
1962: and al.language(+) = userenv('LANG')

Line 2012: fnd_lookup_values al

2008: HzPuiContactPointUrlEO.ATTRIBUTE_CATEGORY
2009: BULK COLLECT
2010: INTO l_url_details
2011: FROM HZ_CONTACT_POINTS HzPuiContactPointUrlEO,
2012: fnd_lookup_values al
2013: WHERE HzPuiContactPointUrlEO.CONTACT_POINT_TYPE ='WEB'
2014: and HzPuiContactPointUrlEO.STATUS = 'A'
2015: and al.view_application_id(+) = 222
2016: and al.language(+) = userenv('LANG')

Line 2081: fnd_lookup_values subjectpartytypelu,

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'
2085: AND HzPuiRelationshipsEO.object_table_name = 'HZ_PARTIES'

Line 2082: fnd_lookup_values objectpartytypelu,

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'
2085: AND HzPuiRelationshipsEO.object_table_name = 'HZ_PARTIES'
2086: AND HzPuiRelationshipsEO.status IN ('A', 'I')

Line 2083: fnd_lookup_values relationshiprolelu

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'
2085: AND HzPuiRelationshipsEO.object_table_name = 'HZ_PARTIES'
2086: AND HzPuiRelationshipsEO.status IN ('A', 'I')
2087: AND HzPuiRelationshipsEO.subject_id = subjectparty.party_id