67: AND ffvs.flex_value_set_name = 'JA_CN_SETTLEMENT_METHOD')
68: --Only existing settlement method in Itemized Journal table should be exported
69: WHERE settlement_method_number IN
70: (SELECT jl.settlement_method_number
71: FROM ja_cn_journal_lines jl, ja_cn_voucher_number jcvn
72: --Update by Jianchao Chi, for cnaov2 upgrade, 06-Jan-2011
73: --Add ja_cn_voucher_number table, voucher number and legal entity
74: --are fetched from ja_cn_voucher_number
75: --The previous one was:
69: WHERE settlement_method_number IN
70: (SELECT jl.settlement_method_number
71: FROM ja_cn_journal_lines jl, ja_cn_voucher_number jcvn
72: --Update by Jianchao Chi, for cnaov2 upgrade, 06-Jan-2011
73: --Add ja_cn_voucher_number table, voucher number and legal entity
74: --are fetched from ja_cn_voucher_number
75: --The previous one was:
76: ----------------------------------------------------
77: --FROM ja_cn_journal_lines jl
70: (SELECT jl.settlement_method_number
71: FROM ja_cn_journal_lines jl, ja_cn_voucher_number jcvn
72: --Update by Jianchao Chi, for cnaov2 upgrade, 06-Jan-2011
73: --Add ja_cn_voucher_number table, voucher number and legal entity
74: --are fetched from ja_cn_voucher_number
75: --The previous one was:
76: ----------------------------------------------------
77: --FROM ja_cn_journal_lines jl
78: --WHERE jl.legal_entity_id = pn_legal_entity