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_SM_EXPORT_PKG dependencies on JA_CN_VOUCHER_NUMBER

Line 88: FROM JA_CN_JOURNAL_LINES jl, ja_cn_voucher_number jcvn

84: AND ffvs.flex_value_set_name = 'JA_CN_SETTLEMENT_METHOD')
85: --Only existing settlement method in Itemized Journal table should be exported
86: WHERE Settlement_Method_Number IN
87: (SELECT jl.Settlement_Method_Number
88: FROM JA_CN_JOURNAL_LINES jl, ja_cn_voucher_number jcvn
89: --Update by Jianchao Chi, for cnaov2 upgrade 06-JAN-2011
90: --Add ja_cn_voucher_number table, voucher number and legal entity
91: --are fetched from ja_cn_voucher_number
92: --The new one is

Line 90: --Add ja_cn_voucher_number table, voucher number and legal entity

86: WHERE Settlement_Method_Number IN
87: (SELECT jl.Settlement_Method_Number
88: FROM JA_CN_JOURNAL_LINES jl, ja_cn_voucher_number jcvn
89: --Update by Jianchao Chi, for cnaov2 upgrade 06-JAN-2011
90: --Add ja_cn_voucher_number table, voucher number and legal entity
91: --are fetched from ja_cn_voucher_number
92: --The new one is
93: ----------------------------------------------------
94: --AND jcvn.je_header_id = jl.je_header_id

Line 91: --are fetched from ja_cn_voucher_number

87: (SELECT jl.Settlement_Method_Number
88: FROM JA_CN_JOURNAL_LINES jl, ja_cn_voucher_number jcvn
89: --Update by Jianchao Chi, for cnaov2 upgrade 06-JAN-2011
90: --Add ja_cn_voucher_number table, voucher number and legal entity
91: --are fetched from ja_cn_voucher_number
92: --The new one is
93: ----------------------------------------------------
94: --AND jcvn.je_header_id = jl.je_header_id
95: --AND jcvn.je_line_number = jl.je_line_num