gl.sql

set pages 0
set lines 900
set termout on
set echo off
set feed 1


SELECT gl.account, gl.sub_account, GL.DESCRIPTION, GL.OPTION_FLD_3, 
 gl.ACTIVE_STATUS,
 gl.ACCT_UNIT,
 OPTION_FLD_2,
 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, 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 , 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
 FROM glmaster gl, fbdetail fb
where gl.SUB_ACCOUNT(+) = fb.SUB_ACCOUNT and gl.ACCOUNT(+) = fb.ACCOUNT
AND gl.ACCT_UNIT(+) = fb.ACCT_UNIT
and (((gl.ACTIVE_STATUS='A') AND (gl.UNITS_CODE<>'O'))
 OR ((gl.ACTIVE_STATUS='I') AND (gl.SUB_ACCOUNT=0) AND (gl.UNITS_CODE<>'O')))

spool /xfer/gl.txt
/

spool off

exit