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_CRUD_PKG dependencies on RRS_LOOKUPS_V

Line 61: FROM RRS_LOOKUPS_V

57: IF p_purpose_code IS NOT NULL THEN
58: BEGIN
59: SELECT MEANING
60: INTO v_meaning
61: FROM RRS_LOOKUPS_V
62: WHERE LOOKUP_CODE = p_purpose_code
63: AND LOOKUP_TYPE = 'RRS_HIERARCHY_PURPOSE'
64: AND nvl(enabled_flag, 'Y') = 'Y'
65: AND nvl(start_date_active, sysdate) <= sysdate

Line 259: FROM RRS_LOOKUPS_V RLV

255: IF p_purpose_code IS NOT NULL THEN
256: BEGIN
257: SELECT MEANING
258: INTO v_meaning
259: FROM RRS_LOOKUPS_V RLV
260: WHERE RLV.LOOKUP_CODE = p_purpose_code
261: AND RLV.LOOKUP_TYPE = 'RRS_NODE_PURPOSE'
262: AND nvl(enabled_flag, 'Y') = 'Y'
263: AND nvl(start_date_active, sysdate) <= sysdate

Line 367: FROM RRS_LOOKUPS_V RLV

363: IF p_purpose_code IS NOT NULL THEN
364: BEGIN
365: SELECT MEANING
366: INTO v_meaning
367: FROM RRS_LOOKUPS_V RLV
368: WHERE RLV.LOOKUP_CODE = p_purpose_code
369: AND RLV.LOOKUP_TYPE = 'RRS_NODE_PURPOSE'
370: AND nvl(enabled_flag, 'Y') = 'Y'
371: AND nvl(start_date_active, sysdate) <= sysdate

Line 527: FROM RRS_LOOKUPS_V RLV

523: IF p_hier_purpose_code IS NOT NULL THEN
524: BEGIN
525: SELECT MEANING
526: INTO v_meaning
527: FROM RRS_LOOKUPS_V RLV
528: WHERE RLV.LOOKUP_CODE = p_hier_purpose_code
529: AND RLV.LOOKUP_TYPE = 'RRS_HIERARCHY_PURPOSE'
530: AND nvl(enabled_flag, 'Y') = 'Y'
531: AND nvl(start_date_active, sysdate) <= sysdate