DBA Data[Home] [Help]

APPS.JA_CN_UDR_EXPORT dependencies on JA_CN_VOUCHER_NUMBER

Line 111: ja_cn_voucher_number jcvn

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
113: --Add ja_cn_voucher_number table, voucher number and legal entity
114: --are fetched from ja_cn_voucher_number
115: --The new one is

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

109: gl_ledgers gl,
110: gl_periods gp,
111: ja_cn_voucher_number jcvn
112: --Update by Jianchao Chi, for cnaov2 upgrade
113: --Add ja_cn_voucher_number table, voucher number and legal entity
114: --are fetched from ja_cn_voucher_number
115: --The new one is
116: ----------------------------------------------------
117: --AND jcvn.je_header_id = jl.je_header_id

Line 114: --are fetched from ja_cn_voucher_number

110: gl_periods gp,
111: ja_cn_voucher_number jcvn
112: --Update by Jianchao Chi, for cnaov2 upgrade
113: --Add ja_cn_voucher_number table, voucher number and legal entity
114: --are fetched from ja_cn_voucher_number
115: --The new one is
116: ----------------------------------------------------
117: --AND jcvn.je_header_id = jl.je_header_id
118: --AND jcvn.je_line_number = jl.je_line_num