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

ORACLE REPORT

e61728c3-7289-450c-a4c4-66a79700916a Newbie
Currently Being Moderated

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 Newbie
    Currently Being Moderated

    hello

     

    can you list the table definition ant the data please

  • 2. Re: ORACLE REPORT
    e61728c3-7289-450c-a4c4-66a79700916a Newbie
    Currently Being Moderated

    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;

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points