DBA Data[Home] [Help]

APPS.JA_CN_UDR_EXPORT dependencies on JA_CN_JOURNAL_LINES

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

104:
105: SELECT COUNT(*)
106: INTO ln_journal_number
107: FROM (SELECT DISTINCT *--Add by Jianchao Chi, 10-Jan-2011, for one hearder may has two same
108: FROM ja_cn_journal_lines jl, --line numbers in ja_cn_journal_lines.
109: gl_ledgers gl,
110: gl_periods gp,
111: ja_cn_voucher_number jcvn
112: --Update by Jianchao Chi, for cnaov2 upgrade