APPS.RRS_HIERARCHY_INFO dependencies on RRS_SITE_GROUP_NODES_B

Line 204: FROM RRS_SITE_GROUP_NODES_B

200: WHERE SITE_IDENTIFICATION_NUMBER = p_parent_member_id_num;
201: ELSIF UPPER(p_parent_member_type) = 'NODE' THEN
202: SELECT SITE_GROUP_NODE_ID
203: INTO l_parent_id
204: FROM RRS_SITE_GROUP_NODES_B
205: WHERE NODE_IDENTIFICATION_NUMBER = p_parent_member_id_num;
206: END IF;
207:
208: IF l_parent_id IS NULL THEN

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 264: (SELECT NODE_PURPOSE_CODE FROM RRS_SITE_GROUP_NODES_B RSGNB WHERE RSGNB.SITE_GROUP_NODE_ID = SiteGroupMembers.CHILD_MEMBER_ID)),

260: DECODE(SiteGroupNodes1.NAME, NULL, Sites1.NAME, SiteGroupNodes1.NAME),
261: DECODE(SiteGroupNodes1.SITE_GROUP_NODE_ID, NULL, 'SITE', 'NODE'),
262: DECODE(SiteGroupNodes1.SITE_GROUP_NODE_ID, NULL,
263: (SELECT SITE_USE_TYPE_CODE FROM RRS_SITE_USES WHERE RRS_SITE_USES.SITE_ID = SiteGroupMembers.CHILD_MEMBER_ID AND RRS_SITE_USES.IS_PRIMARY_FLAG = 'Y'),
264: (SELECT NODE_PURPOSE_CODE FROM RRS_SITE_GROUP_NODES_B RSGNB WHERE RSGNB.SITE_GROUP_NODE_ID = SiteGroupMembers.CHILD_MEMBER_ID)),
265: DECODE(SiteGroupNodes1.SITE_GROUP_NODE_ID, NULL,
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),

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 366: FROM RRS_SITE_GROUP_NODES_B

362: WHERE SITE_IDENTIFICATION_NUMBER = p_parent_member_id_num;
363: ELSIF UPPER(p_parent_member_type) = 'NODE' THEN
364: SELECT SITE_GROUP_NODE_ID
365: INTO l_parent_id
366: FROM RRS_SITE_GROUP_NODES_B
367: WHERE NODE_IDENTIFICATION_NUMBER = p_parent_member_id_num;
368: END IF;
369:
370: IF l_parent_id IS NULL THEN

Line 452: FROM RRS_SITE_GROUP_NODES_B

448: WHERE SITE_IDENTIFICATION_NUMBER = p_parent_member_id_num;
449: ELSIF UPPER(p_parent_member_type) = 'NODE' THEN
450: SELECT SITE_GROUP_NODE_ID
451: INTO l_parent_id
452: FROM RRS_SITE_GROUP_NODES_B
453: WHERE NODE_IDENTIFICATION_NUMBER = p_parent_member_id_num;
454: END IF;
455:
456: IF l_parent_id IS NULL THEN