/* ************************************************ */
/*                                                  */
/* fnctn:   Show the number of orders imported from */
/*          the MOE system.                         */
/*                                                  */
/* name:    @c:\oracle\sql\oi_daily.sql             */
/* date:    12-MAY-95                               */
/* creator: Rick Kupcunas (Oracle)                  */
/*                                                  */
/* ************************************************ */

def the_date=&&1
select 'Orders imported from MOE system on &the_date :'||count(*)
from   so_headers
where  original_system_source_code=1000 and
       to_char(s1_date,'DD-MON-YY') = '&the_date';