APPS.RRS_HIERARCHY_INFO dependencies on RRS_LOOKUPS_V

Line 31: FROM RRS_SITE_GROUP_VERSIONS RSGV, RRS_SITE_GROUPS_B RSGB, RRS_SITE_GROUPS_TL RSGT, RRS_LOOKUPS_V LKUP

27: RSGT.DESCRIPTION,
28: RSGB.START_DATE,
29: RSGB.END_DATE)
30: INTO x_hier_header_rec
31: FROM RRS_SITE_GROUP_VERSIONS RSGV, RRS_SITE_GROUPS_B RSGB, RRS_SITE_GROUPS_TL RSGT, RRS_LOOKUPS_V LKUP
32: WHERE RSGT.LANGUAGE = userenv('LANG')
33: AND RSGV.SITE_GROUP_VERSION_ID = p_hier_version_id
34: AND RSGB.SITE_GROUP_ID = RSGV.SITE_GROUP_ID
35: AND RSGT.SITE_GROUP_ID = RSGB.SITE_GROUP_ID

Line 253: FROM RRS_SITE_GROUP_NODES_B RSGNB, RRS_LOOKUPS_V LKUP

249: (SELECT LKUP.MEANING
250: FROM RRS_SITE_USES RSU, AR_LOOKUPS LKUP
251: WHERE RSU.SITE_ID = SiteGroupMembers.PARENT_MEMBER_ID AND RSU.IS_PRIMARY_FLAG = 'Y' AND LKUP.LOOKUP_TYPE = 'PARTY_SITE_USE_CODE' AND RSU.SITE_USE_TYPE_CODE = LKUP.LOOKUP_CODE),
252: (SELECT LKUP.MEANING
253: FROM RRS_SITE_GROUP_NODES_B RSGNB, RRS_LOOKUPS_V LKUP
254: WHERE RSGNB.SITE_GROUP_NODE_ID = SiteGroupMembers.PARENT_MEMBER_ID AND LKUP.LOOKUP_TYPE = 'RRS_NODE_PURPOSE' AND RSGNB.NODE_PURPOSE_CODE = LKUP.LOOKUP_CODE))),
255: DECODE(SiteGroupMembers.PARENT_MEMBER_ID, -1, 'Y', 'N'),
256: DECODE(SiteGroupNodes1.SITE_GROUP_NODE_ID, NULL, Sites1.SITE_ID,
257: SiteGroupNodes1.SITE_GROUP_NODE_ID),

Line 270: FROM RRS_SITE_GROUP_NODES_B RSGNB, RRS_LOOKUPS_V LKUP

266: (SELECT LKUP.MEANING
267: FROM RRS_SITE_USES, AR_LOOKUPS LKUP
268: WHERE RRS_SITE_USES.SITE_ID = SiteGroupMembers.CHILD_MEMBER_ID AND RRS_SITE_USES.IS_PRIMARY_FLAG = 'Y' AND LKUP.LOOKUP_TYPE = 'PARTY_SITE_USE_CODE' AND RRS_SITE_USES.SITE_USE_TYPE_CODE = LKUP.LOOKUP_CODE),
269: (SELECT LKUP.MEANING
270: FROM RRS_SITE_GROUP_NODES_B RSGNB, RRS_LOOKUPS_V LKUP
271: WHERE RSGNB.SITE_GROUP_NODE_ID = SiteGroupMembers.CHILD_MEMBER_ID AND RSGNB.NODE_PURPOSE_CODE = LKUP.LOOKUP_CODE AND LKUP.LOOKUP_TYPE = 'RRS_NODE_PURPOSE')),
272: DECODE(SiteGroupNodes1.SITE_GROUP_NODE_ID, NULL, Sites1.DESCRIPTION, SiteGroupNodes1.DESCRIPTION),
273: DECODE(SiteGroupNodes1.SITE_GROUP_NODE_ID, NULL, Sites1.SITE_STATUS_CODE, NULL),
274: DECODE(SiteGroupNodes1.SITE_GROUP_NODE_ID, NULL, (SELECT MEANING FROM RRS_LOOKUPS_V WHERE LOOKUP_TYPE = 'RRS_SITE_STATUS' AND LOOKUP_CODE = Sites1.SITE_STATUS_CODE), NULL),

Line 274: DECODE(SiteGroupNodes1.SITE_GROUP_NODE_ID, NULL, (SELECT MEANING FROM RRS_LOOKUPS_V WHERE LOOKUP_TYPE = 'RRS_SITE_STATUS' AND LOOKUP_CODE = Sites1.SITE_STATUS_CODE), NULL),

270: FROM RRS_SITE_GROUP_NODES_B RSGNB, RRS_LOOKUPS_V LKUP
271: WHERE RSGNB.SITE_GROUP_NODE_ID = SiteGroupMembers.CHILD_MEMBER_ID AND RSGNB.NODE_PURPOSE_CODE = LKUP.LOOKUP_CODE AND LKUP.LOOKUP_TYPE = 'RRS_NODE_PURPOSE')),
272: DECODE(SiteGroupNodes1.SITE_GROUP_NODE_ID, NULL, Sites1.DESCRIPTION, SiteGroupNodes1.DESCRIPTION),
273: DECODE(SiteGroupNodes1.SITE_GROUP_NODE_ID, NULL, Sites1.SITE_STATUS_CODE, NULL),
274: DECODE(SiteGroupNodes1.SITE_GROUP_NODE_ID, NULL, (SELECT MEANING FROM RRS_LOOKUPS_V WHERE LOOKUP_TYPE = 'RRS_SITE_STATUS' AND LOOKUP_CODE = Sites1.SITE_STATUS_CODE), NULL),
275: SiteGroupMembers.SEQUENCE_NUMBER,
276: LEVEL
277: )
278: BULK COLLECT

Line 519: l_rrs_entity_name rrs_lookups_v.meaning%Type;

515: ,x_msg_data OUT NOCOPY varchar2
516: ) is
517:
518: l_api_name CONSTANT VARCHAR2(30) := 'Get_Hierarchy_User_Attributes';
519: l_rrs_entity_name rrs_lookups_v.meaning%Type;
520: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
521: l_object_name VARCHAR2(30);
522: l_attr_group_type VARCHAR2(30);
523: l_data_level_name VARCHAR2(30);

Line 565: FROM RRS_LOOKUPS_V

561: END;
562:
563: SELECT MEANING
564: INTO l_rrs_entity_name
565: FROM RRS_LOOKUPS_V
566: WHERE LOOKUP_TYPE = 'RRS_ENTITY'
567: AND LOOKUP_CODE = 'RRS_HIERARCHY';
568:
569: /* get attribute groups for the hierarchy and its classification code*/