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

Line 74: GL_LEDGERS LED

70: IS
71: SELECT DISTINCT JCAB.ACCOUNT_SEGMENT --Account Number
72: FROM JA_CN_ACCOUNT_BALANCES JCAB,
73: GL_PERIODS GP,
74: GL_LEDGERS LED
75: WHERE JCAB.LEDGER_ID = pn_ledger_id --parameter: pn_ledger_id
76: AND JCAB.LEGAL_ENTITY_ID = pn_legal_entity_id --parameter: pn_legal_entity_id
77: AND JCAB.PERIOD_NAME = GP.PERIOD_NAME
78: AND LED.LEDGER_ID = JCAB.LEDGER_ID

Line 137: GL_LEDGERS LED

133: ,MAX(JCAB.SEGMENT29) SEGMENT29
134: ,MAX(JCAB.SEGMENT30) SEGMENT30
135: FROM JA_CN_ACCOUNT_BALANCES JCAB,
136: GL_PERIODS GP,
137: GL_LEDGERS LED
138: WHERE JCAB.LEDGER_ID = pn_ledger_id --parameter: pn_ledger_id
139: AND JCAB.LEGAL_ENTITY_ID = pn_legal_entity_id --parameter: pn_legal_entity_id
140: AND JCAB.PERIOD_NAME = GP.PERIOD_NAME
141: AND LED.LEDGER_ID = JCAB.LEDGER_ID

Line 203: GL_LEDGERS LED,

199: FIFS.SEGMENT_NAME AS CORR_RECORD, --Corresponding Record
200: FFVS.DESCRIPTION AS SUB_ITEM_DESC --Subsidiary Item Description
201: FROM FND_ID_FLEX_SEGMENTS FIFS,
202: FND_SEGMENT_ATTRIBUTE_VALUES FSAV,
203: GL_LEDGERS LED,
204: FND_FLEX_VALUE_SETS FFVS,
205: JA_CN_SUB_ACC_MAPPING SAM
206: WHERE FIFS.ID_FLEX_NUM = FSAV.ID_FLEX_NUM
207: AND FIFS.APPLICATION_COLUMN_NAME =