Dear Navneet,
Please find attached an excel sheet Containing all tables, Views, MViews and procedures to be migrated from 2x schema to 3x schema...
It contains all their columns, constraints and indexes.
While migrating them, all of these details should be considered carefully...

Please also find attached a zip file containing All created views, Views and procedures...

Please note that after migration all tables find the below:
1) we need to create" versionid_tmp" column for each table having its "versionid" column with type "varchar"
2) copy same data in "versionid" column to "versionid_tmp" column
3) drop column "versionid" with type varchar
4) create new column "versionid" with type number (19,0)
5)update this new column with the id_number of the version (based on "versionid_tmp" column having version id)
6) drop table "versionid_tmp"

For more clear details, you can refer to me

As per Ahad Confirmation: We have used "Test" version for our current xml  imports. 

ear @Sanju,

Please find attached an excel sheet Containing all tables, Views, MViews and procedures to be migrated from 2x schema to 3x schema

It contains all their columns, constraints and indexes.

While migrating them, all of these details should be considered carefully...

Please also find attached a zip file containing All created views, Views and procedures Scripts

Please note that after migration all tables find the below:
1) we need to create" versionid_tmp" column for each table having its "versionid" column with type "varchar"
2) copy same data in "versionid" column to "versionid_tmp" column
3) drop column "versionid" with type varchar
4) create new column "versionid" with type number (19,0)
5)update this new column with the id_number of the version (based on "versionid_tmp" column having version id)
6) drop table "versionid_tmp"

These are same as the steps shared by you in your previous email..

You can proceed