SELECT gh.je_header_id,
gh.period_name,
gh.default_effective_date,
gh.je_source,
gs.user_je_source_name,
gh.je_category,
gc.user_je_category_name,
gb.name batch_name,
gh.name je_name,
gl.je_line_num,
gh.doc_sequence_value,
gl.description,
gcc.concatenated_segments,
gcc.segment1, --公司
gcc.segment2, --核算主体
gcc.segment3, --部门
gcc.segment4, --科目
gcc.segment5, --子目
gcc.segment6, --项目
gcc.segment7, --往来
gh.currency_code,
gl.entered_dr,
gl.entered_cr,
gl.accounted_dr,
gl.accounted_cr,
gb.approval_status_code,
glook1.meaning approval_status,
glook2.meaning batch_status,
gb.status,
gb.CREATION_DATE,
gh.created_by,
gb.approver_employee_id,
gl.attribute6,
gl.attribute7,
gl.attribute8,
gl.attribute9,
gl.attribute10,
gl.attribute11,
gl.attribute12,
gl.attribute13,
gl.attribute14,
gl.attribute15,
gl.attribute16,
gl.attribute17,
gl.attribute18,
gl.attribute19,
gl.attribute20
FROM gl_je_batches gb,
gl_je_headers gh,
gl_je_lines gl,
gl_code_combinations_kfv gcc,
gl_je_sources gs,
gl_je_categories gc,
gl_lookups glook1,
gl_lookups glook2
WHERE gb.je_batch_id = gh.je_batch_id
AND gh.je_header_id = gl.je_header_id
AND gs.je_source_name = gh.je_source
AND gc.je_category_name = gh.je_category
AND gb.approval_status_code = glook1.lookup_code
AND gb.status = glook2.lookup_code
AND glook1.lookup_type = 'JE_BATCH_APPROVAL_STATUS'
AND glook2.lookup_type = 'BATCH_STATUS'
AND gl.code_combination_id = gcc.code_combination_id
AND gh.ledger_id = g_ledger_id
AND gh.currency_code <> 'STAT'