-- -------------------------------------------------------------------------------------
-- Name.....: DBA_Migration_Notes.txt
-- Purpose..: DBA Migration Notes, FTARPT version 02_01_06
-- -------------------------------------------------------------------------------------
-- <Sep 23 2004> <DRV> For migration into <test> (<DBQ01>)

These are required Pulldown and validation procedures and functions need to allow the 
reports to run in CRSRM


-- -------------------------------------------------------------------------------------
-- Migration Notes:


 - As per instructions: 
1) Update existing Views
   @S:\Test\ftarpt\Oracle\02_01_06\ddl\vw\V_FTARPT_B01_CUT_BLOCK_STATUS.VW
   @S:\Test\ftarpt\Oracle\02_01_06\ddl\vw\V_FTARPT_B02_CUT_BLOCK_AREAS.VW
   @S:\Test\ftarpt\Oracle\02_01_06\ddl\vw\V_FTARPT_B03_CUT_BLOCK_DATES.VW
   @S:\Test\ftarpt\Oracle\02_01_06\ddl\vw\V_FTARPT_RAN01_GRAZING_TENURE.VW
   @S:\Test\ftarpt\Oracle\02_01_06\ddl\vw\V_FTARPT_RAN02_HAYCUTNG_TENURE.VW
   @S:\Test\ftarpt\Oracle\02_01_06\ddl\vw\V_FTARPT_RAN04_RANGE_UNIT.VW
   @S:\Test\ftarpt\Oracle\02_01_06\ddl\vw\V_FTARPT_T01_BLOCK_LISTING.VW

2) Update existing Procedures
   @S:\Test\ftarpt\Oracle\02_01_06\ddl\prc\FTARPT_B01_CUT_BLOCK_STATUS.PRC
   @S:\Test\ftarpt\Oracle\02_01_06\ddl\prc\FTARPT_B02_CUT_BLOCK_AREAS.PRC
   @S:\Test\ftarpt\Oracle\02_01_06\ddl\prc\FTARPT_B03_CUT_BLOCK_DATES.PRC
   @S:\Test\ftarpt\Oracle\02_01_06\ddl\prc\FTARPT_F01_LICENCE_DATES.PRC
   @S:\Test\ftarpt\Oracle\02_01_06\ddl\prc\FTARPT_R01_ROAD_PERMIT_SECTN.PRC
   @S:\Test\ftarpt\Oracle\02_01_06\ddl\prc\FTARPT_R02_ROAD_PERMIT_AMEND.PRC
   @S:\Test\ftarpt\Oracle\02_01_06\ddl\prc\FTARPT_R03_CURKM_UNDR_RDPRMT.PRC
   @S:\Test\ftarpt\Oracle\02_01_06\ddl\prc\FTARPT_RAN01_GRAZING_TENURE.PRC
   @S:\Test\ftarpt\Oracle\02_01_06\ddl\prc\FTARPT_RAN02_HAYCUTNG_TENURE.PRC
   @S:\Test\ftarpt\Oracle\02_01_06\ddl\prc\FTARPT_RAN04_RANGE_UNIT.PRC
   @S:\Test\ftarpt\Oracle\02_01_06\ddl\prc\FTARPT_T01_BLOCK_LISTING.PRC


-- -------------------------------------------------------------------------------------

-  generate public synonym list
-  review for invalids

-- -------------------------------------------------------------------------------------

