<sql id="autoAddSequencesBillCode">
SELECT
#typeName# || to_char(sysdate,'yyyyMMdd') ||
lpad( NVL( max( substr( m.ORDER_CODE, instr( m.ORDER_CODE, to_char(sysdate,'yyyyMMdd') )+8 , length(m.ORDER_CODE) ) ),'0000')+1,4,'0')
FROM AP_NEW_BILL_ORDER m
WHERE
m.ORDER_CODE like '%'||#typeName#||to_char(sysdate,'yyyyMMdd')||'%'
and m.type=#type#
</sql>
SELECT
#typeName# || to_char(sysdate,'yyyyMMdd') ||
lpad( NVL( max( substr( m.ORDER_CODE, instr( m.ORDER_CODE, to_char(sysdate,'yyyyMMdd') )+8 , length(m.ORDER_CODE) ) ),'0000')+1,4,'0')
FROM AP_NEW_BILL_ORDER m
WHERE
m.ORDER_CODE like '%'||#typeName#||to_char(sysdate,'yyyyMMdd')||'%'
and m.type=#type#
</sql>