/**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_IM_MDC_MTB_E_FOUTOWNER') CREATE INDEX IDX_IM_MDC_MTB_E_FOUTOWNER ON T_IM_MDC_MQBENTRY ( FOUTOWNERID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_IM_MDC_MTB_E_FWAREHOUSE') CREATE INDEX IDX_IM_MDC_MTB_E_FWAREHOUSE ON T_IM_MDC_MQBENTRY ( FWAREHOUSEID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_IM_MDC_PRBLE_FOUTOWNER') CREATE INDEX IDX_IM_MDC_PRBLE_FOUTOWNER ON T_IM_MDC_PRBLENTRY ( FOUTOWNERID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_IM_MDC_PRBLE_WAREHOUSE') CREATE INDEX IDX_IM_MDC_PRBLE_WAREHOUSE ON T_IM_MDC_PRBLENTRY ( FWAREHOUSEID );


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