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_PS_SI_SM_EXPORT_PKG dependencies on JA_CN_JOURNAL_LINES

Line 71: FROM ja_cn_journal_lines jl, ja_cn_voucher_number jcvn

67: AND ffvs.flex_value_set_name = 'JA_CN_SETTLEMENT_METHOD')
68: --Only existing settlement method in Itemized Journal table should be exported
69: WHERE settlement_method_number IN
70: (SELECT jl.settlement_method_number
71: FROM ja_cn_journal_lines jl, ja_cn_voucher_number jcvn
72: --Update by Jianchao Chi, for cnaov2 upgrade, 06-Jan-2011
73: --Add ja_cn_voucher_number table, voucher number and legal entity
74: --are fetched from ja_cn_voucher_number
75: --The previous one was:

Line 77: --FROM ja_cn_journal_lines jl

73: --Add ja_cn_voucher_number table, voucher number and legal entity
74: --are fetched from ja_cn_voucher_number
75: --The previous one was:
76: ----------------------------------------------------
77: --FROM ja_cn_journal_lines jl
78: --WHERE jl.legal_entity_id = pn_legal_entity
79: ----------------------------------------------------
80: --Add the following three condidions
81: WHERE jcvn.legal_entity_id = pn_legal_entity --Legal entity ID parameter