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_LEDGER_SEG_VALS dependencies on GL_SEG_VAL_HIERARCHIES

Line 347: GL_SEG_VAL_HIERARCHIES GLSVH

343: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID,
344: GLLNSV.START_DATE, GLLNSV.END_DATE
345: FROM GL_LEDGERS GLL,
346: GL_LEDGER_NORM_SEG_VALS GLLNSV,
347: GL_SEG_VAL_HIERARCHIES GLSVH
348: WHERE GLL.CHART_OF_ACCOUNTS_ID =
349: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
350: AND GLLNSV.LEDGER_ID = GLL.LEDGER_ID
351: AND GLLNSV.STATUS_CODE = 'I'

Line 656: FROM GL_SEG_VAL_HIERARCHIES GLSVH,

652: WHERE (GLLSV.LEDGER_ID, GLLSV.PARENT_RECORD_ID,
653: GLLSV.SEGMENT_VALUE) IN
654: (SELECT GLLNSV.LEDGER_ID, GLLNSV.RECORD_ID,
655: GLSVH.CHILD_FLEX_VALUE
656: FROM GL_SEG_VAL_HIERARCHIES GLSVH,
657: GL_LEDGER_NORM_SEG_VALS GLLNSV,
658: GL_LEDGERS GLL
659: WHERE GLSVH.FLEX_VALUE_SET_ID =
660: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID

Line 717: FROM GL_SEG_VAL_HIERARCHIES GLSVH,

713: SYSDATE,
714: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
715: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID,
716: GLLNSV.START_DATE, GLLNSV.END_DATE
717: FROM GL_SEG_VAL_HIERARCHIES GLSVH,
718: GL_LEDGER_NORM_SEG_VALS GLLNSV,
719: GL_LEDGERS GLL
720: WHERE GLSVH.FLEX_VALUE_SET_ID =
721: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID