REPLACE VIEW SEMSIT_EDW_VIEWS.OPRTUNY_DESC ( Desc_Cd,Desc_Grp_Cd,Desc_Role_Type_Cd,Oprtuny_Desc_Start_Dttm,Oprtuny_Desc_End_Dttm,Desc_Amt,Desc_Curr_Amt,Desc_Qty,Desc_Cnt,Desc_Pct,Desc_Dt,Desc_Rate,Desc_Tm,Desc_Dttm,Desc_Val_Cd,Desc_Txt,Uom_Cd,Oprtuny_Id ) AS
LOCKING ROW
ACCESS
SELECT od.Desc_Cd (VARCHAR(50), NAMED Desc_Cd, TITLE 'Descriptor Cd')
     , od.Desc_Grp_Cd (VARCHAR(20), NAMED Desc_Grp_Cd, TITLE 'Descriptor Group Cd')
     , od.Desc_Role_Type_Cd (CHAR(20), NAMED Desc_Role_Type_Cd, TITLE 'Descriptor Role Type Cd')
     , od.Oprtuny_Desc_Start_Dttm (TIMESTAMP(0), NAMED Oprtuny_Desc_Start_Dttm, TITLE 'Opportunity Descriptor Start Dttm')
     , od.Oprtuny_Desc_End_Dttm (TIMESTAMP(0), NAMED Oprtuny_Desc_End_Dttm, TITLE 'Opportunity Descriptor End Dttm')
     , od.Desc_Amt (DECIMAL(18,4), NAMED Desc_Amt, TITLE 'Descriptor Amt')
     , od.Desc_Curr_Amt (DECIMAL(18,4), NAMED Desc_Curr_Amt, TITLE 'Descriptor Currency Amt')
     , od.Desc_Qty (DECIMAL(18,4), NAMED Desc_Qty, TITLE 'Descriptor Qty')
     , od.Desc_Cnt (INTEGER, NAMED Desc_Cnt, TITLE 'Descriptor Cnt')
     , od.Desc_Pct (DECIMAL(9,4), NAMED Desc_Pct, TITLE 'Descriptor Pct')
     , od.Desc_Dt (DATE, NAMED Desc_Dt, TITLE 'Descriptor Dt')
     , od.Desc_Rate (DECIMAL(22,18), NAMED Desc_Rate, TITLE 'Descriptor Rate')
     , od.Desc_Tm (TIMESTAMP(0), NAMED Desc_Tm, TITLE 'Descriptor Tm')
     , od.Desc_Dttm (TIMESTAMP(0), NAMED Desc_Dttm, TITLE 'Descriptor Dttm')
     , od.Desc_Val_Cd (CHAR(20), NAMED Desc_Val_Cd, TITLE 'Descriptor Value Cd')
     , od.Desc_Txt (VARCHAR(1000), NAMED Desc_Txt, TITLE 'Descriptor Txt')
     , od.Uom_Cd (CHAR(20), NAMED Uom_Cd, TITLE 'UOM Cd')
     , od.Oprtuny_Id (INTEGER, NAMED Oprtuny_Id, TITLE 'Opportunity Id')
FROM   SEMSIT_EDW_VODACOM.OPRTUNY_DESC od;