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

---

 

 

Last updated: 05/03/2025 08:50:41