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_B

Line 199: FROM RRS_SITES_B

195: BEGIN
196: IF UPPER(p_parent_member_type) = 'SITE' THEN
197: SELECT SITE_ID
198: INTO l_parent_id
199: FROM RRS_SITES_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

Line 361: FROM RRS_SITES_B

357: BEGIN
358: IF UPPER(p_parent_member_type) = 'SITE' THEN
359: SELECT SITE_ID
360: INTO l_parent_id
361: FROM RRS_SITES_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

Line 447: FROM RRS_SITES_B

443: BEGIN
444: IF UPPER(p_parent_member_type) = 'SITE' THEN
445: SELECT SITE_ID
446: INTO l_parent_id
447: FROM RRS_SITES_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