SELECT fle.flex_value_meaning as account_id, --科目代码
fle.description as account, --科目名
bt.name as batches_name, --批名
he.name as headers_name, --日记帐名
he.period_name as period_name, --会计期
he.default_effective_date, --会计日期
li.description as description, --描述
nvl (li.entered_dr,0) - nvl (li.entered_cr,0) as entered, --余额
nvl (li.accounted_dr,0) - nvl(li.accounted_cr,0) as accounted --本位币余额
FROMgl_je_batches bt,
gl_je_headers he,
gl_je_lines li,
gl_code_combinations co,
fnd_flex_values_tl fle
WHEREbt.je_batch_id = he.je_batch_id
AND he.je_header_id = li.je_header_id
AND li.code_combination_id = co.code_combination_id
AND co.segment2 =fle.flex_value_meaning
AND li.set_of_books_id = '24'
AND fle.LANGUAGE = 'ZHS'
AND li.status = 'P'
AND (he.period_name = :P_PERIOD_NAME
AND he.default_effective_date = :P_date
AND (fle.flex_value_meaning >= :P_FLEX1 AND fle.flex_value_meaning = NVL(:P_FLEX1 ,fle.flex_value_meaning)
AND fle.flex_value_meaning <= NVL(:P_FLEX2,fle.flex_value_meaning)))
|