APPS.RRS_SITE_INFO dependencies on RRS_SITE_GROUPS_VL

Line 1411: FROM RRS_SITE_GROUP_MEMBERS SiteGroupMemberEO ,RRS_SITE_GROUPS_VL SiteGroup

1407:
1408: SELECT SiteGroup.NAME
1409: BULK COLLECT
1410: INTO l_cluster_name
1411: FROM RRS_SITE_GROUP_MEMBERS SiteGroupMemberEO ,RRS_SITE_GROUPS_VL SiteGroup
1412: WHERE SiteGroupMemberEO.SITE_GROUP_ID = SiteGroup.SITE_GROUP_ID
1413: AND SiteGroup.SITE_GROUP_TYPE_CODE = 'C'
1414: AND SiteGroupMemberEO.SITE_GROUP_VERSION_ID =
1415: (SELECT MAX(SITE_GROUP_VERSION_ID)

Line 1439: ,RRS_SITE_GROUPS_VL SiteGroup

1435: SiteGroupNode.NAME SiteGroupNodeName
1436: BULK COLLECT
1437: INTO l_hierarchy_details
1438: FROM RRS_SITE_GROUP_MEMBERS SiteGroupMemberEO
1439: ,RRS_SITE_GROUPS_VL SiteGroup
1440: ,RRS_SITE_GROUP_NODES_VL SiteGroupNode
1441: WHERE SiteGroupMemberEO.SITE_GROUP_ID = SiteGroup.SITE_GROUP_ID
1442: AND SiteGroup.SITE_GROUP_TYPE_CODE = 'H'
1443: AND SiteGroupNode.site_group_node_id = SiteGroupMemberEO.PARENT_MEMBER_ID

Line 1465: ,RRS_SITE_GROUPS_VL SiteGroup

1461: (SELECT SiteGroup.NAME Hierarchy_name,
1462: SiteGroupNode.NAME SiteGroupNodeName,
1463: NULL SiteName
1464: FROM RRS_SITE_GROUP_MEMBERS SiteGroupMemberEO
1465: ,RRS_SITE_GROUPS_VL SiteGroup
1466: ,RRS_SITE_GROUP_NODES_VL SiteGroupNode
1467: WHERE SiteGroupMemberEO.SITE_GROUP_ID = SiteGroup.SITE_GROUP_ID
1468: AND SiteGroup.SITE_GROUP_TYPE_CODE = 'H'
1469: AND SiteGroupNode.site_group_node_id = SiteGroupMemberEO.PARENT_MEMBER_ID

Line 1481: ,RRS_SITE_GROUPS_VL SiteGroup

1477: SiteGroup.NAME Hierarchy_name,
1478: NULL SiteGroupNodeName,
1479: SITE.NAME SiteName
1480: FROM RRS_SITE_GROUP_MEMBERS SiteGroupMemberEO
1481: ,RRS_SITE_GROUPS_VL SiteGroup
1482: ,RRS_SITES_VL SITE
1483: WHERE SiteGroupMemberEO.SITE_GROUP_ID = SiteGroup.SITE_GROUP_ID
1484: AND SiteGroup.SITE_GROUP_TYPE_CODE = 'H'
1485: AND SITE.SITE_ID =SiteGroupMemberEO.PARENT_MEMBER_ID