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_AB_EXP_PKG dependencies on JA_CN_LEDGER_LE_BSV_GT

Line 173: FROM ja_cn_ledger_le_bsv_gt

169: AND account_segment = :3
170: AND ledger_id = :4
171: AND company_segment IN
172: (SELECT bal_seg_value
173: FROM ja_cn_ledger_le_bsv_gt
174: WHERE legal_entity_id = :5)
175: GROUP BY account_segment,@CURRENCY_CLAUSE2 period_mon,account_type,PERIOD_NAME @COLUMN_CLAUSE) ' ||
176: prefix_a ||
177: ' LEFT JOIN ja_cn_subsidiary_gt s ON ' ||

Line 229: FROM ja_cn_ledger_le_bsv_gt--ja_cn_legal_companies_all

225: SELECT DISTINCT account_segment
226: FROM ja_cn_account_balances_v
227: WHERE company_segment IN
228: (SELECT bal_seg_value--segment_value
229: FROM ja_cn_ledger_le_bsv_gt--ja_cn_legal_companies_all
230: WHERE legal_entity_id = p_legal_entity
231: AND chart_of_accounts_id = p_coa_id)
232: AND period_name IN
233: (SELECT period_name