eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.DDR_SETUP_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 27


    SELECT COUNT(*)
    INTO   v_org_exists
    FROM   DDR_R_ORG
    WHERE  mfg_org_cd = p_mfg_org
    AND    org_cd = p_mfg_org;

Line: 34


      INSERT INTO ddr_r_org
      (mfg_org_cd, org_cd, org_typ, glbl_loc_id, glbl_loc_id_typ,
      created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
      VALUES
      (p_mfg_org, p_mfg_org, 'MFG', -1, -1,
       -1, SYSDATE, '-1', SYSDATE, '-1', v_version, SYSDATE, '-1', '-1');

Line: 50


        WHEN NOT MATCHED THEN INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'BSNS_UNIT_TYP','CATALOGUE','Catalogue','Catalogue',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 55


        WHEN NOT MATCHED THEN INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'BSNS_UNIT_TYP','DC','Distribution Centre','Distribution Centre',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 60


        WHEN NOT MATCHED THEN INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'BSNS_UNIT_TYP','RTLSTORE','Retail Store','Retail Store',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 66


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'BSNS_UNIT_TYP','WAREHOUSE','Warehouse','Warehouse',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 72


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'BSNS_UNIT_TYP','WEBSTORE','Web Store','Web Store',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 79


        INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'BSNS_UNIT_TYP','MFG','Manufacturer','Manufacturer',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 86


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'CHNL_TYP','Direct','Direct','Direct',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 92


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'ERR','DSR-1001','NULL not allowed','This column value can not be NULL, please provide non NULL value',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 98


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'ERR','DSR-1002','Invalid Value','No matching value found in setup, please provide valid column value',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 104


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'ERR','DSR-1003','Zero Value','This column can not have zero values, please provide non zero value',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 110


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'ERR','DSR-1004','Invalid item association','The item is not authorized to be sold from this Business Unit',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 116


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'ERR','DSR-1005','Invalid Organization Type','Invalid Organization Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 122


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'ERR','DSR-1006','Invalid Combination','Invalid Combination',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 128


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'ERR','DSR-1007','Inactive Business Unit','The Business Unit is not operational',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 134


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'ERR','DSR-1008','Time Alloc % Not Found','No record found for Time allocation in setup ',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 140


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'ERR','DSR-1009','Org Alloc % Not Found','No record found for Organization  allocation in setup',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 146


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'ERR','DSR-1010','No UOM conversion Found','No matching value found in the setup conversion table',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 152


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'ERR','DSR-1011','No Exchange Rate found ','No matching value found in the setup exchange rate table',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 158


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'ERR','DSR-1012','Inactive Item','The Item has expired',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 164


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'ERR','DSR-1013','Clustrtyp and BU combination exists','Cluster type and BU combination already exists',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 170


         INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
         VALUES (p_mfg_org,'ERR','DSR-1014','ItmClustrTyp and SKU combination exists','Item Cluster type and SKU Item combination already exists',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 177


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','% RETURNS','% RETURNS','% Returns',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 183


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','CATEGORY MONETARY SALES','CATEGORY MONETARY SALES','CATEGORY MONETARY SALES',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 189


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','DEDUCTION AMT','Deduction Amount','Deduction Amount',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 195


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','DEDUCTION BALANCE','Deduction Balance','Deduction Balance',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 202


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','DOLLAR SALE','Dollar Sale','Dollar Sale',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 208


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','GROSS MARGIN','Gross Margin','Gross Margin',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 214


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','IN STOCK %','IN STOCK %','In Stock % ',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 220


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','INVENTORY COVER MAX','INVENTORY COVER MAX','Inventory Cover max ',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 226


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','INVENTORY COVER MIN','INVENTORY COVER MIN','Inventory Cover min ',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 232


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','INVENTORY TURNS','Inventory Turns','Inventory Turns',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 238


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','INVOICE ACCURACY','Invoice Accuracy','Invoice Accuracy',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 244


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','ITEM DATA ACCURACY','Item Data Accuracy','Item Data Accuracy',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 250


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','ITEM DATA SYNCHRONIZATION','Item Data Synchronization','Item Data Synchronization',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 257


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','LATE PAYMENT','Late Payment','Late Payment',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 263


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','MONETARY SALES','MONETARY SALES','MONETARY SALES',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 269


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','NO OF DEDUCTIONS','No. of Deductions','No. of Deductions',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 275


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','ON TIME DELIVERY DATE','On Time Delivery - Date','On Time Delivery - Date',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 281


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','ON TIME DELIVERY TIME','On Time Delivery - Time','On Time Delivery - Time',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 287


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','ON-HAND INVENTORY','ON-HAND INVENTORY','On-Hand Inventory ',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 293


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','ORDER CHANGE %','Order Change %','Order Change %',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 299


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','ORDER CYCLE TIME','Order Cycle Time','Order Cycle Time',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 305


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','PAYEMENT DAYS','Payment Days','Payment Days',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 311


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','PERFECT ORDER %','Perfect Order %','Perfect Order %',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 317


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','RETAIL GROSS MARGIN (%)','RETAIL GROSS MARGIN (%)','Retail Gross Margin (%)',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 323


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','SALES FORECAST ACCURACY (%)','SALES FORECAST ACCURACY (%)','Sales Forecast Accuracy (%)',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 329


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','SERVICE LEVEL','SERVICE LEVEL','Service Level ',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 335


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','SHARE OF MARKET','Share of Market','Share of Market',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 341


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','SHOPPER PENETRATION','Shopper Penetration','Shopper Penetration',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 347


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','UNIT SALE','Unit Sale','Unit Sale',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 353


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE','UNSALEABLES','Unsaleables','Unsaleables',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 359


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE_TYP','EXTERNAL','External Measure','External Measure',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 365


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE_TYP','GOAL','Goal','Goal',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 371


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MEASURE_TYP','THRESHOLD','Threshold','Threshold',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 377


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MFG_ITEM_LVL','CLASS','Item Class / Category','Item Class / Category',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 383


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MFG_ITEM_LVL','COMPANY','Item Company','Item Company',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 389


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MFG_ITEM_LVL','DIVISION','Item Division','Item Division',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 395


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MFG_ITEM_LVL','GROUP','Item Group','Item Group',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 401


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MFG_ITEM_LVL','ITEM','Item','Item',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 407


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MFG_ITEM_LVL','NA','Not Applicable','Not Applicable',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 413


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MFG_ITEM_LVL','SKU','SKU','SKU',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 419


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'MFG_ITEM_LVL','SUBCLASS','Item Sub-Class','Item Sub-Class',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 425


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'ORG_LVL','AREA','Area','Area',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 431


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'ORG_LVL','BU','Business Unit','Business Unit',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 437


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'ORG_LVL','CHAIN','Chain','Chain',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 443


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'ORG_LVL','DISTRICT','District','District',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 449


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'ORG_LVL','NA','Not Applicable','Not Applicable',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 455


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'ORG_LVL','ORGANIZATION','Organization','Organization',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 461


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'ORG_LVL','REGION','Region','Region',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 467


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'ORG_TYP','CMP','Competitor','Competitor',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 473


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'ORG_TYP','MFG','Manufacturer','Manufacturer',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 479


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'ORG_TYP','RTL','Retailer','Retailer',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 486


        INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
	VALUES (p_mfg_org,'ORG_TYP','DST','Distributor','Distributor',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 493


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'RTL_ITEM_LVL','CLASS','Item Class / Category','Item Class / Category',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 499


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'RTL_ITEM_LVL','COMPANY','Item Company','Item Company',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 505


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'RTL_ITEM_LVL','DEPARTMENT','Item Department','Item Department',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 511


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'RTL_ITEM_LVL','DIVISION','Item Division','Item Division',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 517


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'RTL_ITEM_LVL','GROUP','Item Group','Item Group',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 524


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'RTL_ITEM_LVL','ITEM','Item','Item',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 530


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'RTL_ITEM_LVL','NA','Not Applicable','Not Applicable',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 536


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'RTL_ITEM_LVL','SKU','SKU','SKU',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 542


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'RTL_ITEM_LVL','SUBCLASS','Item Sub-Class','Item Sub-Class',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 548


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'SYS_PARAM','DISCOVERY_MODE','N','Discovery mode for POS Data: Possible values are N for Strict Mode and Y for Item Discovery Mode',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 554


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'SYS_PARAM','MAX_OUTPUT_RECORDS','20000000','Maximum records that can be returned to the calling application through web services',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 560


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'SYS_PARAM','MAX_REC_PER_FILE','200000','Maximum number of records per output file created by web service',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 566


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'SYS_PARAM','OUTPUT_DIR_PATH',NULL,'Directory for web service output files',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 572


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'SYS_PARAM','PERFORM_DUP_CHECK','N','Duplicate record check for Fact data: Possible values are Y to perform check for duplicate records and N to skip check for duplicate records',v_version
               ,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 579


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'SYS_PARAM','RUN_TYPE_FACT','P','Data Load Mode for Fact data: Possible values are P for Partial data load, S for Simulation and A for All or None data load',v_version,SYSDATE,'-1','-1','-1'
               ,SYSDATE,'-1',SYSDATE,'-1');

Line: 586


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'SYS_PARAM','RUN_TYP_REF','P','Data Load Mode for Reference data: Possible values are P for Partial Load and S for Simulation Load',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 592


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'SYS_PARAM','STAGE_TO_TARGET_VALIDATION','N','Dangling key check for data in staging tables: Possible values are Y to perform dangling key validation, N to skip dangling key validation',v_version
               ,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 600


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'SYS_PARAM','DDR_WS_FILE_PATH',NULL,'Complete directory path for output files location',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 606


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'SYS_PARAM','DFLT_GLBL_LOC_ID_TYP',NULL,'Default Global Location ID Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 612


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'SYS_PARAM','DFLT_ADDR_TYP_CD',NULL,'Default Address Type Code',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 618


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'SYS_PARAM','DFLT_PRMRY_CRNCY_CD',NULL,'Default Primary Currency Code',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 624


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'SYS_PARAM','DFLT_SRC_SYS_IDNT','-1','Default Source System Identifier',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 630


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'SYS_PARAM','DFLT_BSNS_UNIT_TYP',NULL,'Default Business Unit Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 637


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'TIME_LVL','DAY','Day','Day',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 643


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'TIME_LVL','MONTH','Month','Month',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 649


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'TIME_LVL','NA','Not Applicable','Not Applicable',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 655


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'TIME_LVL','QUARTER','Quarter','Quarter',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 661


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'TIME_LVL','WEEK','Week','Week',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 667


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'TIME_LVL','YEAR','Year','Year',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 673


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'PRMTN_FLAG','Y','Promotion','Promotion Sales',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 679


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'PRMTN_FLAG','N','Regular','Non Promotion Sales',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 685


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'SYS_PARAM','RETL_DSR_SRC_DIR',NULL,'Directory location for the data file',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 691


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'SYS_PARAM','RETL_DSR_SRC_FILENAME',NULL,'Name of the data file',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 697


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'SYS_PARAM','RETL_DSR_SUCCESS_DIR',NULL,'Archive directory for data file after successful data load',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 703


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'SYS_PARAM','RETL_DSR_FAILED_DIR',NULL,'Archive directory for data file if data load fails',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 709


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'SYS_PARAM','RETL_DSR_TO_ADDR',NULL,'To email address for process notifications',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 715


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'SYS_PARAM','RETL_DSR_FM_ADDR',NULL,'From email address for process notifications',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 721


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'SYS_PARAM','RETL_DSR_MAIL_SERVER',NULL,'Email server for process notifications',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 727


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'SYS_PARAM','RETL_DSR_CLASS_DIR',NULL,'Directory location for java class files used for RMS integration',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 733


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'ITM_TYP','M','Manufacturer Item','Item from manufacturer item hierarchy',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 739


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'ITM_TYP','C','Competitor Item','Item from competitor item hierarchy',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 746


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'EXCPTN_TYP','FCSTACC','Sales Forecast Accuracy','Sales Forecast Accuracy',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 752


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'EXCPTN_TYP','IFPL','In-flight Promotional Lift','In-flight Promotional Lift',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 758


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'EXCPTN_TYP','NPISALES','New Item Not Selling','New Item Not Selling',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 764


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'EXCPTN_TYP','OOSIM','Out of Stock Imputed','Out of Stock Imputed',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 770


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'EXCPTN_TYP','OOSOH','Out of Stock On Hand','Out of Stock On Hand',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 776


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'EXCPTN_TYP','OVRSTCK','Overstock','Overstock',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 783


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'EXCPTN_TYP','PPD','Promotional Price','Promotional Price',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 790


        INSERT  (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES (p_mfg_org,'EXCPTN_TYP','REORDR','Reorder Point','Reorder Point',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 796


				INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
				VALUES (p_mfg_org,'FRCST_TYP','BASE','BASE','BASE',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 802


				INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
				VALUES (p_mfg_org,'FRCST_TYP','PROMO','PROMO','PROMO',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 808


				INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
				VALUES (p_mfg_org,'FRCST_TYP','TOTAL','TOTAL','TOTAL',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 814


				INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
				VALUES (p_mfg_org,'FRCST_PURP','SALES','SALES','SALES',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 820


				INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
				VALUES (p_mfg_org,'FRCST_PURP','ORDERS','ORDERS','ORDERS',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 826


				INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
				VALUES (p_mfg_org,'FRCST_PURP','SHIPMENT','SHIPMENT','SHIPMENT',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 832


				INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
				VALUES (p_mfg_org,'FRCST_PURP','RECEIPTS','RECEIPTS','RECEIPTS',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 838


				INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
				VALUES (p_mfg_org,'SLS_TYP','1','Manufacturer Promoted','POS Sales that were identified by the customer as promotional sales and have been associated to a manufacturer promotion',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 844


				INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
				VALUES (p_mfg_org,'SLS_TYP','2','Manufacturer Non Compliant',
				        'POS Sales that were identified by the customer as regular (non-promotional) sales but according to the manufacturer promotion plan criteria should have been promoted',
				        v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 852


				INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
				VALUES (p_mfg_org,'SLS_TYP','3','Other Promoted','POS Sales that were identified by the customer as promotional sales but there is no associated manufacturer promotion',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 858


				INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
				VALUES (p_mfg_org,'SLS_TYP','4','Regular','POS Sales that were identified by the customer as regular (non-promotional) sales and there is no associated manufacturer promotion',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 864


        INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
                ,last_update_login)
        VALUES (p_mfg_org,'HCHY_TYPE','MFG_ITEM','Manufacturer Item Hierarchy','Manufacturer Item Hierarchy',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 871


        INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
                ,last_update_login)
        VALUES (p_mfg_org,'HCHY_TYPE','RTL_ITEM','Retailer Item Hierarchy','Retailer Item Hierarchy',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 878


        INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
                ,last_update_login)
        VALUES (p_mfg_org,'HCHY_TYPE','ORG','Organization Hierarchy','Organization Hierarchy',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 885


        INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
                ,last_update_login)
        VALUES (p_mfg_org,'HCHY_LVL','CMPNY','Company','Company',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 892


        INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
                ,last_update_login)
        VALUES (p_mfg_org,'HCHY_LVL','DIV','Division','Division',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 899


        INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
                ,last_update_login)
        VALUES (p_mfg_org,'HCHY_LVL','CLASS','Class','Class',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 906


        INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
                ,last_update_login)
        VALUES (p_mfg_org,'HCHY_LVL','SBC','Sub-Class','Sub-Class',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 913


        INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
                ,last_update_login)
        VALUES (p_mfg_org,'HCHY_LVL','GRP','Group','Group',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 920


        INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
                ,last_update_login)
        VALUES (p_mfg_org,'HCHY_LVL','ITEM','Item','Item',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 927


        INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
                ,last_update_login)
        VALUES (p_mfg_org,'HCHY_LVL','DEPT','Department','Department',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 934


        INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
                ,last_update_login)
        VALUES (p_mfg_org,'HCHY_LVL','CHAIN','Chain','Chain',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 941


        INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
                ,last_update_login)
        VALUES (p_mfg_org,'HCHY_LVL','AREA','Area','Area',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 948


        INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
                ,last_update_login)
        VALUES (p_mfg_org,'HCHY_LVL','RGN','Region','Region',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 955


        INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
                ,last_update_login)
        VALUES (p_mfg_org,'HCHY_LVL','DSTRCT','District','District',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 968


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
       ('MFG_CLASS_CD', 'ITEM', 'Item Class', 4, NULL,
        'Y', 'Y', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 979


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
       ('MFG_SBC_CD', 'ITEM', 'Item SubClass', 3, NULL,
        'Y', 'Y', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 990


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
       ('MFG_ITEM_NBR', 'ITEM', 'Item Number', 2, NULL,
        'Y', 'N', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 1001


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
       ('MFG_SKU_ITEM_NBR', 'ITEM', 'Sku Item Number', 1, NULL,
        'Y', 'Y', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 1012


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
       ('MFG_DIV_CD', 'ITEM', 'Item Division', 6, NULL,
        'Y', 'N', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 1023


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
       ('MFG_GRP_CD', 'ITEM', 'Item Group', 5, NULL,
        'Y', 'N', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 1034


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
       ('CLSTR_CD', 'ORGANIZATION', 'Organization Retail Cluster', 7, NULL,
        'Y', 'N', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 1045


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
       ('ORG_CD', 'ORGANIZATION', 'Organization Retail Org', 6, NULL,
        'Y', 'N', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 1056


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
       ('CHAIN_CD', 'ORGANIZATION', 'Organization Retail Chain', 5, NULL,
        'Y', 'N', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 1067


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
       ('AREA_CD', 'ORGANIZATION', 'Organization Retail Area', 4, NULL,
        'N', 'N', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 1078


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
       ('RGN_CD', 'ORGANIZATION', 'Organization Retail Region', 3, NULL,
        'N', 'N', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 1089


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
       ('DSTRCT_CD', 'ORGANIZATION', 'Organization Retail District', 2, NULL,
        'N', 'N', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 1100


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
       ('BSNS_UNIT_CD', 'ORGANIZATION', 'Organization Retail Bus. Unit', 1, NULL,
        'N', 'N', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 1111


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
       ('INV_LOC_CD', 'ORGANIZATION', 'Organization Inventory Level', 0, NULL,
        'Y', 'N', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 1122


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
       ('CNTRY_CD', 'LOCATION', 'Location Country', 3, NULL,
        'N', 'N', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 1133


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
       ('STATE_CD', 'LOCATION', 'Location State', 2, NULL,
        'N', 'N', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 1144


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
       ('CITY_CD', 'LOCATION', 'Location City', 1, NULL,
        'N', 'N', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 1155


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
       ('CLNDR_YR_CD', 'GREGORIAN TIME', 'Calander Year', 5, NULL,
        'Y', 'N', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 1166


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
       ('CLNDR_QTR_CD', 'GREGORIAN TIME', 'Calander Quarter', 4, NULL,
        'Y', 'N', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 1177


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
       ('CLNDR_MNTH_CD', 'GREGORIAN TIME', 'Calander Month', 3, NULL,
        'Y', 'N', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 1188


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
       ('CLNDR_WK_CD', 'GREGORIAN TIME', 'Calander Week', 2, NULL,
        'Y', 'N', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 1199


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
       ('CLNDR_DAY_CD', 'GREGORIAN TIME', 'Calander Day', 1, NULL,
        'Y', 'Y', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 1210


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
       ('BSNS_YR_CD', 'BUSINESS TIME', 'Business Year', 5, NULL,
        'Y', 'N', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 1221


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
       ('BSNS_QTR_CD', 'BUSINESS TIME', 'Business Quarter', 4, NULL,
        'Y', 'N', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 1232


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
       ('BSNS_MNTH_CD', 'BUSINESS TIME', 'Business Month', 3, NULL,
        'Y', 'N', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 1243


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
       ('BSNS_DAY_CD', 'BUSINESS TIME', 'Business Day', 1, NULL,
        'Y', 'N', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 1254


        INSERT
        (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
        VALUES
        ('BSNS_WK_CD', 'BUSINESS TIME', 'Business Week', 2, 1,
        'Y', 'Y', -1, SYSDATE, '-1',
        SYSDATE, '-1', v_version, SYSDATE, '-1',
        '-1');

Line: 1269


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('ADDR_TYP','Address Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1276


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('BRND','Item Brand',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1283


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('BSNS_UNIT_TYP','Business Unit Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1290


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('CHNL_TYP','Channel Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1297


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('COATING','Coating Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1304


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('COLOR','Color',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1311


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('DYE','Dye',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1318


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('ERR','Error',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1325


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('FABRIC','Fabric',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1332


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('FIBER','Fiber',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1339


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('GIID_TYP','GIID Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1346


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('GLID_TYP','GLID Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1353


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('MEASURE','Measure Name',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1360


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('MEASURE_TYP','Measure Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1367


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('MFG_ITEM_LVL','Mfg Item Level Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1374


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('ORG_LVL','Organization Level',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1381


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('ORG_TYP','Organization Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1388


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('RPLNSHMNT_TYP','Replenishment Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1395


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('RTL_ITEM_LVL','Retailer Item Level',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1402


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('RTL_TYP','Retail Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1409


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('SKU_ITEM_STYLE','SKU Item Style',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1416


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('SKU_ITEM_TYP','SKU Item Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1423


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('SLNG_LOC_TYP','Selling Location Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1430


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('STCK_ITEM_TYP','Stock Item Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1437


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('SYS_PARAM','System Parameter',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1444


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('SZ_TYP','Size Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1451


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('TIME_LVL','Time Level',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1458


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('VRTY_TYP','Variety Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1465


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('WEAVE','Weave Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1472


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('PRMTN_FLAG','Promotion Flag',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1479


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('MKT_AREA_TYP','Market Area Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1486


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('ITM_TYP','Item Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1493


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('EXCPTN_TYP','Exception Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1501


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('STR_ACV_RANGE','Store ACV Range',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1508


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('CMPNY_SIZE','Company Size',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1515


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('SUB_CHNL_TYP','Sub Channel Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1522


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('SRC_TYP','Source Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1529


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('MSR_SET','Measure Set',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1536


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('STR_CLSTR_TYP','Store Cluster Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1543


        INSERT (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
	      VALUES('FRCST_PURP','Forecast Purpose',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1549


	      INSERT (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
	      VALUES('FRCST_TYP','Forecast Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1556


        INSERT
        (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('SLS_TYP','Sales Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1563


        INSERT (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('HCHY_TYPE','Additional Attributed Hierarchy Types',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line: 1569


        INSERT (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
        VALUES ('HCHY_LVL','Additional Attributed Hierarchy Levels',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');