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_HIERARCHY_INFO dependencies on RRS_SITES_VL

Line 283: RRS_SITES_VL Sites1,

279: INTO x_hier_members_tab
280: FROM RRS_SITE_GROUP_MEMBERS SiteGroupMembers,
281: RRS_SITE_GROUP_NODES_VL SiteGroupNodes1,
282: RRS_SITE_GROUP_NODES_VL SiteGroupNodes2,
283: RRS_SITES_VL Sites1,
284: RRS_SITES_VL Sites2
285: WHERE SiteGroupMembers.CHILD_MEMBER_ID = SiteGroupNodes1.SITE_GROUP_NODE_ID(+)
286: AND SiteGroupMembers.CHILD_MEMBER_ID = Sites1.SITE_ID(+)
287: AND SiteGroupMembers.PARENT_MEMBER_ID = SiteGroupNodes2.SITE_GROUP_NODE_ID(+)

Line 284: RRS_SITES_VL Sites2

280: FROM RRS_SITE_GROUP_MEMBERS SiteGroupMembers,
281: RRS_SITE_GROUP_NODES_VL SiteGroupNodes1,
282: RRS_SITE_GROUP_NODES_VL SiteGroupNodes2,
283: RRS_SITES_VL Sites1,
284: RRS_SITES_VL Sites2
285: WHERE SiteGroupMembers.CHILD_MEMBER_ID = SiteGroupNodes1.SITE_GROUP_NODE_ID(+)
286: AND SiteGroupMembers.CHILD_MEMBER_ID = Sites1.SITE_ID(+)
287: AND SiteGroupMembers.PARENT_MEMBER_ID = SiteGroupNodes2.SITE_GROUP_NODE_ID(+)
288: AND SiteGroupMembers.PARENT_MEMBER_ID = Sites2.SITE_ID(+)