- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
select *
from INV_CARD
where to_char (dt_reg, 'MM') < TO_CHAR(SYSDATE, 'MM')
AND (DT_OUT IS NULL OR to_char (dt_OUT, 'MM') = TO_CHAR(SYSDATE, 'MM'))
AND ID_FA_TYPE NOT IN (SELECT ID_FA_TYPE FROM FA_TYPE WHERE CODE = '17')
AND ID_FA_STATUS IN (SELECT ID_FA_STATUS FROM FA.V_FA_STATUS WHERE IS_ACCOUNTING = 1)
AND STATUS = 1
AND GLN.ACC_OPER.GET_ACC1_ACC2(ID_AMORT_ACC) LIKE '01%'
guest 11.08.2009 13:21 # 0
guest 18.08.2009 00:25 # 0
extract(month from dt_reg) ....
guest 06.02.2010 17:34 # 0
guest 25.12.2009 16:11 # 0