EBS查询某公司某科⽬的科⽬余额明细SQL EBS查询某公司某科⽬的科⽬余额明细SQL：
lect gltb.period_name,
<1,
<2,
<3,
<4,
草菇汤<5,
gltb.currency_code,
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,
gltb.last_update_date ---- GL Trial Balance Detail
from gl.gl_balances gltb,
apps.gl_code_combinations_kfv glccid,
gl.gl_ledgers glle
de_combination_id = de_combination_id
and gltb.ledger_id = glle.ledger_id
plate_id is null
and glccid.summary_flag = 'N'
and gltb.actual_flag = 'A'
and gltb.currency_code <> 'STAT'
and not exists九州海上牧云记结局
(lect 1
_report_axis_contents rptl,
<_report_axis_ts rptrh,
<_report_axes rptrhi
where rptrh.axis_t_id = rptl.axis_t_id
and rptrh.axis_t_id = rptrhi.axis_t_id
and rptl.axis_q = rptrhi.axis_q
and rptrh.axis_t_type = 'R'
1 between
激光点痦子1_low,
'',
'0',
厨师简历'T',
'0',
<1_low) and
1_high, '', 'T', 1_high)
2 between
2_low,
'',
'0',
'T',
'0',
<2_low) and
2_high, '', 'T', 2_high)
3 between
3_low,
'',
'0',
'T',
'0',
<3_low) and
3_high, '', 'T', 3_high)
6个月宝宝一天辅食表4 between
4_low,
'',
'0',
'T',
'0',
<4_low) and
4_high, '', 'T', 4_high)
5 between
5_low,
双颊
'',
'0',
'T',
'0',
<5_low) and
5_high, '', 'T', 5_high)
6 between
6_low,
'',
'0',
丈的组词'T',
'0',
<6_low) and
6_high, '', 'T', 6_high)
7 between
7_low,
'',
'0',
'T',
'0',
<7_low) and
7_high, '', 'T', 7_high)
8 between
8_low,
'',
'0',
'T',
'0',
<8_low) and
8_high, '', 'T', 8_high)
9 between
9_low,
'',
'0',
'T',
'0',
<9_low) and
9_high, '', 'T', 9_high)
and rptrh.name like 'Balance Sheet_US')
and nvl(gltb.period_net_dr, 0) + nvl(gltb.begin_balance_dr, 0) -
nvl(gltb.period_net_cr, 0) - nvl(gltb.begin_balance_cr, 0) <> 0
and gltb.period_name > '2016-13' and gltb.period_name < '2017-12' --期间名字
-- and glle.name like'%TS%-PRC'
--账套名字
and SEGMENT3 = '123101010101' --科⽬代码
and SEGMENT1 ='10101'--公司组织代码
