Script 1: ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Created to delete default ids of the merchandise hierarchy from LV10CAT, LV9CMAST, LV8CMAST, LV7CMAST, LV6CMAST, LV5CMAST,LV4CMAST, LV3CMAST, LV2CMAST, LV1CMAST -- Modify the statement below per implementation -- ---------------------------------------------------------------- spool delete_default_cmast_ids.lst --connect maxdata/madmary@&DB_NAME; prompt start delete_default_cmast_ids.sql set pagesize 0; set serveroutput on set linesize 200 delete from lv10cat where lv10cat_id < 1; delete from lv9cmast where lv9cmast_id < 1; delete from lv8cmast where lv8cmast_id < 1; delete from lv7cmast where lv7cmast_id < 1; delete from lv6cmast where lv6cmast_id < 1; delete from lv5cmast where lv5cmast_id < 1; delete from lv4cmast where lv4cmast_id < 1; delete from lv3cmast where lv3cmast_id < 1; delete from lv2cmast where lv2cmast_id < 1; delete from lv1cmast where lv1cmast_id < 1; execute maxapp.p_log_version('Delete Default Merch IDs', 'delete_lv10cat_lv9cmast_lv1cmast'); commit; prompt end delete_default_cmast_ids.sql spool off; ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Script 2 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Created to delete default ids of merchandise hierarchy from LV4MAST, LV3MAST, LV2MAST, LV1MAST, LV4LOC, LV3LOC, LV2LOC, LV1LOC -- Modify the statement below per implementation -- ---------------------------------------------------------------- spool delete_default_lvXloc_mast_ids.lst connect maxdata/madmary@&DB_NAME; prompt start delete_default_lvXloc_mast_ids.sql set pagesize 0; set serveroutput on set linesize 200 delete from lv4mast where lv4mast_id < 1; delete from lv3mast where lv3mast_id < 1; delete from lv2mast where lv2mast_id < 1; delete from lv1mast where lv1mast_id < 1; delete from lv4loc where lv4loc_id < 1; delete from lv3loc where lv3loc_id < 1; delete from lv2loc where lv2loc_id < 1; delete from lv1loc where lv1loc_id < 1; execute maxapp.p_log_version('Delete Default Loc IDs', 'delete_default_lvXloc_mast_ids'); commit; prompt end delete_default_cmast_ids.sql spool off; ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++