DBA Data[Home] [Help]

APPS.JA_CN_ERT_EXPORT_PKG dependencies on JA_CN_VOUCHER_NUMBER

Line 65: ja_cn_voucher_number jcvn

61: SELECT DISTINCT gdct.conversion_type, gdct.user_conversion_type
62: FROM gl_daily_conversion_types gdct,
63: ja_cn_journal_lines jcjl,
64: gl_je_headers gjh,
65: ja_cn_voucher_number jcvn
66: --Update by Jianchao Chi, for cnaov2 upgrade 05-JAN-2011
67: --Add ja_cn_voucher_number table, voucher number and legal entity
68: --are fetched from ja_cn_voucher_number
69: --The new one is

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

63: ja_cn_journal_lines jcjl,
64: gl_je_headers gjh,
65: ja_cn_voucher_number jcvn
66: --Update by Jianchao Chi, for cnaov2 upgrade 05-JAN-2011
67: --Add ja_cn_voucher_number table, voucher number and legal entity
68: --are fetched from ja_cn_voucher_number
69: --The new one is
70: ----------------------------------------------------
71: --AND jcvn.je_header_id = jl.je_header_id

Line 68: --are fetched from ja_cn_voucher_number

64: gl_je_headers gjh,
65: ja_cn_voucher_number jcvn
66: --Update by Jianchao Chi, for cnaov2 upgrade 05-JAN-2011
67: --Add ja_cn_voucher_number table, voucher number and legal entity
68: --are fetched from ja_cn_voucher_number
69: --The new one is
70: ----------------------------------------------------
71: --AND jcvn.je_header_id = jl.je_header_id
72: --AND jcvn.je_line_number = jl.je_line_num