/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\POM_constraint.sql **/
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_POM_XMOES_FSOURCEBILLID') CREATE INDEX IDX_POM_XMOES_FSOURCEBILLID ON T_POM_XMFTORDERENTRY_S ( FSOURCEBILLID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_POM_MOES_FSOURCEBILLID') CREATE INDEX IDX_POM_MOES_FSOURCEBILLID ON T_POM_MFTORDERENTRY_S ( FSOURCEBILLID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_STOCKEN_FSRCBILLENTRYID') CREATE INDEX IDX_STOCKEN_FSRCBILLENTRYID ON T_POM_MANUSTOCKENTRY ( FSRCBILLENTRYID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_XSTENTRY_FSRCBILLENTRYID') CREATE INDEX IDX_XSTENTRY_FSRCBILLENTRYID ON T_POM_XMANUSTOCKENTRY ( FSRCBILLENTRYID );


/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\POM_constraint.sql **/
