DBA Data[Home] [Help]

APPS.JA_CN_UDRV_EXPORT dependencies on JA_CN_JOURNAL_LINES

Line 111: ja_cn_journal_lines jcjl

107: 'SEGMENT25',jcjl.segment25, 'SEGMENT26',jcjl.segment26, 'SEGMENT27',jcjl.segment27,
108: 'SEGMENT28',jcjl.segment28, 'SEGMENT29',jcjl.segment29, 'SEGMENT30',jcjl.segment30) value_number
109: , ffvt.description
110: FROM
111: ja_cn_journal_lines jcjl
112: , gl_ledgers gl, gl_periods gp
113: , fnd_flex_values_tl ffvt
114: , fnd_flex_values ffv
115: , fnd_id_flex_segments fifs

Line 177: ja_cn_journal_lines jcjl

173: 'SEGMENT25',jcjl.segment25, 'SEGMENT26',jcjl.segment26, 'SEGMENT27',jcjl.segment27,
174: 'SEGMENT28',jcjl.segment28, 'SEGMENT29',jcjl.segment29, 'SEGMENT30',jcjl.segment30) value_number
175: , ppa.name,ppa.description
176: FROM
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

Line 246: FROM ja_cn_journal_lines jl, --line numbers in ja_cn_journal_lines.

242:
243: SELECT count(*)
244: INTO ln_journal_number
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