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.GL_FLATTEN_SEG_VAL_HIERARCHIES dependencies on FND_FLEX_VALUE_NORM_HIERARCHY

Line 190: FROM FND_FLEX_VALUE_NORM_HIERARCHY ffvnh

186: AND fifs.id_flex_code = 'GL#'
187: AND fifs.flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID)
188: OR EXISTS
189: (SELECT 1
190: FROM FND_FLEX_VALUE_NORM_HIERARCHY ffvnh
191: WHERE ffvnh.flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
192: AND ROWNUM = 1);
193:
194: EXCEPTION

Line 558: FROM FND_FLEX_VALUE_NORM_HIERARCHY ffvnh

554: WHERE glsvnh.flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
555: AND
556: (NOT EXISTS
557: (SELECT 1
558: FROM FND_FLEX_VALUE_NORM_HIERARCHY ffvnh
559: WHERE ffvnh.flex_value_set_id =
560: glsvnh.flex_value_set_id
561: AND ffvnh.range_attribute =
562: DECODE(glsvnh.summary_flag,'Y','P','N','C')

Line 637: FROM FND_FLEX_VALUE_NORM_HIERARCHY ffvnh,

633: SYSDATE,
634: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
635: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,
636: SYSDATE
637: FROM FND_FLEX_VALUE_NORM_HIERARCHY ffvnh,
638: GL_SEG_VAL_HIERARCHIES glsvh
639: WHERE ffvnh.flex_value_set_id =
640: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
641: AND glsvh.flex_value_set_id = ffvnh.flex_value_set_id