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 350: GL_SEG_VAL_HIERARCHIES GLSVH

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

Line 659: FROM GL_SEG_VAL_HIERARCHIES GLSVH,

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

Line 720: FROM GL_SEG_VAL_HIERARCHIES GLSVH,

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