SQL Depot

3 queries found for "Batch Control"

Get all from Batch Control

select * 
from CI_BATCH_CTRL

uploaded by Nuno Rodrigues

Get specific Batch Control

select * 
from CI_BATCH_CTRL
where 
BATCH_CD = 'XXXX'

uploaded by Nuno Rodrigues

Bill to be routed for printing on next run

SELECT COUNT(*)
 FROM CISADM.CI_BILL_ROUTING 
WHERE BATCH_NBR = (SELECT NEXT_BATCH_NBR FROM CISADM.CI_BATCH_CTRL WHERE BATCH_CD = 'CM-POSTR');

uploaded by Vinayak Gadgil

About & Contact

Why SQLDepot.com?
Because we've seen the same SQL code being written in different implementations - and that's a waste of time!

Who developed this?
Decrod Ltd - a consulting and application development company based in London, UK.

Is this an Oracle website?
This is not an Oracle website and we are not affiliated, associated, authorized, endorsed by, or in any way officially connected with Oracle Corporation.

Any questions?
Dont hesitate to get in touch. Our email is info@decrod.com