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_FA_ACUI_EXPORT_PKG dependencies on JA_CN_CFS_DATA_CLT_PKG

Line 297: WHERE ja_cn_cfs_data_clt_pkg.get_balancing_segment(fdh.code_combination_id) =

293: SYSDATE) OR fdh.date_ineffective IS NULL)
294: AND EXISTS
295: (SELECT jclllbg.bal_seg_value
296: FROM ja_cn_ledger_le_bsv_gt jclllbg
297: WHERE ja_cn_cfs_data_clt_pkg.get_balancing_segment(fdh.code_combination_id) =
298: jclllbg.bal_seg_value
299: AND jclllbg.Ledger_Id = pn_ledger_id
300: AND jclllbg.Legal_Entity_Id = pn_legal_entity_id)
301: -- Check the asset type

Line 359: WHERE ja_cn_cfs_data_clt_pkg.get_balancing_segment(fdh.code_combination_id) =

355: AND fdh.assigned_to IS NOT NULL
356: AND EXISTS
357: (SELECT jclllbg.bal_seg_value
358: FROM ja_cn_ledger_le_bsv_gt jclllbg
359: WHERE ja_cn_cfs_data_clt_pkg.get_balancing_segment(fdh.code_combination_id) =
360: jclllbg.bal_seg_value
361: AND jclllbg.Ledger_Id = pn_ledger_id
362: AND jclllbg.Legal_Entity_Id = pn_legal_entity_id)
363: AND ppf.business_group_id = paf.business_group_id

Line 398: WHERE ja_cn_cfs_data_clt_pkg.get_balancing_segment(fdh.code_combination_id) =

394: AND fdh.assigned_to IS NULL
395: AND EXISTS
396: (SELECT jclllbg.bal_seg_value
397: FROM ja_cn_ledger_le_bsv_gt jclllbg
398: WHERE ja_cn_cfs_data_clt_pkg.get_balancing_segment(fdh.code_combination_id) =
399: jclllbg.bal_seg_value
400: AND jclllbg.Ledger_Id = pn_ledger_id
401: AND jclllbg.Legal_Entity_Id = pn_legal_entity_id)
402: GROUP BY assigned_to;