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_VERSIONS

Line 1416: FROM RRS_SITE_GROUP_VERSIONS curVer

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)
1416: FROM RRS_SITE_GROUP_VERSIONS curVer
1417: WHERE curVer.SITE_GROUP_ID = SiteGroupMemberEO.SITE_GROUP_ID)
1418: AND SiteGroupMemberEO.CHILD_MEMBER_ID = l_site_id
1419: AND DELETED_FLAG = 'N';
1420:

Line 1445: FROM RRS_SITE_GROUP_VERSIONS curVer WHERE curVer.SITE_GROUP_ID =

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)
1445: FROM RRS_SITE_GROUP_VERSIONS curVer WHERE curVer.SITE_GROUP_ID =
1446: SiteGroupMemberEO.SITE_GROUP_ID) AND SiteGroupMemberEO.CHILD_MEMBER_ID = l_site_id
1447: AND DELETED_FLAG = 'N';
1448: */
1449:

Line 1471: FROM RRS_SITE_GROUP_VERSIONS curVer WHERE curVer.SITE_GROUP_ID =

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)
1471: FROM RRS_SITE_GROUP_VERSIONS curVer WHERE curVer.SITE_GROUP_ID =
1472: SiteGroupMemberEO.SITE_GROUP_ID) AND SiteGroupMemberEO.CHILD_MEMBER_ID =
1473: l_site_id
1474: AND SiteGroupMemberEO.DELETED_FLAG = 'N'
1475: UNION ALL

Line 1487: FROM RRS_SITE_GROUP_VERSIONS curVer WHERE curVer.SITE_GROUP_ID =

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
1486: AND SiteGroupMemberEO.SITE_GROUP_VERSION_ID = (SELECT MAX(SITE_GROUP_VERSION_ID)
1487: FROM RRS_SITE_GROUP_VERSIONS curVer WHERE curVer.SITE_GROUP_ID =
1488: SiteGroupMemberEO.SITE_GROUP_ID)
1489: AND SiteGroupMemberEO.CHILD_MEMBER_ID = l_site_id
1490: AND SiteGroupMemberEO.deleted_flag='N');
1491: