EBS查询某公司某科目的科目余额明细SQL:
select gltb.period_name,
select gltb.period_name,
glccid.segment1,
glccid.segment2,
glccid.segment3,
glccid.segment4,
glccid.segment5,
gltb.currency_code,
glccid.concatenated_segments,
glle.ledger_id,
glle.name Ledger_Name,
nvl(gltb.begin_balance_dr, 0) - nvl(gltb.begin_balance_cr, 0) YTD_Period_Start,
nvl(gltb.period_net_dr, 0) - nvl(gltb.period_net_cr, 0) PTD,
nvl(gltb.period_net_dr, 0) + nvl(gltb.begin_balance_dr, 0) -
nvl(gltb.period_net_cr, 0) - nvl(gltb.begin_balance_cr, 0) YTD_Period_End,
glccid.enabled_flag,
glccid.end_date_active,
gltb.last_update_date ---- GL Trial Balance Detail
from gl.gl_balances gltb,
apps.gl_code_combinations_kfv glccid,
gl.gl_ledgers glle
where gltb.code_combination_id = glccid.code_combination_id
and gltb.ledger_id = glle.ledger_id
and gltb.template_id is null