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

Line 116: , ja_cn_voucher_number jcvn

112: , gl_ledgers gl, gl_periods gp
113: , fnd_flex_values_tl ffvt
114: , fnd_flex_values ffv
115: , fnd_id_flex_segments fifs
116: , ja_cn_voucher_number jcvn
117: WHERE fifs.id_flex_num = pn_coa_id
118: AND fifs.id_flex_code = 'GL#'
119: AND fifs.application_column_name = lv_context_code
120: AND fifs.flex_value_set_id = ffv.flex_value_set_id

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

121: AND gl.ledger_id = pn_ledger_id
122: AND gl.period_set_name = gp.period_set_name
123: AND gp.period_name = jcjl.period_name
124: --Update by Jianchao Chi, for cnaov2 upgrade 05-JAN-2011
125: --Add ja_cn_voucher_number table, voucher number and legal entity
126: --are fetched from ja_cn_voucher_number
127: --The new one is
128: ----------------------------------------------------
129: --AND jcvn.je_header_id = jl.je_header_id

Line 126: --are fetched from ja_cn_voucher_number

122: AND gl.period_set_name = gp.period_set_name
123: AND gp.period_name = jcjl.period_name
124: --Update by Jianchao Chi, for cnaov2 upgrade 05-JAN-2011
125: --Add ja_cn_voucher_number table, voucher number and legal entity
126: --are fetched from ja_cn_voucher_number
127: --The new one is
128: ----------------------------------------------------
129: --AND jcvn.je_header_id = jl.je_header_id
130: --AND jcvn.je_line_number = jl.je_line_num

Line 181: , ja_cn_voucher_number jcvn

177: ja_cn_journal_lines jcjl
178: , gl_ledgers gl
179: , gl_periods gp
180: , pa_projects_all ppa
181: , ja_cn_voucher_number jcvn
182: WHERE gl.ledger_id = pn_ledger_id
183: --Update by Jianchao Chi, for cnaov2 upgrade 05-JAN-2011
184: --Add ja_cn_voucher_number table, voucher number and legal entity
185: --are fetched from ja_cn_voucher_number

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

180: , pa_projects_all ppa
181: , ja_cn_voucher_number jcvn
182: WHERE gl.ledger_id = pn_ledger_id
183: --Update by Jianchao Chi, for cnaov2 upgrade 05-JAN-2011
184: --Add ja_cn_voucher_number table, voucher number and legal entity
185: --are fetched from ja_cn_voucher_number
186: --The new one is
187: ----------------------------------------------------
188: --AND jcvn.je_header_id = jl.je_header_id

Line 185: --are fetched from ja_cn_voucher_number

181: , ja_cn_voucher_number jcvn
182: WHERE gl.ledger_id = pn_ledger_id
183: --Update by Jianchao Chi, for cnaov2 upgrade 05-JAN-2011
184: --Add ja_cn_voucher_number table, voucher number and legal entity
185: --are fetched from ja_cn_voucher_number
186: --The new one is
187: ----------------------------------------------------
188: --AND jcvn.je_header_id = jl.je_header_id
189: --AND jcvn.je_line_number = jl.je_line_num

Line 249: ja_cn_voucher_number jcvn

245: FROM (SELECT DISTINCT * --Add by Jianchao Chi, 10-Jan-2011, for one hearder may has two same
246: FROM ja_cn_journal_lines jl, --line numbers in ja_cn_journal_lines.
247: gl_ledgers gl,
248: gl_periods gp,
249: ja_cn_voucher_number jcvn
250: --Update by Jianchao Chi, for cnaov2 upgrade 05-JAN-2011
251: --Add ja_cn_voucher_number table, voucher number and legal entity
252: --are fetched from ja_cn_voucher_number
253: --The new one is

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

247: gl_ledgers gl,
248: gl_periods gp,
249: ja_cn_voucher_number jcvn
250: --Update by Jianchao Chi, for cnaov2 upgrade 05-JAN-2011
251: --Add ja_cn_voucher_number table, voucher number and legal entity
252: --are fetched from ja_cn_voucher_number
253: --The new one is
254: ----------------------------------------------------
255: --AND jcvn.je_header_id = jl.je_header_id

Line 252: --are fetched from ja_cn_voucher_number

248: gl_periods gp,
249: ja_cn_voucher_number jcvn
250: --Update by Jianchao Chi, for cnaov2 upgrade 05-JAN-2011
251: --Add ja_cn_voucher_number table, voucher number and legal entity
252: --are fetched from ja_cn_voucher_number
253: --The new one is
254: ----------------------------------------------------
255: --AND jcvn.je_header_id = jl.je_header_id
256: --AND jcvn.je_line_number = jl.je_line_num