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_COA_EXPORT_PKG dependencies on GL_LEDGERS

Line 111: --||' ,GL_LEDGERS LEDGER '

107: ||' FROM FND_ID_FLEX_SEGMENTS FIFS '
108: ||' ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV '
109: ||' ,FND_FLEX_VALUE_SETS FFVS '
110: ||' ,FND_FLEX_VALUES FFV '
111: --||' ,GL_LEDGERS LEDGER '
112: ||' WHERE '
113: --Get all correct row of FFV
114: --||' LEDGER.ledger_id = ' || l_LEDGER_id
115: ||' FIFS.id_flex_num = '|| l_coa_id ||' '

Line 143: --||' ,GL_LEDGERS LEDGER '

139: ||' FROM FND_ID_FLEX_SEGMENTS FIFS '
140: ||' ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV '
141: ||' ,FND_FLEX_VALUE_SETS FFVS '
142: ||' ,FND_FLEX_VALUES FFV '
143: --||' ,GL_LEDGERS LEDGER '
144: ||' WHERE '
145: --Get all correct row of FFV
146: --||' LEDGER.ledger_id = ' || l_LEDGER_id
147: ||' FIFS.id_flex_num = '|| l_coa_id ||' '

Line 316: ,GL_LEDGERS ledger

312: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
313: ,FND_FLEX_VALUE_SETS FFVS
314: ,FND_FLEX_VALUES FFV
315: ,FND_FLEX_VALUES_TL FFVT
316: ,GL_LEDGERS ledger
317: WHERE --Get all correct row of FFV
318: ledger.ledger_id = l_ledger_id --using variable l_sob_id
319: AND ledger.chart_of_accounts_id = FIFS.id_flex_num
320: AND FIFS.id_flex_num = FSAV.id_flex_num

Line 586: FROM GL_LEDGERS LEDGER

582: BEGIN
583: SELECT DISTINCT
584: nvl(UOM.UNIT_OF_MEASURE, '') acc_uom
585: INTO l_na_mea
586: FROM GL_LEDGERS LEDGER
587: ,GL_STAT_ACCOUNT_UOM UOM
588: WHERE LEDGER.ledger_id = l_ledger_id --using variable l_sob_id
589: AND UOM.CHART_OF_ACCOUNTS_ID = LEDGER.CHART_OF_ACCOUNTS_ID
590: AND UOM.ACCOUNT_SEGMENT_VALUE = l_na_number --using variable l_na_number