/**Begin D:\PDM_UPGRADE\PDM1\FA_constraint.sql **/
EXEC p_DropIdx 't_fa_assettransfer_freceiveassetorgid_idx', 't_fa_assettransfer';
IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_FA_ASSTRA__FREORGID') CREATE INDEX IDX_FA_ASSTRA__FREORGID ON t_fa_assettransfer (freceiveassetorgid,fapplydate);
EXEC p_DropIdx 't_fa_assetdrawback_frealassetorgid_idx', 't_fa_assetdrawback';
IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_FA_ASSDRA_FREORGID') CREATE INDEX IDX_FA_ASSDRA_FREORGID ON t_fa_assetdrawback (frealassetorgid,fapplydate);
EXEC p_DropIdx 't_fa_asset_requisition_fassetorgid_idx', 't_fa_asset_requisition';
IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_FA_ASSREQ_FREORGID') CREATE INDEX IDX_FA_ASSREQ_FREORGID ON t_fa_asset_requisition (fassetorgid,foperatedate);


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