DBA Data[Home] [Help]

APPS.JA_CN_CUR_EXPORT_PKG dependencies on JA_CN_VOUCHER_NUMBER

Line 64: ja_cn_voucher_number jcvn

60: ln_accounting_year NUMBER) IS
61: SELECT DISTINCT fcv.currency_code, fcv.name
62: FROM fnd_currencies_vl fcv,
63: ja_cn_journal_lines jcjl,
64: ja_cn_voucher_number jcvn
65: --Update by Jianchao Chi, for cnaov2 upgrade 05-JAN-2011
66: --Add ja_cn_voucher_number table, voucher number and legal entity
67: --are fetched from ja_cn_voucher_number
68: --The new one is

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

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

Line 67: --are fetched from ja_cn_voucher_number

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