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.JA_CN_GL_INTER_VALID_PKG dependencies on STANDARD

Line 441: AND FIFS.ID_FLEX_CODE='GL#' -- using standard flex code, without it the output will be reduplicate

437: FROM GL_CODE_COMBINATIONS gcc
438: ,FND_ID_FLEX_SEGMENTS FIFS
439: WHERE gcc.code_combination_id = l_cc_id --using variable l_cc_id
440: AND FIFS.APPLICATION_ID=101
441: AND FIFS.ID_FLEX_CODE='GL#' -- using standard flex code, without it the output will be reduplicate
442: AND FIFS.ID_FLEX_NUM = gcc.chart_of_accounts_id
443: ORDER BY FIFS.SEGMENT_NUM
444: ;
445: EXCEPTION

Line 506: AND FIFS.ID_FLEX_CODE='GL#' -- using standard flex code, without it the output will be reduplicate

502: AND ledger.ledger_id = l_ledger_id --using variable l_ledger_id
503: AND FIFS.id_flex_num = gcc.chart_of_accounts_id
504: AND FIFS.id_flex_num = FSAV.id_flex_num
505: AND FIFS.application_id = 101
506: AND FIFS.ID_FLEX_CODE='GL#' -- using standard flex code, without it the output will be reduplicate
507: AND FIFS.APPLICATION_COLUMN_NAME = FSAV.APPLICATION_COLUMN_NAME
508: --AND FSAV.SEGMENT_ATTRIBUTE_TYPE = l_seg_type --Just not check the type!
509: AND FSAV.ATTRIBUTE_VALUE = 'Y'
510: AND FIFS.application_id = FSAV.application_id