begin
	NLSUPGRADE;
end;
/

drop procedure NLSUPGRADE;


create view CMPSupportedLanguage_V
(
    DeletionParent,
    ClassName
   ,CreationTimestamp
   ,UpdateTimestamp
   ,Note
   ,NOTM
   ,Version
   ,ElementId
   ,Name
   ,LogicalName
   ,Description
   ,Editable
   ,Generated
   ,Seeded
   ,Completed
   ,Frozen
   ,Disabled
   ,Imported
   ,CustomerDeletable
   ,CustomerEditable
   ,CustomerRenamable
   ,UOID
   ,OwningIntersection
   ,IsBaseLanguage
   ,ISOID
   ,Installation
) 
as select
    DELETIONPARENT,
    s2_1
   ,d_1
   ,d_2
   ,s3_1
   ,i_1
   ,s1_1
   ,i_2
   ,s2_2
   ,s3_2
   ,s3_3
   ,b_1
   ,b_2
   ,b_3
   ,b_4
   ,b_5
   ,b_6
   ,b_7
   ,b_8
   ,b_9
   ,b_10
   ,s2_3
   ,r_1
   ,b_11
   ,s1_2
   ,r_27
from CMPAllClasses
where s2_1 in (
          'CMPSupportedLanguage'
);

update CMPInstallation_V set INSTALLEDVERSION = '9.0.2.0.1';
commit;