DBA Data[Home] [Help]

APPS.RRS_SITE_INFO dependencies on FND_LOOKUP_VALUES

Line 1294: relationship_role_meaning fnd_lookup_values.description%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;
1297: l_relationship_details local_rrs_relationship_tab;
1298:

Line 1456: fnd_lookup_values subjectpartytypelu,

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

Line 1457: fnd_lookup_values objectpartytypelu,

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

Line 1458: fnd_lookup_values relationshiprolelu

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

Line 1631: MEANING FND_LOOKUP_VALUES.MEANING%Type,

1627: EMAIL_FORMAT HZ_CONTACT_POINTS.EMAIL_FORMAT%Type,
1628: EMAIL_ADDRESS HZ_CONTACT_POINTS.EMAIL_ADDRESS%Type,
1629: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1630: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1631: MEANING FND_LOOKUP_VALUES.MEANING%Type,
1632: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,
1633: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type
1634: );
1635: TYPE local_rrs_site_email_tab IS TABLE OF local_rrs_site_email_rec;

Line 1654: MEANING FND_LOOKUP_VALUES.MEANING%Type,

1650: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1651: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1652: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,
1653: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type,
1654: MEANING FND_LOOKUP_VALUES.MEANING%Type,
1655: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type
1656: );
1657: TYPE local_rrs_site_url_tab IS TABLE OF local_rrs_site_url_rec;
1658: l_url_details local_rrs_site_url_tab;

Line 1683: subject_type_meaning fnd_lookup_values.meaning%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,
1685: relationship_role_meaning fnd_lookup_values.description%Type
1686: );
1687: TYPE local_rrs_site_person_tab IS TABLE OF local_rrs_site_person_rec;

Line 1684: object_type_meaning fnd_lookup_values.meaning%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,
1685: relationship_role_meaning fnd_lookup_values.description%Type
1686: );
1687: TYPE local_rrs_site_person_tab IS TABLE OF local_rrs_site_person_rec;
1688: l_person_details local_rrs_site_person_tab;

Line 1685: relationship_role_meaning fnd_lookup_values.description%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,
1685: relationship_role_meaning fnd_lookup_values.description%Type
1686: );
1687: TYPE local_rrs_site_person_tab IS TABLE OF local_rrs_site_person_rec;
1688: l_person_details local_rrs_site_person_tab;
1689:

Line 1879: fnd_lookup_values al

1875: HzPuiContactPointEmailEO.ACTUAL_CONTENT_SOURCE
1876: BULK COLLECT
1877: INTO l_email_details
1878: FROM HZ_CONTACT_POINTS HzPuiContactPointEmailEO,
1879: fnd_lookup_values al
1880: WHERE HzPuiContactPointEmailEO.CONTACT_POINT_TYPE ='EMAIL'
1881: and HzPuiContactPointEmailEO.STATUS = 'A'
1882: and al.view_application_id(+) = 222
1883: and al.language(+) = userenv('LANG')

Line 1935: fnd_lookup_values al

1931: HzPuiContactPointUrlEO.ATTRIBUTE_CATEGORY
1932: BULK COLLECT
1933: INTO l_url_details
1934: FROM HZ_CONTACT_POINTS HzPuiContactPointUrlEO,
1935: fnd_lookup_values al
1936: WHERE HzPuiContactPointUrlEO.CONTACT_POINT_TYPE ='WEB'
1937: and HzPuiContactPointUrlEO.STATUS = 'A'
1938: and al.view_application_id(+) = 222
1939: and al.language(+) = userenv('LANG')

Line 2006: fnd_lookup_values subjectpartytypelu,

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

Line 2007: fnd_lookup_values objectpartytypelu,

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

Line 2008: fnd_lookup_values relationshiprolelu

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