/**Begin D:\PDM_UPGRADE\PDM1\MRP_constraint.sql **/
 EXEC P_ALTERPK 'PK_T_MRP_REQCALC_RECORD', 'T_MRP_REQCALC_RECORD', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_MRP_REQCALC_RECORD_G') CREATE INDEX IDX_MRP_REQCALC_RECORD_G ON T_MRP_REQCALC_RECORD ( FLAST_RUNLOGNO );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_MRP_REQCALC_RECORD_BEID') CREATE INDEX IDX_MRP_REQCALC_RECORD_BEID ON T_MRP_REQCALC_RECORD ( F_BILLENTRY_ID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_MRP_REQCALC_RECORD_B') CREATE INDEX IDX_MRP_REQCALC_RECORD_B ON T_MRP_REQCALC_RECORD ( F_BILL_NO );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_MRP_REQCALC_RECORD_BID') CREATE INDEX IDX_MRP_REQCALC_RECORD_BID ON T_MRP_REQCALC_RECORD ( F_BILL_ID );



/**End D:\PDM_UPGRADE\PDM1\MRP_constraint.sql **/
