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 437: AND FIFS.ID_FLEX_CODE='GL#' -- using standard flex code, without it the output will be reduplicate

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

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

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