/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\MRP_constraint.sql **/
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_MRP_CALDETAILENTRY_MA') CREATE INDEX IDX_MRP_CALDETAILENTRY_MA ON T_MRP_CALDETAILENTRY ( FMATERIAL );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_MRP_PLANORDER_ORG') CREATE INDEX IDX_MRP_PLANORDER_ORG ON T_MRP_PLANORDER ( FPROORPURORG );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_MRP_PLANORDER_MA') CREATE INDEX IDX_MRP_PLANORDER_MA ON T_MRP_PLANORDER ( FMATERIAL );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_MRP_PLANORDER_PL') CREATE INDEX IDX_MRP_PLANORDER_PL ON T_MRP_PLANORDER ( FPLANOPERATENUM );


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