EXEC p_DropIdx 'IDX_STOCK_FTRACKNUMBER', 'T_POM_MFTORDERENTRY_S';
EXEC p_DropIdx 'IDX_STOCK_FCONFIGUREDCODE', 'T_POM_MFTORDERENTRY_S';
EXEC p_DropIdx 'IDX_POM_MOES_FORDERID', 'T_POM_MFTORDERENTRY_S';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_POM_MOES_FORDERENTRYID') CREATE INDEX IDX_POM_MOES_FORDERENTRYID ON T_POM_MFTORDERENTRY_S ( FORDERENTRYID );
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_POM_MOES_FORDERNO') CREATE INDEX IDX_POM_MOES_FORDERNO ON T_POM_MFTORDERENTRY_S ( FORDERNO );
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_POM_MOES_FORDERID') CREATE INDEX IDX_POM_MOES_FORDERID ON T_POM_MFTORDERENTRY_S ( FORDERID,FSOURCEBILLID );
   