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 RRS_SITE_GROUP_NODES_VL

Line 1440: ,RRS_SITE_GROUP_NODES_VL SiteGroupNode

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
1444: AND SiteGroupMemberEO.SITE_GROUP_VERSION_ID = (SELECT MAX(SITE_GROUP_VERSION_ID)

Line 1466: ,RRS_SITE_GROUP_NODES_VL SiteGroupNode

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
1470: AND SiteGroupMemberEO.SITE_GROUP_VERSION_ID = (SELECT MAX(SITE_GROUP_VERSION_ID)