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.

APPS.DDR_SETUP_UTIL SQL Statements

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

Line: 26


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

Line: 36


    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: 46


    DELETE ddr_r_lkup_mst
    WHERE  mfg_org_cd = p_mfg_org;

Line: 49


    INSERT INTO ddr_r_lkup_mst (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: 51


    INSERT INTO ddr_r_lkup_mst (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: 53


    INSERT INTO ddr_r_lkup_mst (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: 55


    INSERT INTO ddr_r_lkup_mst (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: 57


    INSERT INTO ddr_r_lkup_mst (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: 59


    INSERT INTO ddr_r_lkup_mst (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: 61


    INSERT INTO ddr_r_lkup_mst (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: 63


    INSERT INTO ddr_r_lkup_mst (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: 65


    INSERT INTO ddr_r_lkup_mst (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: 67


    INSERT INTO ddr_r_lkup_mst (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: 69


    INSERT INTO ddr_r_lkup_mst (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: 71


    INSERT INTO ddr_r_lkup_mst (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: 73


    INSERT INTO ddr_r_lkup_mst (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: 75


    INSERT INTO ddr_r_lkup_mst (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: 77


    INSERT INTO ddr_r_lkup_mst (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: 79


    INSERT INTO ddr_r_lkup_mst (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: 81


    INSERT INTO ddr_r_lkup_mst (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: 83


    INSERT INTO ddr_r_lkup_mst (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: 85


    INSERT INTO ddr_r_lkup_mst (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: 87


    INSERT INTO ddr_r_lkup_mst (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: 89


    INSERT INTO ddr_r_lkup_mst (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: 91


    INSERT INTO ddr_r_lkup_mst (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: 93


    INSERT INTO ddr_r_lkup_mst (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: 95


    INSERT INTO ddr_r_lkup_mst (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: 97


    INSERT INTO ddr_r_lkup_mst (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: 99


    INSERT INTO ddr_r_lkup_mst (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: 101


    INSERT INTO ddr_r_lkup_mst (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: 103


    INSERT INTO ddr_r_lkup_mst (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: 105


    INSERT INTO ddr_r_lkup_mst (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: 107


    INSERT INTO ddr_r_lkup_mst (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: 109


    INSERT INTO ddr_r_lkup_mst (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: 111


    INSERT INTO ddr_r_lkup_mst (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: 113


    INSERT INTO ddr_r_lkup_mst (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: 115


    INSERT INTO ddr_r_lkup_mst (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: 117


    INSERT INTO ddr_r_lkup_mst (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: 119


    INSERT INTO ddr_r_lkup_mst (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: 121


    INSERT INTO ddr_r_lkup_mst (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: 123


    INSERT INTO ddr_r_lkup_mst (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: 125


    INSERT INTO ddr_r_lkup_mst (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: 127


    INSERT INTO ddr_r_lkup_mst (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: 129


    INSERT INTO ddr_r_lkup_mst (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: 131


    INSERT INTO ddr_r_lkup_mst (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: 133


    INSERT INTO ddr_r_lkup_mst (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: 135


    INSERT INTO ddr_r_lkup_mst (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: 137


    INSERT INTO ddr_r_lkup_mst (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: 139


    INSERT INTO ddr_r_lkup_mst (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: 141


    INSERT INTO ddr_r_lkup_mst (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: 143


    INSERT INTO ddr_r_lkup_mst (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: 145


    INSERT INTO ddr_r_lkup_mst (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: 147


    INSERT INTO ddr_r_lkup_mst (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: 149


    INSERT INTO ddr_r_lkup_mst (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: 151


    INSERT INTO ddr_r_lkup_mst (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: 153


    INSERT INTO ddr_r_lkup_mst (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: 155


    INSERT INTO ddr_r_lkup_mst (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: 157


    INSERT INTO ddr_r_lkup_mst (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: 159


    INSERT INTO ddr_r_lkup_mst (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: 161


    INSERT INTO ddr_r_lkup_mst (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: 163


    INSERT INTO ddr_r_lkup_mst (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: 165


    INSERT INTO ddr_r_lkup_mst (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: 167


    INSERT INTO ddr_r_lkup_mst (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: 169


    INSERT INTO ddr_r_lkup_mst (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: 171


    INSERT INTO ddr_r_lkup_mst (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: 173


    INSERT INTO ddr_r_lkup_mst (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: 175


    INSERT INTO ddr_r_lkup_mst (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: 177


    INSERT INTO ddr_r_lkup_mst (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: 179


    INSERT INTO ddr_r_lkup_mst (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: 181


    INSERT INTO ddr_r_lkup_mst (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: 183


    INSERT INTO ddr_r_lkup_mst (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: 185


    INSERT INTO ddr_r_lkup_mst (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: 187


    INSERT INTO ddr_r_lkup_mst (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: 189


    INSERT INTO ddr_r_lkup_mst (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: 191


    INSERT INTO ddr_r_lkup_mst (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: 193


    INSERT INTO ddr_r_lkup_mst (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: 195


    INSERT INTO ddr_r_lkup_mst (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: 197


    INSERT INTO ddr_r_lkup_mst (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: 199


    INSERT INTO ddr_r_lkup_mst (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: 201


    INSERT INTO ddr_r_lkup_mst (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: 203


    INSERT INTO ddr_r_lkup_mst (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: 205


    INSERT INTO ddr_r_lkup_mst (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: 207


    INSERT INTO ddr_r_lkup_mst (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: 209


    INSERT INTO ddr_r_lkup_mst (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: 211


    INSERT INTO ddr_r_lkup_mst (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: 213


    INSERT INTO ddr_r_lkup_mst (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: 216


    INSERT INTO ddr_r_lkup_mst (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: 219


    INSERT INTO ddr_r_lkup_mst (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: 221


    INSERT INTO ddr_r_lkup_mst (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: 224


    INSERT INTO ddr_r_lkup_mst (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: 226


    INSERT INTO ddr_r_lkup_mst (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: 228


    INSERT INTO ddr_r_lkup_mst (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: 230


    INSERT INTO ddr_r_lkup_mst (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: 232


    INSERT INTO ddr_r_lkup_mst (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: 234


    INSERT INTO ddr_r_lkup_mst (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: 236


    INSERT INTO ddr_r_lkup_mst (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: 238


    INSERT INTO ddr_r_lkup_mst (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: 240


    INSERT INTO ddr_r_lkup_mst (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: 243


    INSERT INTO ddr_r_lkup_mst (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: 245


    INSERT INTO ddr_r_lkup_mst (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: 247


    INSERT INTO ddr_r_lkup_mst (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: 249


    INSERT INTO ddr_r_lkup_mst (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: 251


    INSERT INTO ddr_r_lkup_mst (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: 253


    INSERT INTO ddr_r_lkup_mst (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: 255


    INSERT INTO ddr_r_lkup_mst (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: 257


    INSERT INTO ddr_r_lkup_mst (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: 260


    INSERT INTO ddr_r_lkup_mst (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: 262


    INSERT INTO ddr_r_lkup_mst (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: 268


    DELETE ddr_ws_metadata;

Line: 270


    INSERT INTO ddr_ws_metadata
    (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: 277


    INSERT INTO ddr_ws_metadata
    (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: 284


    INSERT INTO ddr_ws_metadata
    (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: 291


    INSERT INTO ddr_ws_metadata
    (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: 298


    INSERT INTO ddr_ws_metadata
    (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: 305


    INSERT INTO ddr_ws_metadata
    (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: 312


    INSERT INTO ddr_ws_metadata
    (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: 319


    INSERT INTO ddr_ws_metadata
    (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: 326


    INSERT INTO ddr_ws_metadata
    (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: 333


    INSERT INTO ddr_ws_metadata
    (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: 340


    INSERT INTO ddr_ws_metadata
    (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: 347


    INSERT INTO ddr_ws_metadata
    (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: 354


    INSERT INTO ddr_ws_metadata
    (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: 361


    INSERT INTO ddr_ws_metadata
    (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: 368


    INSERT INTO ddr_ws_metadata
    (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: 375


    INSERT INTO ddr_ws_metadata
    (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: 382


    INSERT INTO ddr_ws_metadata
    (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: 389


    INSERT INTO ddr_ws_metadata
    (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: 396


    INSERT INTO ddr_ws_metadata
    (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: 403


    INSERT INTO ddr_ws_metadata
    (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: 410


    INSERT INTO ddr_ws_metadata
    (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: 417


    INSERT INTO ddr_ws_metadata
    (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: 424


    INSERT INTO ddr_ws_metadata
    (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: 431


    INSERT INTO ddr_ws_metadata
    (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: 438


    INSERT INTO ddr_ws_metadata
    (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: 445


    INSERT INTO ddr_ws_metadata
    (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: 452


    INSERT INTO ddr_ws_metadata
    (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: 463


    DELETE ddr_r_lkup_typ;

Line: 464


    INSERT INTO ddr_r_lkup_typ
    (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: 467


    INSERT INTO ddr_r_lkup_typ
    (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: 470


    INSERT INTO ddr_r_lkup_typ
    (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: 473


    INSERT INTO ddr_r_lkup_typ
    (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: 476


    INSERT INTO ddr_r_lkup_typ
    (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: 479


    INSERT INTO ddr_r_lkup_typ
    (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: 482


    INSERT INTO ddr_r_lkup_typ
    (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: 485


    INSERT INTO ddr_r_lkup_typ
    (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: 488


    INSERT INTO ddr_r_lkup_typ
    (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: 491


    INSERT INTO ddr_r_lkup_typ
    (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: 494


    INSERT INTO ddr_r_lkup_typ
    (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: 497


    INSERT INTO ddr_r_lkup_typ
    (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: 500


    INSERT INTO ddr_r_lkup_typ
    (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: 503


    INSERT INTO ddr_r_lkup_typ
    (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: 506


    INSERT INTO ddr_r_lkup_typ
    (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: 509


    INSERT INTO ddr_r_lkup_typ
    (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: 512


    INSERT INTO ddr_r_lkup_typ
    (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: 515


    INSERT INTO ddr_r_lkup_typ
    (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: 518


    INSERT INTO ddr_r_lkup_typ
    (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: 521


    INSERT INTO ddr_r_lkup_typ
    (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: 524


    INSERT INTO ddr_r_lkup_typ
    (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: 527


    INSERT INTO ddr_r_lkup_typ
    (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: 530


    INSERT INTO ddr_r_lkup_typ
    (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: 533


    INSERT INTO ddr_r_lkup_typ
    (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: 536


    INSERT INTO ddr_r_lkup_typ
    (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: 539


    INSERT INTO ddr_r_lkup_typ
    (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: 542


    INSERT INTO ddr_r_lkup_typ
    (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: 545


    INSERT INTO ddr_r_lkup_typ
    (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: 548


    INSERT INTO ddr_r_lkup_typ
    (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: 551


    INSERT INTO ddr_r_lkup_typ
    (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: 554


    INSERT INTO ddr_r_lkup_typ
    (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: 557


    INSERT INTO ddr_r_lkup_typ
    (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');