[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT DISTINCT gjc.user_je_category_name,
gjc.je_category_key,
gjc.je_category_name
FROM gl_je_categories gjc,
ja_cn_journal_lines gcgl,
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 = jl.je_header_id
--AND jcvn.je_line_number = jl.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 gjc.user_je_category_name;