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

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

179: ||' FROM FND_ID_FLEX_SEGMENTS FIFS '
180: ||' ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV '
181: ||' ,FND_FLEX_VALUE_SETS FFVS '
182: ||' ,FND_FLEX_VALUES FFV '
183: --||' ,GL_LEDGERS LEDGER '
184: ||' WHERE '
185: --Get all correct row of FFV
186: --||' LEDGER.ledger_id = ' || l_LEDGER_id
187: ||' FIFS.id_flex_num = '|| l_coa_id ||' '

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

227: ||' FROM FND_ID_FLEX_SEGMENTS FIFS '
228: ||' ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV '
229: ||' ,FND_FLEX_VALUE_SETS FFVS '
230: ||' ,FND_FLEX_VALUES FFV '
231: --||' ,GL_LEDGERS LEDGER '
232: ||' WHERE '
233: --Get all correct row of FFV
234: --||' LEDGER.ledger_id = ' || l_LEDGER_id
235: ||' FIFS.id_flex_num = '|| l_coa_id ||' '

Line 567: ,GL_LEDGERS ledger

563: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
564: ,FND_FLEX_VALUE_SETS FFVS
565: ,FND_FLEX_VALUES FFV
566: ,FND_FLEX_VALUES_TL FFVT
567: ,GL_LEDGERS ledger
568: WHERE --Get all correct row of FFV
569: ledger.ledger_id = l_ledger_id --using variable l_sob_id
570: AND ledger.chart_of_accounts_id = FIFS.id_flex_num
571: AND FIFS.id_flex_num = FSAV.id_flex_num

Line 934: FROM GL_LEDGERS LEDGER

930: BEGIN
931: SELECT DISTINCT
932: nvl(UOM.UNIT_OF_MEASURE, '') acc_uom
933: INTO l_na_mea
934: FROM GL_LEDGERS LEDGER
935: ,GL_STAT_ACCOUNT_UOM UOM
936: WHERE LEDGER.ledger_id = l_ledger_id --using variable l_sob_id
937: AND UOM.CHART_OF_ACCOUNTS_ID = LEDGER.CHART_OF_ACCOUNTS_ID
938: AND UOM.ACCOUNT_SEGMENT_VALUE = l_na_number --using variable l_na_number

Line 1167: ,GL_LEDGERS LEDGER

1163: SELECT DISTINCT
1164: BAL.project_number pj_number
1165: ,nvl(FFVT.description, '') pj_name --name for project from COA
1166: FROM JA_CN_ACCOUNT_BALANCES BAL
1167: ,GL_LEDGERS LEDGER
1168: ,Ja_Cn_Sub_Acc_Sources_All SUBAS
1169: ,FND_ID_FLEX_SEGMENTS FIFS
1170: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
1171: ,FND_FLEX_VALUE_SETS FFVS

Line 1825: ,GL_LEDGERS LEDGER

1821: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
1822: ,FND_FLEX_VALUE_SETS FFVS
1823: ,FND_FLEX_VALUES_TL FFVT
1824: ,FND_FLEX_VALUES FFV
1825: ,GL_LEDGERS LEDGER
1826: WHERE BAL.Ledger_Id = l_ledger_id --using variable l_sob_id
1827: AND BAL.account_segment IS NOT NULL
1828: and BAL.cost_center IS NOT NULL
1829: --for name. OR: FFVT.flex_value_meaning = BAL.cost_center