[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT DISTINCT fcv.currency_code, fcv.name
FROM fnd_currencies_vl fcv,
ja_cn_journal_lines jcjl,
ja_cn_voucher_number jcvn
--Update by Jianchao Chi, for cnaov2 upgrade 05-JAN-2011
--Add ja_cn_voucher_number table, voucher number and legal entity
--are fetched from ja_cn_voucher_number
--The new one is
----------------------------------------------------
--AND jcvn.je_header_id = jcjl.je_header_id
--AND jcvn.je_line_number = jcjl.je_line_num
--AND jcvn.legal_entity_id = ln_legal_entity_id;
(SELECT gp.period_name
FROM gl_periods gp, gl_ledgers gl
WHERE gp.period_year = ln_accounting_year
AND gp.period_set_name = gl.period_set_name)
--Comment by Jianchao Chi to change the logic of legal entity, 05-JAN-2011
--AND jcjl.legal_entity_id = ln_legal_entity_id
AND jcvn.legal_entity_id = ln_legal_entity_id
ORDER BY fcv.currency_code;