chart.sql

 


 set pages 0
 set lines 400
 set termout off
 
 SELECT to_char(gl.account,'99999') || ltrim(to_char(gl.sub_account,'0000'),' ') || '|' ||
 rtrim(GL.DESCRIPTION,' ') || '|' || rtrim(GL.OPTION_FLD_3,' ') || '|' ||
 rtrim(gl.ACCT_UNIT) || '|' || substr(OPTION_FLD_2,1,2) || '|' ||
 substr(OPTION_FLD_2,3,2) || '|' ||  substr(OPTION_FLD_2,5,1) || '|' ||
 gl.active_status || '|' || gl.AMOUNT_01 || '|' || gl.AMOUNT_02 ||'|' || gl.AMOUNT_03 || '|' || gl.AMOUNT_04 || '|' ||
 gl.AMOUNT_05 || '|' || gl.AMOUNT_06 || '|' || gl.AMOUNT_07 || '|' || gl.AMOUNT_08 || '|' ||
 gl.AMOUNT_09 || '|' || gl.AMOUNT_10 || '|' || gl.AMOUNT_11 || '|' || gl.AMOUNT_12 || '|' ||
 fb.AMOUNT_01 || '|' || fb.AMOUNT_02 || '|' || fb.AMOUNT_03 || '|' || fb.AMOUNT_04 || '|' ||
 fb.AMOUNT_05 || '|' || fb.AMOUNT_06 || '|' || fb.AMOUNT_07 || '|' || fb.AMOUNT_08 || '|' ||
 fb.AMOUNT_09 || '|' || fb.AMOUNT_10 || '|' || fb.AMOUNT_11 || '|' || fb.AMOUNT_12 || '|' ||
 gl.AMOUNT_14 || '|' || gl.AMOUNT_15 || '|' || gl.AMOUNT_16 || '|' || gl.AMOUNT_17 || '|' ||
 gl.AMOUNT_18 || '|' || gl.AMOUNT_19 || '|' || gl.AMOUNT_20 || '|' || gl.AMOUNT_21 || '|' ||
 gl.AMOUNT_22 || '|' || gl.AMOUNT_23 || '|' || gl.AMOUNT_24 || '|' || gl.AMOUNT_25
 FROM glmaster gl, fbdetail fb
 where gl.account = fb.account(+) and gl.sub_account = fb.sub_account(+) and gl.acct_unit = fb.acct_unit(+) and fb.budget_nbr(+) = 1 and fb.fiscal_year(+) = 1998
 and ((gl.ACTIVE_STATUS = 'A')
 or (gl.ACTIVE_STATUS='I' AND gl.SUB_ACCOUNT=0))
 Order by gl.acct_unit
 
 spool /xfer/chart.txx
 /
 
 spool off
 
 exit