2 Replies Latest reply: Sep 8, 2013 2:38 PM by e61728c3-7289-450c-a4c4-66a79700916a RSS

    ORACLE REPORT

    e61728c3-7289-450c-a4c4-66a79700916a

      I have a query for my report which displays the area region and their respective corn and bean units.

      select

      sm_name_level4,

      sm_name_level3,

      sum(decode(crop,'CRN',qty_ordered,0)) corn_units,

      sum(decode(crop, 'CRN',qty_change_1,0)) corn_one_day_change,

      sum(decode(crop, 'CRN',qty_change_7,0)) sev_day_change,

      sum(decode(crop,'BNS',qty_ordered,0)) bean_units,

      sum(decode(crop, 'BNS',qty_change_1,0)) bean_one_day_change,

      sum(decode(crop, 'BNS',qty_change_7,0)) bean_sev_day_change

      from v_oe_employee

      where crop in ('CRN','BNS')

      group by sm_name_level4,

      sm_name_level3,

      crop

      order by

      sm_name_level4,

      sm_name_level3,

      crop;

       

      which gives me results like this:-

      EAST    COASTAL    0    0    0    134

      EAST    COASTAL    1623    0    0    0

      EAST    ILLINOIS    0    0    0    948

      EAST    ILLINOIS    6820    0    0    0

      EAST    MI/IN/KY    0    0    0    597

      EAST    MI/IN/KY    1605    0    0    0

       

      But the result the requiremnt is expecting is :-

      EASTCorn Units1 Day Change7 Day ChangeBean Units1 Day Change7 Day Change
        COASTAL50000000
        ILLINOIS3007510014051601410
        MI/IN/KY500030000
        EAST TOTAL8507510017051601410

       

      WHICH DOES REPEATING AREA like COASTAL with corn and bean seperately.

      Can you please suggest what change I should do to get the results in BOLD AND UNDERLINED

      Thank you

        • 1. Re: ORACLE REPORT
          user8167598

          hello

           

          can you list the table definition ant the data please

          • 2. Re: ORACLE REPORT
            e61728c3-7289-450c-a4c4-66a79700916a

            Sure  Please find the scripts for the tables related and few insert statements for  data .

            I am a new user of the ORACLE FORUM, so sorry If i have any mistakes


            DROP VIEW CO_DEVC.V_OE_EMPLOYEE;

             

            /* Formatted on 7/31/2013 9:51:26 AM (QP5 v5.215.12089.38647) */

            CREATE OR REPLACE FORCE VIEW CO_DEVC.V_OE_EMPLOYEE

            (

               SALES_YEAR,

               SM_NAME,

               AREA,

               SM_NAME_LEVEL2,

               SM_AREA_LEVEL2,

               SM_NAME_LEVEL3,

               SM_AREA_LEVEL3,

               SM_NAME_LEVEL4,

               SM_AREA_LEVEL4,

               ACCOUNT_NUM,

               ACCOUNT_TYPE,

               CROP,

               PRODUCT,

               QTY_ORDERED,

               QTY_CHANGE_1,

               QTY_CHANGE_7

            )

            AS

               (  SELECT vat.sales_year,

                         vat.district_name,

                         vat.district_num,

                         vat.team_name,

                         vat.team_num,

                         vat.area_name,

                         vat.area_num,

                         vat.sm_name_level4,

                         vat.sm_area_level4,

                         vat.account_num,

                         vat.account_type,

                         vat.crop,

                         vat.product,

                         SUM (vat.qty),

                         SUM (

                            CASE

                               WHEN system_date BETWEEN SYSDATE - 1 AND SYSDATE THEN qty

                               ELSE 0

                            END)

                            qty_change_1,

                         SUM (

                            CASE

                               WHEN system_date BETWEEN SYSDATE - 7 AND SYSDATE THEN qty

                               ELSE 0

                            END)

                            qty_change_7

                    FROM v_aud_trans vat, per_account_type pat

                   WHERE     vat.account_type = pat.account_type

                         AND pat.is_active = 'Y'

                         AND pat.is_employee = 'Y'

                         AND pat.is_manageable = 'N'

                         AND source_code = 'OR'

                         AND sales_year = 2013

                GROUP BY vat.sales_year,

                         vat.district_name,

                         vat.district_num,

                         vat.team_name,

                         vat.team_num,

                         vat.area_name,

                         vat.area_num,

                         vat.sm_name_level4,

                         vat.sm_area_level4,

                         vat.account_num,

                         vat.account_type,

                         vat.crop,

                         vat.product

                  HAVING SUM (vat.qty) <> 0);

             

             

            GRANT SELECT ON CO_DEVC.V_OE_EMPLOYEE TO CO_PUBLIC WITH GRANT OPTION;

             

            GRANT SELECT ON CO_DEVC.V_OE_EMPLOYEE TO ROLE_BW_READ_ONLY;

             

            GRANT SELECT ON CO_DEVC.V_OE_EMPLOYEE TO ROLE_CBC_COMPANY;

             

            GRANT SELECT ON CO_DEVC.V_OE_EMPLOYEE TO ROLE_CBC_READONLY_USER;

             

            GRANT SELECT ON CO_DEVC.V_OE_EMPLOYEE TO ROLE_CBR_RPT;

             

            GRANT DELETE, INSERT, SELECT, UPDATE ON CO_DEVC.V_OE_EMPLOYEE TO ROLE_POWER_USER;

             

            GRANT SELECT ON CO_DEVC.V_OE_EMPLOYEE TO ROLE_READONLY_USER;

             

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

             

             

             

            DROP VIEW CO_DEVC.V_AUD_TRANS;

             

            /* Formatted on 8/6/2013 1:05:53 PM (QP5 v5.215.12089.38647) */

            CREATE OR REPLACE FORCE VIEW CO_DEVC.V_AUD_TRANS

            (

               SALES_YEAR,

               AUDIT_NUM,

               SOURCE_CODE,

               SYSTEM_DATE,

               SYSTEM_TIME,

               USER_NAME,

               PRODUCT,

               SDSZ,

               PKG,

               TRTMT,

               LOT,

               CATG,

               SITE,

               BLDG,

               AISLE,

               WEIGHT,

               QTY,

               ACCOUNT_NUM,

               LOAD_NUM,

               TRANSFER_NUM,

               SALES_CODE,

               IS_CONFIRMED,

               DOCUMENT_DATE,

               UNIT_PRICE,

               DISCOUNT,

               DISCOUNT_TYPE,

               NET_PRICE,

               AMOUNT,

               QTY_TYPE,

               REASON_CODE,

               DOCUMENT_NUM,

               FINANCIAL_YEAR,

               FINANCIAL_PERIOD,

               DOCUMENT_REFERENCE,

               COMMENTS,

               DATE_POSTED,

               FINANCIAL_SOURCE_CODE,

               CONFIRMED_DATE,

               CONFIRMED_COMMENTS,

               CROP,

               TRAIT,

               ACCOUNT_TYPE,

               DEALER_ACCOUNT_NUM,

               CUST_NAME_LF,

               CUST_BUSINESS_NAME,

               CUST_ADDRESS_1,

               CUST_ADDRESS_2,

               CUST_CITY,

               CUST_STATE,

               CUST_ZIP,

               CUST_IS_DEALER,

               CUST_IS_EMPLOYEE,

               CUST_IS_RETAIL,

               DISTRICT_NUM,

               DISTRICT_NAME,

               SM_NAME_NUM,

               TEAM_NUM,

               TEAM_NAME,

               AREA_NUM,

               AREA_NAME,

               SM_AREA_LEVEL4,

               SM_NAME_LEVEL4,

               DLR_NAME

            )

            AS

               (SELECT aud_trans.sales_year,

                       aud_trans.audit_num,

                       aud_trans.source_code,

                       aud_trans.system_date,

                       aud_trans.system_time,

                       aud_trans.user_name,

                       aud_trans.product,

                       aud_trans.sdsz,

                       aud_trans.pkg,

                       aud_trans.trtmt,

                       aud_trans.lot,

                       aud_trans.catg,

                       aud_trans.site,

                       aud_trans.bldg,

                       aud_trans.aisle,

                       aud_trans.weight,

                       aud_trans.qty,

                       aud_trans.account_num,

                       aud_trans.load_num,

                       aud_trans.transfer_num,

                       aud_trans.sales_code,

                       aud_trans.is_confirmed,

                       aud_trans.document_date,

                       aud_trans.unit_price,

                       aud_trans.discount,

                       aud_trans.discount_type,

                       aud_trans.net_price,

                       aud_trans.amount,

                       aud_trans.qty_type,

                       aud_trans.reason_code,

                       aud_trans.document_num,

                       aud_trans.financial_year,

                       aud_trans.financial_period,

                       aud_trans.document_reference,

                       aud_trans.comments,

                       aud_trans.date_posted,

                       aud_trans.financial_source_code,

                       aud_trans.confirmed_date,

                       aud_trans.confirmed_comments,

                       ip.crop,

                       ip.trait,

                       vpac.account_type,

                       vpac.dealer_account_num,

                       vpcnc.contact_name_lf,

                       vpac.business_name,

                       vpac.address_1,

                       vpac.address_2,

                       vpac.city,

                       vpac.state,

                       vpac.zip,

                       vpac.is_dealer,

                       vpac.is_employee,

                       vpac.is_retail,

                       vpac.area,

                       vpac.sm_name,

                       vpac.sm_name_num,

                       vpac.sm_area_level2,

                       vpac.sm_name_level2,

                       vpac.sm_area_level3,

                       vpac.sm_name_level3,

                       vpac.sm_area_level4,

                       vpac.sm_name_level4,

                       vpcnd.contact_name

                  FROM aud_trans

                       INNER JOIN itm_product ip

                          ON aud_trans.product = ip.product

                       LEFT OUTER JOIN v_per_account vpac

                          ON     aud_trans.account_num = vpac.account_num

                             AND vpac.contact_type = 'Primary'

                       LEFT OUTER JOIN v_per_contact_names vpcnc

                          ON     aud_trans.account_num = vpcnc.contact_num

                             AND vpcnc.contact_type = 'Primary'

                       LEFT OUTER JOIN v_per_contact_names vpcnd

                          ON     vpac.dealer_account_num = vpcnd.contact_num

                             AND vpcnd.contact_type = 'Primary');

             

             

            GRANT SELECT ON CO_DEVC.V_AUD_TRANS TO CO_PUBLIC WITH GRANT OPTION;

             

            GRANT SELECT ON CO_DEVC.V_AUD_TRANS TO ROLE_BW_READ_ONLY;

             

            GRANT SELECT ON CO_DEVC.V_AUD_TRANS TO ROLE_CBC_COMPANY;

             

            GRANT SELECT ON CO_DEVC.V_AUD_TRANS TO ROLE_CBC_READONLY_USER;

             

            GRANT SELECT ON CO_DEVC.V_AUD_TRANS TO ROLE_CBR_RPT;

             

            GRANT DELETE, INSERT, SELECT, UPDATE ON CO_DEVC.V_AUD_TRANS TO ROLE_POWER_USER;

             

            GRANT SELECT ON CO_DEVC.V_AUD_TRANS TO ROLE_READONLY_USER;

             

             

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

             

             

             

            ALTER TABLE CO_DEVC.AUD_TRANS

            DROP PRIMARY KEY CASCADE;

             

            DROP TABLE CO_DEVC.AUD_TRANS CASCADE CONSTRAINTS;

             

            CREATE TABLE CO_DEVC.AUD_TRANS

            (

              SALES_YEAR             NUMBER(4),

              AUDIT_NUM              NUMBER(8),

              SOURCE_CODE            VARCHAR2(10 BYTE),

              SYSTEM_DATE            DATE,

              SYSTEM_TIME            VARCHAR2(12 BYTE),

              USER_NAME              VARCHAR2(30 BYTE),

              PRODUCT                VARCHAR2(20 BYTE),

              SDSZ                   VARCHAR2(4 BYTE),

              PKG                    VARCHAR2(10 BYTE),

              TRTMT                  VARCHAR2(4 BYTE),

              LOT                    VARCHAR2(20 BYTE),

              CATG                   VARCHAR2(4 BYTE),

              SITE                   VARCHAR2(4 BYTE),

              BLDG                   VARCHAR2(4 BYTE),

              AISLE                  VARCHAR2(10 BYTE),

              WEIGHT                 NUMBER(6,2),

              QTY                    NUMBER(10,2),

              ACCOUNT_NUM            NUMBER(6),

              LOAD_NUM               VARCHAR2(10 BYTE),

              TRANSFER_NUM           NUMBER(8),

              SALES_CODE             VARCHAR2(25 BYTE),

              DOCUMENT_DATE          DATE,

              UNIT_PRICE             NUMBER(8,2),

              DISCOUNT               NUMBER(8,2),

              DISCOUNT_TYPE          VARCHAR2(1 BYTE),

              NET_PRICE              NUMBER(8,2),

              AMOUNT                 NUMBER(12,2),

              QTY_TYPE               VARCHAR2(20 BYTE),

              REASON_CODE            VARCHAR2(10 BYTE),

              DOCUMENT_NUM           NUMBER(8),

              FINANCIAL_YEAR         NUMBER(4),

              FINANCIAL_PERIOD       NUMBER(2),

              DOCUMENT_REFERENCE     VARCHAR2(20 BYTE),

              COMMENTS               VARCHAR2(500 BYTE),

              DATE_POSTED            DATE,

              FINANCIAL_SOURCE_CODE  VARCHAR2(10 BYTE),

              ORDER_SEQUENCE_NUM     NUMBER(4),

              QTY_OE_SHIPPED         NUMBER(10,2),

              QTY_DELIVERED          NUMBER(10,2),

              IS_DELIVERED           VARCHAR2(1 BYTE),

              DATE_DELIVERED         DATE,

              IS_CONFIRMED           VARCHAR2(1 BYTE),

              CONFIRMED_DATE         DATE,

              CONFIRMED_COMMENTS     VARCHAR2(300 BYTE)

            )

            TABLESPACE DEVC_DATA

            PCTUSED    0

            PCTFREE    10

            INITRANS   1

            MAXTRANS   255

            STORAGE    (

                        INITIAL          400M

                        MINEXTENTS       1

                        MAXEXTENTS       UNLIMITED

                        PCTINCREASE      0

                        BUFFER_POOL      DEFAULT

                       )

            LOGGING

            NOCOMPRESS

            NOCACHE

            NOPARALLEL

            MONITORING;

             

            COMMENT ON TABLE CO_DEVC.AUD_TRANS IS 'Audit for orders, backorders, inventory transactions, etc.';

             

            COMMENT ON COLUMN CO_DEVC.AUD_TRANS.DOCUMENT_NUM IS 'Should this be NUM? or VAR?';

             

             

             

            CREATE INDEX CO_DEVC.IDX_AUD_TRANS_ACCT ON CO_DEVC.AUD_TRANS

            (ACCOUNT_NUM)

            LOGGING

            TABLESPACE DEVC_INDEX

            PCTFREE    10

            INITRANS   2

            MAXTRANS   255

            STORAGE    (

                        INITIAL          100M

                        MINEXTENTS       1

                        MAXEXTENTS       UNLIMITED

                        PCTINCREASE      0

                        BUFFER_POOL      DEFAULT

                       )

            NOPARALLEL;

             

             

            CREATE INDEX CO_DEVC.IDX_AUD_TRANS_DATE ON CO_DEVC.AUD_TRANS

            (SALES_YEAR, SYSTEM_DATE, SOURCE_CODE)

            LOGGING

            TABLESPACE DEVC_INDEX

            PCTFREE    10

            INITRANS   2

            MAXTRANS   255

            STORAGE    (

                        INITIAL          150M

                        MINEXTENTS       1

                        MAXEXTENTS       UNLIMITED

                        PCTINCREASE      0

                        BUFFER_POOL      DEFAULT

                       )

            NOPARALLEL;

             

             

            CREATE INDEX CO_DEVC.IDX_AUD_TRANS_FIN_YEAR_PER ON CO_DEVC.AUD_TRANS

            (FINANCIAL_YEAR, FINANCIAL_PERIOD)

            LOGGING

            TABLESPACE DEVC_INDEX

            PCTFREE    10

            INITRANS   2

            MAXTRANS   255

            STORAGE    (

                        INITIAL          150M

                        MINEXTENTS       1

                        MAXEXTENTS       UNLIMITED

                        PCTINCREASE      0

                        BUFFER_POOL      DEFAULT

                       )

            NOPARALLEL;

             

             

            CREATE INDEX CO_DEVC.IDX_AUD_TRANS_PRODUCT ON CO_DEVC.AUD_TRANS

            (PRODUCT)

            LOGGING

            TABLESPACE DEVC_INDEX

            PCTFREE    10

            INITRANS   2

            MAXTRANS   255

            STORAGE    (

                        INITIAL          120M

                        MINEXTENTS       1

                        MAXEXTENTS       UNLIMITED

                        PCTINCREASE      0

                        BUFFER_POOL      DEFAULT

                       )

            NOPARALLEL;

             

             

            CREATE INDEX CO_DEVC.IDX_AUD_TRANS_SITE ON CO_DEVC.AUD_TRANS

            (SITE)

            LOGGING

            TABLESPACE DEVC_INDEX

            PCTFREE    10

            INITRANS   2

            MAXTRANS   255

            STORAGE    (

                        INITIAL          40M

                        MINEXTENTS       1

                        MAXEXTENTS       UNLIMITED

                        PCTINCREASE      0

                        BUFFER_POOL      DEFAULT

                       )

            NOPARALLEL;

             

             

            CREATE INDEX CO_DEVC.IDX_AUD_TRANS_SOURCE ON CO_DEVC.AUD_TRANS

            (SOURCE_CODE)

            LOGGING

            TABLESPACE DEVC_INDEX

            PCTFREE    10

            INITRANS   2

            MAXTRANS   255

            STORAGE    (

                        INITIAL          90M

                        MINEXTENTS       1

                        MAXEXTENTS       UNLIMITED

                        PCTINCREASE      0

                        BUFFER_POOL      DEFAULT

                       )

            NOPARALLEL;

             

             

            CREATE INDEX CO_DEVC.IDX_AUD_TRANS_YEAR_PROD_PKG_SC ON CO_DEVC.AUD_TRANS

            (SALES_YEAR, PRODUCT, PKG, SOURCE_CODE)

            LOGGING

            TABLESPACE DEVC_INDEX

            PCTFREE    10

            INITRANS   2

            MAXTRANS   255

            STORAGE    (

                        INITIAL          190M

                        MINEXTENTS       1

                        MAXEXTENTS       UNLIMITED

                        PCTINCREASE      0

                        BUFFER_POOL      DEFAULT

                       )

            NOPARALLEL;

             

             

            CREATE UNIQUE INDEX CO_DEVC.PK_AUD_TRANS ON CO_DEVC.AUD_TRANS

            (AUDIT_NUM)

            LOGGING

            TABLESPACE DEVC_INDEX

            PCTFREE    10

            INITRANS   2

            MAXTRANS   255

            STORAGE    (

                        INITIAL          100M

                        MINEXTENTS       1

                        MAXEXTENTS       UNLIMITED

                        PCTINCREASE      0

                        BUFFER_POOL      DEFAULT

                       )

            NOPARALLEL;

             

             

            ALTER TABLE CO_DEVC.AUD_TRANS ADD (

              CONSTRAINT PK_AUD_TRANS

              PRIMARY KEY

              (AUDIT_NUM)

              USING INDEX CO_DEVC.PK_AUD_TRANS

              ENABLE VALIDATE);

             

            GRANT SELECT ON CO_DEVC.AUD_TRANS TO CO_PUBLIC WITH GRANT OPTION;

             

            GRANT SELECT ON CO_DEVC.AUD_TRANS TO ROLE_BW_READ_ONLY;

             

            GRANT INSERT, SELECT, UPDATE ON CO_DEVC.AUD_TRANS TO ROLE_CBC_COMPANY;

             

            GRANT SELECT ON CO_DEVC.AUD_TRANS TO ROLE_CBC_READONLY_USER;

             

            GRANT SELECT ON CO_DEVC.AUD_TRANS TO ROLE_CBR_RPT;

             

            GRANT DELETE, INSERT, SELECT, UPDATE ON CO_DEVC.AUD_TRANS TO ROLE_POWER_USER;

             

            GRANT SELECT ON CO_DEVC.AUD_TRANS TO ROLE_READONLY_USER;

             

             

             

             

             

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

             

             

            SET DEFINE OFF;

            Insert into CO_DEVC.V_OE_EMPLOYEE

               (SALES_YEAR, SM_NAME, AREA, SM_NAME_LEVEL2, SM_AREA_LEVEL2,

                SM_NAME_LEVEL3, SM_AREA_LEVEL3, SM_NAME_LEVEL4, SM_AREA_LEVEL4, ACCOUNT_NUM,

                ACCOUNT_TYPE, CROP, PRODUCT, QTY_ORDERED, QTY_CHANGE_1,

                QTY_CHANGE_7)

            Values

               (2013, 'Rohrbach, David', 97, 'Rohrbach, David', 18,

                'COASTAL', 1, 'EAST', 1, 9001,

                'ABM', 'CRN', '214-12R', 200, 0,

                0);

            Insert into CO_DEVC.V_OE_EMPLOYEE

               (SALES_YEAR, SM_NAME, AREA, SM_NAME_LEVEL2, SM_AREA_LEVEL2,

                SM_NAME_LEVEL3, SM_AREA_LEVEL3, SM_NAME_LEVEL4, SM_AREA_LEVEL4, ACCOUNT_NUM,

                ACCOUNT_TYPE, CROP, PRODUCT, QTY_ORDERED, QTY_CHANGE_1,

                QTY_CHANGE_7)

            Values

               (2013, 'Open3 - (Open)', 54, 'Pieper, Mark', 23,

                'NEBRASKA', 8, 'WEST', 2, 54001,

                'DSM', 'CRN', '207-02VT2PRIB', 11, 0,

                0);

            Insert into CO_DEVC.V_OE_EMPLOYEE

               (SALES_YEAR, SM_NAME, AREA, SM_NAME_LEVEL2, SM_AREA_LEVEL2,

                SM_NAME_LEVEL3, SM_AREA_LEVEL3, SM_NAME_LEVEL4, SM_AREA_LEVEL4, ACCOUNT_NUM,

                ACCOUNT_TYPE, CROP, PRODUCT, QTY_ORDERED, QTY_CHANGE_1,

                QTY_CHANGE_7)

            Values

               (2013, 'Cummings, Bob', 123, 'Rogers, Ted', 14,

                'MO/KS/CO', 5, 'WEST', 2, 284758,

                'DSM', 'CRN', '197-30R', 17, 0,

                0);

            Insert into CO_DEVC.V_OE_EMPLOYEE

               (SALES_YEAR, SM_NAME, AREA, SM_NAME_LEVEL2, SM_AREA_LEVEL2,

                SM_NAME_LEVEL3, SM_AREA_LEVEL3, SM_NAME_LEVEL4, SM_AREA_LEVEL4, ACCOUNT_NUM,

                ACCOUNT_TYPE, CROP, PRODUCT, QTY_ORDERED, QTY_CHANGE_1,

                QTY_CHANGE_7)

            Values

               (2013, 'Guderyon, Greg', 259, 'Boeke, Greg (Open)', 6,

                'ILLINOIS', 2, 'EAST', 1, 368492,

                'DSM', 'CRN', '202-29', 50, 0,

                0);

            Insert into CO_DEVC.V_OE_EMPLOYEE

               (SALES_YEAR, SM_NAME, AREA, SM_NAME_LEVEL2, SM_AREA_LEVEL2,

                SM_NAME_LEVEL3, SM_AREA_LEVEL3, SM_NAME_LEVEL4, SM_AREA_LEVEL4, ACCOUNT_NUM,

                ACCOUNT_TYPE, CROP, PRODUCT, QTY_ORDERED, QTY_CHANGE_1,

                QTY_CHANGE_7)

            Values

               (2013, 'Portz, Marcus', 155, 'Graf, Matt', 19,

                'MN/WI', 7, 'WEST', 2, 373198,

                'DSM', 'CRN', '202-32STXRIB', 36, 0,

                0);

            Insert into CO_DEVC.V_OE_EMPLOYEE

               (SALES_YEAR, SM_NAME, AREA, SM_NAME_LEVEL2, SM_AREA_LEVEL2,

                SM_NAME_LEVEL3, SM_AREA_LEVEL3, SM_NAME_LEVEL4, SM_AREA_LEVEL4, ACCOUNT_NUM,

                ACCOUNT_TYPE, CROP, PRODUCT, QTY_ORDERED, QTY_CHANGE_1,

                QTY_CHANGE_7)

            Values

               (2013, 'Williams, Brandon', 403, 'Overton, Kerry', 2,

                'MI/IN/KY', 3, 'EAST', 1, 609026,

                'DSM', 'CRN', '217-08VT3PRIB', 198, 0,

                0);

            Insert into CO_DEVC.V_OE_EMPLOYEE

               (SALES_YEAR, SM_NAME, AREA, SM_NAME_LEVEL2, SM_AREA_LEVEL2,

                SM_NAME_LEVEL3, SM_AREA_LEVEL3, SM_NAME_LEVEL4, SM_AREA_LEVEL4, ACCOUNT_NUM,

                ACCOUNT_TYPE, CROP, PRODUCT, QTY_ORDERED, QTY_CHANGE_1,

                QTY_CHANGE_7)

            Values

               (2013, 'Wilson, Greg', 399, 'Overton, Kerry', 2,

                'MI/IN/KY', 3, 'EAST', 1, 612475,

                'PROMO', 'CRN', '213-40VT3PRIB', 29, 0,

                0);

            Insert into CO_DEVC.V_OE_EMPLOYEE

               (SALES_YEAR, SM_NAME, AREA, SM_NAME_LEVEL2, SM_AREA_LEVEL2,

                SM_NAME_LEVEL3, SM_AREA_LEVEL3, SM_NAME_LEVEL4, SM_AREA_LEVEL4, ACCOUNT_NUM,

                ACCOUNT_TYPE, CROP, PRODUCT, QTY_ORDERED, QTY_CHANGE_1,

                QTY_CHANGE_7)

            Values

               (2013, 'Oliver, Jim', 461, 'Cunningham, Jeff', 1,

                'OH/NORTHEAST', 4, 'EAST', 1, 629881,

                'DSM', 'BNS', '5606R2/STS', 10, 0,

                0);

            Insert into CO_DEVC.V_OE_EMPLOYEE

               (SALES_YEAR, SM_NAME, AREA, SM_NAME_LEVEL2, SM_AREA_LEVEL2,

                SM_NAME_LEVEL3, SM_AREA_LEVEL3, SM_NAME_LEVEL4, SM_AREA_LEVEL4, ACCOUNT_NUM,

                ACCOUNT_TYPE, CROP, PRODUCT, QTY_ORDERED, QTY_CHANGE_1,

                QTY_CHANGE_7)

            Values

               (2013, 'Oliver, Jim', 461, 'Cunningham, Jeff', 1,

                'OH/NORTHEAST', 4, 'EAST', 1, 629881,

                'DSM', 'BNS', '4806R2/STS', 280, 0,

                0);

            COMMIT;