bdemobld.sql Demo Table Script for Practice

bdemobld.sql   -- Demo Table Script for Practice...


DROP VIEW SALES;
DROP TABLE ITEM;
DROP TABLE SALES_ORDER;
DROP TABLE CUSTOMER;
DROP TABLE PRICE;
DROP TABLE PRODUCT;
DROP TABLE SALARY_GRADE;
DROP TABLE EMPLOYEE;
DROP TABLE JOB;
DROP TABLE DEPARTMENT;
DROP TABLE LOCATION;

REM Create new datasources

CREATE TABLE LOCATION (
        LOCATION_ID             NUMBER(3),
        REGIONAL_GROUP          VARCHAR2(20));

CREATE TABLE DEPARTMENT (
        DEPARTMENT_ID           NUMBER(2),
        NAME                    VARCHAR2(14),
        LOCATION_ID             NUMBER(3));

CREATE TABLE JOB (
        JOB_ID                  NUMBER(3),
        FUNCTION                VARCHAR2(30));

CREATE TABLE EMPLOYEE (
        EMPLOYEE_ID             NUMBER(4),
        LAST_NAME               VARCHAR2(15),
        FIRST_NAME              VARCHAR2(15),
        MIDDLE_INITIAL          VARCHAR2(1),
        JOB_ID                  NUMBER(3),
        MANAGER_ID              NUMBER(4),
        HIRE_DATE               DATE,
        SALARY                  NUMBER(7,2),
        COMMISSION              NUMBER(7,2),
        DEPARTMENT_ID           NUMBER(2));

CREATE TABLE SALARY_GRADE (
        GRADE_ID                NUMBER(3),
        LOWER_BOUND             NUMBER(7,2),
        UPPER_BOUND             NUMBER(7,2));

CREATE TABLE PRODUCT (
        PRODUCT_ID              NUMBER (6),
        DESCRIPTION             VARCHAR2 (30));

CREATE TABLE PRICE (
        PRODUCT_ID              NUMBER (6),
        LIST_PRICE              NUMBER (8,2),
        MIN_PRICE               NUMBER (8,2),
        START_DATE              DATE,
        END_DATE                DATE);

CREATE TABLE CUSTOMER (
        CUSTOMER_ID             NUMBER (6),
        NAME                    VARCHAR2 (45),
        ADDRESS                 VARCHAR2 (40),
        CITY                    VARCHAR2 (30),
        STATE                   VARCHAR2 (2),
        ZIP_CODE                VARCHAR2 (9),
        AREA_CODE               NUMBER (3),
        PHONE_NUMBER            NUMBER (7),
        SALESPERSON_ID          NUMBER (4),
        CREDIT_LIMIT            NUMBER (9,2),
        COMMENTS                LONG);

CREATE TABLE SALES_ORDER  (
        ORDER_ID                NUMBER (4),
        ORDER_DATE              DATE,
        CUSTOMER_ID             NUMBER (6),
        SHIP_DATE               DATE,
        TOTAL                   NUMBER (8,2));

CREATE TABLE ITEM  (
        ORDER_ID                NUMBER (4),
        ITEM_ID                 NUMBER (4),
        PRODUCT_ID              NUMBER (6),
        ACTUAL_PRICE            NUMBER (8,2),
        QUANTITY                NUMBER (8),
        TOTAL                   NUMBER (8,2));

CREATE VIEW SALES AS
SELECT SALESPERSON_ID, SALES_ORDER.CUSTOMER_ID, CUSTOMER.NAME CUSTOMER,
       PRODUCT.PRODUCT_ID, DESCRIPTION PRODUCT, SUM(ITEM.TOTAL) AMOUNT
FROM SALES_ORDER, ITEM, CUSTOMER, PRODUCT
WHERE SALES_ORDER.ORDER_ID = ITEM.ORDER_ID
AND SALES_ORDER.CUSTOMER_ID = CUSTOMER.CUSTOMER_ID
AND ITEM.PRODUCT_ID = PRODUCT.PRODUCT_ID
GROUP BY SALESPERSON_ID, SALES_ORDER.CUSTOMER_ID, CUSTOMER.NAME,
         PRODUCT.PRODUCT_ID, DESCRIPTION;

REM Grant SELECT privileges to PUBLIC on the datasources

GRANT SELECT ON LOCATION TO PUBLIC;
GRANT SELECT ON DEPARTMENT TO PUBLIC;
GRANT SELECT ON JOB TO PUBLIC;
GRANT SELECT ON EMPLOYEE TO PUBLIC;
GRANT SELECT ON SALARY_GRADE TO PUBLIC;
GRANT SELECT ON PRODUCT TO PUBLIC;
GRANT SELECT ON PRICE TO PUBLIC;
GRANT SELECT ON CUSTOMER TO PUBLIC;
GRANT SELECT ON SALES_ORDER TO PUBLIC;
GRANT SELECT ON ITEM TO PUBLIC;
GRANT SELECT ON SALES TO PUBLIC;

REM Comment the datasources and their columns

COMMENT ON TABLE EMPLOYEE IS 'General information on all corporate employees.';
COMMENT ON COLUMN EMPLOYEE.EMPLOYEE_ID IS 'Employee Number: Unique 4-digit identification number assigned to every employee.';
COMMENT ON COLUMN EMPLOYEE.LAST_NAME IS 'Last name of employee.  Stored in all caps.';
COMMENT ON COLUMN EMPLOYEE.FIRST_NAME IS 'First name of employee.  Stored in all caps.';
COMMENT ON COLUMN EMPLOYEE.MIDDLE_INITIAL IS 'Middle initial (one character only).  Stored in all caps.';
COMMENT ON COLUMN EMPLOYEE.JOB_ID IS 'Job identification number.  See JOB for descriptions.';
COMMENT ON COLUMN EMPLOYEE.MANAGER_ID IS 'Manager: The employee number of this employee''s manager.  If employee has no manager, value should be NULL.';
COMMENT ON COLUMN EMPLOYEE.HIRE_DATE IS 'Date the employee was HIRED, not necessarily the day the employee STARTED.';
COMMENT ON COLUMN EMPLOYEE.SALARY IS 'Monthly salary for the employee in U.S. dollars.  Salary grade information can be found in the table SALARY_GRADE.';
COMMENT ON COLUMN EMPLOYEE.COMMISSION IS 'Commission (in U.S. dollars) earned last month.  This field should be NULL for non-commissioned employees.';
COMMENT ON COLUMN EMPLOYEE.DEPARTMENT_ID IS 'Employee''s department number.  Further department information is available in the table DEPT.';

COMMENT ON TABLE JOB IS 'All valid job categories for personnel information.';
COMMENT ON COLUMN JOB.JOB_ID IS 'Unique 3-digit code for job function and title.';
COMMENT ON COLUMN JOB.FUNCTION IS 'Generic function class of job.';

COMMENT ON TABLE DEPARTMENT IS 'Department information for all U.S. operations.';
COMMENT ON COLUMN DEPARTMENT.DEPARTMENT_ID IS 'Department number: Unique 2-digit department number assigned to each department.';
COMMENT ON COLUMN DEPARTMENT.NAME IS 'Department name: Only the first 14 characters of a department name can be stored in the database.  Storing names in all caps is recommended but not required.';
COMMENT ON COLUMN DEPARTMENT.LOCATION_ID IS 'Department location: The code for where the department''s central office is located.  (LOCATION)';

COMMENT ON TABLE LOCATION IS 'Location information for all U.S. departments and warehouses.';
COMMENT ON COLUMN LOCATION.LOCATION_ID IS 'Central location corporate location code.';
COMMENT ON COLUMN LOCATION.REGIONAL_GROUP IS 'Metropolitan center closest to location.';

COMMENT ON TABLE SALARY_GRADE IS 'Salary grade levels.  Used to classify monthly salary information in U.S. dollars, as found in EMP.SAL.';
COMMENT ON COLUMN SALARY_GRADE.GRADE_ID IS 'Number used to grade salaries.  Higher salary grade numbers denote higher salaries.';
COMMENT ON COLUMN SALARY_GRADE.LOWER_BOUND IS 'The lowest monthly salary (rounded to the nearest U.S. dollar) that applies to a particular salary grade. (i.e. the condition ROUND(EMP.SAL) >= LOWER_BOUND must be met.)';
COMMENT ON COLUMN SALARY_GRADE.UPPER_BOUND IS 'The highest monthly salary (rounded to the nearest U.S. dollar) that applies to a particular salary grade. (i.e. the condition ROUND(EMP.SAL) <= UPPER_BOUND must be met.)';

COMMENT ON TABLE PRODUCT IS 'Products in catalog.  Pricing information can be found in table PRICE.';
COMMENT ON COLUMN PRODUCT.PRODUCT_ID IS 'Unique 6 digit number assigned to all products.  Number generated by sequence PRODUCT_ID.';
COMMENT ON COLUMN PRODUCT.DESCRIPTION IS 'Full product name (up to 30 characters).  Storing product names in all caps is recommended but not required.';

COMMENT ON TABLE PRICE IS 'Prices (both standard and minimum) of products.  Database tracks both effective dates and expiration dates for prices.';
COMMENT ON COLUMN PRICE.PRODUCT_ID IS 'Product number to which price applies.  Product name found in table PRICE.';
COMMENT ON COLUMN PRICE.LIST_PRICE IS 'Undiscounted price (in U.S. dollars).';
COMMENT ON COLUMN PRICE.MIN_PRICE IS 'Lowest price (in U.S. dollars) that can be offered.';
COMMENT ON COLUMN PRICE.START_DATE IS 'Date which standard and minimum prices go into effect.';
COMMENT ON COLUMN PRICE.END_DATE IS 'Date which standard and minimum price expire.  This value can be left NULL.';

COMMENT ON TABLE CUSTOMER IS 'Information on all U.S. customers and prospective customers.';
COMMENT ON COLUMN CUSTOMER.CUSTOMER_ID IS 'Unique 6 digit number assigned to all customers.  Number generated by the sequence CUSTOMER_ID.';
COMMENT ON COLUMN CUSTOMER.NAME IS 'Full store name of every customer (up to 45 characters).  Storing names in all caps is recommended but not required.';
COMMENT ON COLUMN CUSTOMER.ADDRESS IS 'Street address of customer.  CITY, STATE, and ZIP_CODE make up the rest of the address.';
COMMENT ON COLUMN CUSTOMER.CITY IS 'City name for address of customer.  Storing city names in all caps is recommended, but not required.';
COMMENT ON COLUMN CUSTOMER.STATE IS 'Two letter abbreviation for state name for address of customer.  Must be entered in all caps.';
COMMENT ON COLUMN CUSTOMER.ZIP_CODE IS 'Zip code of customer.  Supports both 5 and 9 digit zip codes.  Dashes should be omitted from 9 digit zips.';
COMMENT ON COLUMN CUSTOMER.AREA_CODE IS 'Area code of phone number for customer.';
COMMENT ON COLUMN CUSTOMER.PHONE_NUMBER IS 'Phone number of customer.  This field does not supports letters and spaces for mnemonics (7 numeric digits only).';
COMMENT ON COLUMN CUSTOMER.SALESPERSON_ID IS 'Employee number of sales representative handling customer''s account.  Employee information can be found in the EMPLOYEE table.';
COMMENT ON COLUMN CUSTOMER.CREDIT_LIMIT IS 'Credit limit of customer or prospective customer in U.S. dollars.';
COMMENT ON COLUMN CUSTOMER.COMMENTS IS 'Field can be used flexibly.  Suggestions for use include lists of action items or special considerations when dealing with the particular customer.';

COMMENT ON TABLE SALES_ORDER IS 'Sales order for a customer.  Items in the order can be found in the table ITEM.';
COMMENT ON COLUMN SALES_ORDER.ORDER_ID IS 'Unique 4 digit number assigned to all orders.  Number generated by sequence ORDER_ID.';
COMMENT ON COLUMN SALES_ORDER.ORDER_DATE IS 'Date sales order logged (not necessarily when order was fulfilled.)';
COMMENT ON COLUMN SALES_ORDER.CUSTOMER_ID IS 'Customer ordering the goods.  Further information can be found in the table CUSTOMER.';
COMMENT ON COLUMN SALES_ORDER.SHIP_DATE IS 'Date order fulfilled and invoice sent (not necessarily date payment received).';
COMMENT ON COLUMN SALES_ORDER.TOTAL IS 'Total of all items totals in the order.  (i.e. the value of TOTAL for order N should contain: SELECT SUM(TOTAL) FROM ITEM WHERE ORDER_ID=N)';

COMMENT ON TABLE ITEM IS 'Items listed in sales orders.  Product information can be found in table PRODUCT.  Sales order information can be found in table SALES_ORDER.';
COMMENT ON COLUMN ITEM.ORDER_ID IS 'Sales order in which this item appears.  Sales order information can be found in table SALES_ORDER.';
COMMENT ON COLUMN ITEM.ITEM_ID IS 'Number of item within the sales order.';
COMMENT ON COLUMN ITEM.PRODUCT_ID IS 'Number of product (described in PRODUCT) that pertains to the line item.';
COMMENT ON COLUMN ITEM.ACTUAL_PRICE IS 'Price to be paid by the customer in U.S. dollars.  The standard price is PRICE.STANDARD_PRICE, but in some instances, discounts are given to as low as PRICE.MINIMUM_PRICE.';
COMMENT ON COLUMN ITEM.QUANTITY IS 'The amount of product to be ordered in this line item.';
COMMENT ON COLUMN ITEM.TOTAL IS 'The total price (in U.S. dollars) of this line item.  TOTAL = ACTUAL_PRICE * QUANTITY.';

COMMENT ON TABLE SALES IS 'Summary view joining tables SALES_ORDER, ITEM, CUSTOMER, and PRODUCT.  Summarizes the item total grouped by sales representative, customer, and product.  Used by the SALES ORDERS application.';
COMMENT ON COLUMN SALES.SALESPERSON_ID IS 'Employee number of sales representative handling customer''s account.  Employee information can be found in the EMPLOYEE table. (Same as CUSTOMER.SALESPERSON_ID)';
COMMENT ON COLUMN SALES.CUSTOMER_ID IS 'Unique 6 digit number assigned to all customers.  Number generated by the sequence CUSTOMER_ID. (Same as CUSTOMER.CUSTOMER_ID)';
COMMENT ON COLUMN SALES.CUSTOMER IS 'Full store name of every customer (up to 45 characters).  Storing names in all caps is recommended but not required. (Same as CUSTOMER.NAME)';
COMMENT ON COLUMN SALES.PRODUCT_ID IS 'Unique 6 digit number assigned to all products.  Number generated by sequence PRODUCT_ID. (Same as PRODUCT.PRODUCT_ID)';
COMMENT ON COLUMN SALES.PRODUCT IS 'Full product name (up to 30 characters).  Storing product names in all caps is recommended but not required. (Same as PRODUCT.PRODUCT_NAME)';
COMMENT ON COLUMN SALES.AMOUNT IS 'Total sales in (U.S. dollars) of the product sold by the representative to the customer.';

REM Insert Data

INSERT INTO LOCATION VALUES (122, 'NEW YORK');
INSERT INTO LOCATION VALUES (124, 'DALLAS');
INSERT INTO LOCATION VALUES (123, 'CHICAGO');
INSERT INTO LOCATION VALUES (167, 'BOSTON');

INSERT INTO DEPARTMENT VALUES (10,'ACCOUNTING','122');
INSERT INTO DEPARTMENT VALUES (20,'RESEARCH','124');
INSERT INTO DEPARTMENT VALUES (30,'SALES','123');
INSERT INTO DEPARTMENT VALUES (40,'OPERATIONS','167');

INSERT INTO DEPARTMENT VALUES
  ( 12 , 'RESEARCH', '122');

INSERT INTO DEPARTMENT VALUES
  ( 13 , 'SALES', '122');

INSERT INTO DEPARTMENT VALUES
  ( 14 , 'OPERATIONS', '122');

INSERT INTO DEPARTMENT VALUES
  ( 23 , 'SALES', '124');

INSERT INTO DEPARTMENT VALUES
  ( 24 , 'OPERATIONS', '124');

INSERT INTO DEPARTMENT VALUES
  ( 34 , 'OPERATIONS', '123');

INSERT INTO DEPARTMENT VALUES
  ( 43 , 'SALES', '167');

INSERT INTO JOB VALUES (667, 'CLERK');
INSERT INTO JOB VALUES (668, 'STAFF');
INSERT INTO JOB VALUES (669, 'ANALYST');
INSERT INTO JOB VALUES (670, 'SALESPERSON');
INSERT INTO JOB VALUES (671, 'MANAGER');
INSERT INTO JOB VALUES (672, 'PRESIDENT');

INSERT INTO SALARY_GRADE VALUES (1,700,1200);
INSERT INTO SALARY_GRADE VALUES (2,1201,1400);
INSERT INTO SALARY_GRADE VALUES (3,1401,2000);
INSERT INTO SALARY_GRADE VALUES (4,2001,3000);
INSERT INTO SALARY_GRADE VALUES (5,3001,9999);

INSERT INTO EMPLOYEE VALUES
    (7369,'SMITH','JOHN','Q',667,7902,TO_DATE(2446052,'J'),800,NULL,20);
INSERT INTO EMPLOYEE VALUES
    (7499,'ALLEN','KEVIN','J',670,7698,TO_DATE(2446117,'J'),1600,300,30);
INSERT INTO EMPLOYEE VALUES
    (7505,'DOYLE','JEAN','K',671,7839,TO_DATE(2446160,'J'),2850,NULL,13);
INSERT INTO EMPLOYEE VALUES
    (7506,'DENNIS','LYNN','S',671,7839,TO_DATE(2446201,'J'),2750,NULL,23);
INSERT INTO EMPLOYEE VALUES
    (7507,'BAKER','LESLIE','D',671,7839,TO_DATE(2446227,'J'),2200,NULL,14);
INSERT INTO EMPLOYEE VALUES
    (7521,'WARD','CYNTHIA','D',670,7698,TO_DATE(2446119,'J'),1250,500,30);
INSERT INTO EMPLOYEE VALUES
    (7555,'PETERS','DANIEL','T',670,7505,TO_DATE(2446156,'J'),1250,300,13);
INSERT INTO EMPLOYEE VALUES
    (7557,'SHAW','KAREN','P',670,7505,TO_DATE(2446158,'J'),1250,1200,13);
INSERT INTO EMPLOYEE VALUES
    (7560,'DUNCAN','SARAH','S',670,7506,TO_DATE(2446217,'J'),1250,NULL,23);
INSERT INTO EMPLOYEE VALUES
    (7564,'LANGE','GREGORY','J',670,7506,TO_DATE(2446218,'J'),1250,300,23);
INSERT INTO EMPLOYEE VALUES
    (7566,'JONES','TERRY','M',671,7839,TO_DATE(2446158,'J'),2975,NULL,20);
INSERT INTO EMPLOYEE VALUES
    (7569,'ALBERTS','CHRIS','L',671,7839,TO_DATE(2446162,'J'),3000,NULL,12);
INSERT INTO EMPLOYEE VALUES
    (7600,'PORTER','RAYMOND','Y',670,7505,TO_DATE(2446171,'J'),1250,900,13);
INSERT INTO EMPLOYEE VALUES
    (7609,'LEWIS','RICHARD','M',668,7507,TO_DATE(2446172,'J'),1800,NULL,24);
INSERT INTO EMPLOYEE VALUES
    (7654,'MARTIN','KENNETH','J',670,7698,TO_DATE(2446337,'J'),1250,1400,30);
INSERT INTO EMPLOYEE VALUES
    (7676,'SOMMERS','DENISE','D',668,7507,TO_DATE(2446175,'J'),1850,NULL,34);
INSERT INTO EMPLOYEE VALUES
    (7698,'BLAKE','MARION','S',671,7839,TO_DATE(2446187,'J'),2850,NULL,30);
INSERT INTO EMPLOYEE VALUES
    (7782,'CLARK','CAROL','F',671,7839,TO_DATE(2446226,'J'),2450,NULL,10);
INSERT INTO EMPLOYEE VALUES
    (7788,'SCOTT','DONALD','T',669,7566,TO_DATE(2446774,'J'),3000,NULL,20);
INSERT INTO EMPLOYEE VALUES
    (7789,'WEST','LIVIA','N',670,7506,TO_DATE(2446160,'J'),1500,1000,23);
INSERT INTO EMPLOYEE VALUES
    (7799,'FISHER','MATTHEW','G',669,7569,TO_DATE(2446777,'J'),3000,NULL,12);
INSERT INTO EMPLOYEE VALUES
    (7820,'ROSS','PAUL','S',670,7505,TO_DATE(2446218,'J'),1300,800,43);
INSERT INTO EMPLOYEE VALUES
    (7839,'KING','FRANCIS','A',672,NULL,TO_DATE(2446387,'J'),5000,NULL,10);
INSERT INTO EMPLOYEE VALUES
    (7844,'TURNER','MARY','A',670,7698,TO_DATE(2446317,'J'),1500,0,30);
INSERT INTO EMPLOYEE VALUES
    (7876,'ADAMS','DIANE','G',667,7788,TO_DATE(2446808,'J'),1100,NULL,20);
INSERT INTO EMPLOYEE VALUES
    (7900,'JAMES','FRED','S',667,7698,TO_DATE(2446403,'J'),950,NULL,30);
INSERT INTO EMPLOYEE VALUES
    (7902,'FORD','JENNIFER','D',669,7566,TO_DATE(2446403,'J'),3000,NULL,20);
INSERT INTO EMPLOYEE VALUES
    (7916,'ROBERTS','GRACE','M',669,7569,TO_DATE(2446800,'J'),2875,NULL,12);
INSERT INTO EMPLOYEE VALUES
    (7919,'DOUGLAS','MICHAEL','A',667,7799,TO_DATE(2446800,'J'),800,NULL,12);
INSERT INTO EMPLOYEE VALUES
    (7934,'MILLER','BARBARA','M',667,7782,TO_DATE(2446454,'J'),1300,NULL,10);
INSERT INTO EMPLOYEE VALUES
    (7950,'JENSEN','ALICE','B',667,7505,TO_DATE(2446811,'J'),750,NULL,13);
INSERT INTO EMPLOYEE VALUES
    (7954,'MURRAY','JAMES','T',667,7506,TO_DATE(2446812,'J'),750,NULL,23);

INSERT INTO PRICE VALUES
   (100871,4.8,3.2,TO_DATE(2447528,'J'),TO_DATE(2447862,'J'));
INSERT INTO PRICE VALUES
   (100890,58,46.4,TO_DATE(2447528,'J'),NULL);
INSERT INTO PRICE VALUES
   (100890,54,40.5,TO_DATE(2447314,'J'),TO_DATE(2447527,'J'));
INSERT INTO PRICE VALUES
   (100860,35,28,TO_DATE(2448044,'J'),NULL);
INSERT INTO PRICE VALUES
   (100860,32,25.6,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO PRICE VALUES
   (100860,30,24,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (100861,45,36,TO_DATE(2448044,'J'),NULL);
INSERT INTO PRICE VALUES
   (100861,42,33.6,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO PRICE VALUES
   (100861,39,31.2,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (100870,2.8,2.4,TO_DATE(2447893,'J'),NULL);
INSERT INTO PRICE VALUES
   (100870,2.4,1.9,TO_DATE(2447528,'J'),TO_DATE(2447862,'J'));
INSERT INTO PRICE VALUES
   (100871,5.6,4.8,TO_DATE(2447893,'J'),NULL);
INSERT INTO PRICE VALUES
   (101860,24,18,TO_DATE(2447573,'J'),NULL);
INSERT INTO PRICE VALUES
   (101863,12.5,9.4,TO_DATE(2447573,'J'),NULL);
INSERT INTO PRICE VALUES
   (102130,3.4,2.8,TO_DATE(2447757,'J'),NULL);
INSERT INTO PRICE VALUES
   (200376,2.4,1.75,TO_DATE(2448211,'J'),NULL);
INSERT INTO PRICE VALUES
   (200380,4,3.2,TO_DATE(2448211,'J'),NULL);
INSERT INTO PRICE VALUES
   (103120,23.2,18.6,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (103120,24,19.2,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO PRICE VALUES
   (103120,25,20,TO_DATE(2448044,'J'),NULL);
INSERT INTO PRICE VALUES
   (103121,27.8,22.3,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (103121,28.8,23,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO PRICE VALUES
   (103121,30,24,TO_DATE(2448044,'J'),NULL);
INSERT INTO PRICE VALUES
   (103130,4,3.5,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (103130,4.2,3.6,TO_DATE(2447893,'J'),NULL);
INSERT INTO PRICE VALUES
   (103131,4.2,3.6,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (103131,4.5,3.9,TO_DATE(2447893,'J'),NULL);
INSERT INTO PRICE VALUES
   (103140,20,15,TO_DATE(2447573,'J'),NULL);
INSERT INTO PRICE VALUES
   (103141,20,15,TO_DATE(2447573,'J'),NULL);
INSERT INTO PRICE VALUES
   (102132,3.4,2.8,TO_DATE(2447757,'J'),NULL);
INSERT INTO PRICE VALUES
   (104350,40,32,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (104350,42,33.6,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO PRICE VALUES
   (104350,44,35.3,TO_DATE(2448044,'J'),NULL);
INSERT INTO PRICE VALUES
   (104351,23.6,18.9,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (104351,24.8,19.8,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO PRICE VALUES
   (104351,26,20.8,TO_DATE(2448044,'J'),NULL);
INSERT INTO PRICE VALUES
   (104352,50,35,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (104352,54,37.8,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO PRICE VALUES
   (104352,58.3,40.8,TO_DATE(2448044,'J'),NULL);
INSERT INTO PRICE VALUES
   (104360,36,29.5,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (104360,39,32,TO_DATE(2447893,'J'),NULL);
INSERT INTO PRICE VALUES
   (104361,47,33,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (104361,50,35,TO_DATE(2447893,'J'),NULL);
INSERT INTO PRICE VALUES
   (104362,5,4,TO_DATE(2447573,'J'),NULL);
INSERT INTO PRICE VALUES
   (102134,3.4,2.8,TO_DATE(2447757,'J'),NULL);
INSERT INTO PRICE VALUES
   (105123,36.3,29,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (105123,37.7,32,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO PRICE VALUES
   (105123,40,34,TO_DATE(2448044,'J'),NULL);
INSERT INTO PRICE VALUES
   (105124,10,7.6,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (105124,12,9,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO PRICE VALUES
   (105124,15,10,TO_DATE(2448044,'J'),NULL);
INSERT INTO PRICE VALUES
   (105125,2,1.7,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (105125,3,2.6,TO_DATE(2447893,'J'),NULL);
INSERT INTO PRICE VALUES
   (105126,5,4.3,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (105126,6,5,TO_DATE(2447893,'J'),NULL);
INSERT INTO PRICE VALUES
   (105127,6,5,TO_DATE(2448211,'J'),NULL);
INSERT INTO PRICE VALUES
   (105128,10,8,TO_DATE(2448211,'J'),NULL);
INSERT INTO PRICE VALUES
   (102136,3.4,2.8,TO_DATE(2447757,'J'),NULL);

INSERT INTO PRODUCT VALUES ('100860', 'ACE TENNIS RACKET I');
INSERT INTO PRODUCT VALUES ('100861', 'ACE TENNIS RACKET II');
INSERT INTO PRODUCT VALUES ('100870', 'ACE TENNIS BALLS-3 PACK');
INSERT INTO PRODUCT VALUES ('100871', 'ACE TENNIS BALLS-6 PACK');
INSERT INTO PRODUCT VALUES ('100890', 'ACE TENNIS NET');
INSERT INTO PRODUCT VALUES ('101860', 'SP TENNIS RACKET');
INSERT INTO PRODUCT VALUES ('101863', 'SP JUNIOR RACKET');
INSERT INTO PRODUCT VALUES ('102130', 'RH: "GUIDE TO TENNIS"');
INSERT INTO PRODUCT VALUES ('200376', 'SB ENERGY BAR-6 PACK');
INSERT INTO PRODUCT VALUES ('200380', 'SB VITA SNACK-6 PACK');
INSERT INTO PRODUCT VALUES ( 103120 , 'WIFF SOFTBALL BAT I');
INSERT INTO PRODUCT VALUES ( 103121 , 'WIFF SOFTBALL BAT II');
INSERT INTO PRODUCT VALUES ( 103130 , 'WIFF SOFTBALL, SMALL');
INSERT INTO PRODUCT VALUES ( 103131 , 'WIFF SOFTBALL, LARGE');
INSERT INTO PRODUCT VALUES ( 103140 , 'WIFF SOFTBALL MITT (LH)');
INSERT INTO PRODUCT VALUES ( 103141 , 'WIFF SOFTBALL MITT (RH)');
INSERT INTO PRODUCT VALUES ( 102132 , 'RH: "GUIDE TO SOFTBALL"');
INSERT INTO PRODUCT VALUES ( 104350 , 'DUNK BASKETBALL INDOOR');
INSERT INTO PRODUCT VALUES ( 104351 , 'DUNK BASKETBALL OUTDOOR');
INSERT INTO PRODUCT VALUES ( 104352 , 'DUNK BASKETBALL PROFESSIONAL');
INSERT INTO PRODUCT VALUES ( 104360 , 'DUNK HOOP');
INSERT INTO PRODUCT VALUES ( 104361 , 'DUNK HOOP W/FIBERGLASS BOARD');
INSERT INTO PRODUCT VALUES ( 104362 , 'DUNK NETS - RAINBOW');
INSERT INTO PRODUCT VALUES ( 102134 , 'RH: "GUIDE TO BASKETBALL"');
INSERT INTO PRODUCT VALUES ( 105123 , 'YELLOW JERSEY BICYCLE HELMET');
INSERT INTO PRODUCT VALUES ( 105124 , 'YELLOW JERSEY BICYCLE GLOVES');
INSERT INTO PRODUCT VALUES ( 105125 , 'YELLOW JERSEY WATER BOTTLE');
INSERT INTO PRODUCT VALUES ( 105126 , 'YELLOW JERSEY BOTTLE CAGE');
INSERT INTO PRODUCT VALUES ( 105127 , 'YELLOW JERSEY FRAME PUMP');
INSERT INTO PRODUCT VALUES ( 105128 , 'YELLOW JERSEY SADDLE PACK');
INSERT INTO PRODUCT VALUES ( 102136 , 'RH: "GUIDE TO CYCLING"');

INSERT INTO SALES_ORDER VALUES
   (610,TO_DATE(2448264,'J'),101,TO_DATE(2448265,'J'),101.4);
INSERT INTO SALES_ORDER VALUES
   (611,TO_DATE(2448268,'J'),102,TO_DATE(2448268,'J'),45);
INSERT INTO SALES_ORDER VALUES
   (612,TO_DATE(2448272,'J'),104,TO_DATE(2448277,'J'),5860);
INSERT INTO SALES_ORDER VALUES
   (601,TO_DATE(2448013,'J'),106,TO_DATE(2448042,'J'),60.8);
INSERT INTO SALES_ORDER VALUES
   (602,TO_DATE(2448048,'J'),102,TO_DATE(2448063,'J'),56);
INSERT INTO SALES_ORDER VALUES
   (600,TO_DATE(2448013,'J'),103,TO_DATE(2448041,'J'),42);
INSERT INTO SALES_ORDER VALUES
   (604,TO_DATE(2448058,'J'),106,TO_DATE(2448073,'J'),642);
INSERT INTO SALES_ORDER VALUES
   (605,TO_DATE(2448087,'J'),106,TO_DATE(2448103,'J'),8374);
INSERT INTO SALES_ORDER VALUES
   (606,TO_DATE(2448087,'J'),100,TO_DATE(2448103,'J'),3.4);
INSERT INTO SALES_ORDER VALUES
   (609,TO_DATE(2448105,'J'),100,TO_DATE(2448119,'J'),102.5);
INSERT INTO SALES_ORDER VALUES
   (607,TO_DATE(2448091,'J'),104,TO_DATE(2448091,'J'),5.6);
INSERT INTO SALES_ORDER VALUES
   (608,TO_DATE(2448098,'J'),104,TO_DATE(2448098,'J'),35.2);
INSERT INTO SALES_ORDER VALUES
   (603,TO_DATE(2448048,'J'),102,TO_DATE(2448048,'J'),224);
INSERT INTO SALES_ORDER VALUES
   (620,TO_DATE(2448328,'J'),100,TO_DATE(2448328,'J'),4450);
INSERT INTO SALES_ORDER VALUES
   (613,TO_DATE(2448289,'J'),108,TO_DATE(2448289,'J'),6400);
INSERT INTO SALES_ORDER VALUES
   (614,TO_DATE(2448289,'J'),102,TO_DATE(2448293,'J'),23940);
INSERT INTO SALES_ORDER VALUES
   (616,TO_DATE(2448291,'J'),103,TO_DATE(2448298,'J'),764);
INSERT INTO SALES_ORDER VALUES
   (619,TO_DATE(2448310,'J'),104,TO_DATE(2448320,'J'),1260);
INSERT INTO SALES_ORDER VALUES
   (617,TO_DATE(2448293,'J'),105,TO_DATE(2448319,'J'),46370);
INSERT INTO SALES_ORDER VALUES
   (615,TO_DATE(2448289,'J'),107,TO_DATE(2448294,'J'),710);
INSERT INTO SALES_ORDER VALUES
   (618,TO_DATE(2448303,'J'),102,TO_DATE(2448322,'J'),3083);
INSERT INTO SALES_ORDER VALUES
   (621,TO_DATE(2448331,'J'),100,TO_DATE(2448348,'J'),730);
INSERT INTO SALES_ORDER VALUES
   (509,TO_DATE(2447682,'J'),226,TO_DATE(2447688,'J'),1174);
INSERT INTO SALES_ORDER VALUES
   (523,TO_DATE(2447936,'J'),226,TO_DATE(2447936,'J'),1165);
INSERT INTO SALES_ORDER VALUES
   (549,TO_DATE(2448253,'J'),226,TO_DATE(2448271,'J'),1620);
INSERT INTO SALES_ORDER VALUES
   (507,TO_DATE(2447673,'J'),228,TO_DATE(2447674,'J'),886);
INSERT INTO SALES_ORDER VALUES
   (516,TO_DATE(2447800,'J'),228,TO_DATE(2447803,'J'),1815);
INSERT INTO SALES_ORDER VALUES
   (553,TO_DATE(2448290,'J'),228,TO_DATE(2448301,'J'),4400);
INSERT INTO SALES_ORDER VALUES
   (526,TO_DATE(2447955,'J'),221,TO_DATE(2447958,'J'),7700);
INSERT INTO SALES_ORDER VALUES
   (543,TO_DATE(2448139,'J'),221,TO_DATE(2448142,'J'),8400);
INSERT INTO SALES_ORDER VALUES
   (555,TO_DATE(2448320,'J'),221,TO_DATE(2448323,'J'),8540);
INSERT INTO SALES_ORDER VALUES
   (559,TO_DATE(2448212,'J'),222,TO_DATE(2448370,'J'),387.2);
INSERT INTO SALES_ORDER VALUES
   (528,TO_DATE(2447975,'J'),224,TO_DATE(2447975,'J'),3770);
INSERT INTO SALES_ORDER VALUES
   (531,TO_DATE(2447982,'J'),224,TO_DATE(2447984,'J'),1400);
INSERT INTO SALES_ORDER VALUES
   (558,TO_DATE(2448347,'J'),224,TO_DATE(2448349,'J'),1700);
INSERT INTO SALES_ORDER VALUES
   (525,TO_DATE(2447951,'J'),225,TO_DATE(2447954,'J'),377);
INSERT INTO SALES_ORDER VALUES
   (552,TO_DATE(2448290,'J'),223,TO_DATE(2448295,'J'),555.8);
INSERT INTO SALES_ORDER VALUES
   (556,TO_DATE(2448326,'J'),223,TO_DATE(2448328,'J'),85);
INSERT INTO SALES_ORDER VALUES
   (560,TO_DATE(2448372,'J'),223,TO_DATE(2448372,'J'),72);
INSERT INTO SALES_ORDER VALUES
   (565,TO_DATE(2448409,'J'),227,TO_DATE(2448411,'J'),4900);
INSERT INTO SALES_ORDER VALUES
   (574,TO_DATE(2448540,'J'),201,TO_DATE(2448542,'J'),1685);
INSERT INTO SALES_ORDER VALUES
   (576,TO_DATE(2448543,'J'),201,TO_DATE(2448548,'J'),2058.9);
INSERT INTO SALES_ORDER VALUES
   (503,TO_DATE(2447611,'J'),201,TO_DATE(2447623,'J'),1876);
INSERT INTO SALES_ORDER VALUES
   (518,TO_DATE(2447820,'J'),201,TO_DATE(2447836,'J'),2932.5);
INSERT INTO SALES_ORDER VALUES
   (517,TO_DATE(2447823,'J'),201,TO_DATE(2447838,'J'),784);
INSERT INTO SALES_ORDER VALUES
   (544,TO_DATE(2448146,'J'),202,TO_DATE(2448150,'J'),2358);
INSERT INTO SALES_ORDER VALUES
   (524,TO_DATE(2447945,'J'),202,TO_DATE(2447955,'J'),1979);
INSERT INTO SALES_ORDER VALUES
   (502,TO_DATE(2447568,'J'),202,TO_DATE(2447581,'J'),500);
INSERT INTO SALES_ORDER VALUES
   (539,TO_DATE(2448069,'J'),202,TO_DATE(2448076,'J'),1300);
INSERT INTO SALES_ORDER VALUES
   (511,TO_DATE(2447756,'J'),202,TO_DATE(2447760,'J'),647);
INSERT INTO SALES_ORDER VALUES
   (512,TO_DATE(2447767,'J'),203,TO_DATE(2447783,'J'),428);
INSERT INTO SALES_ORDER VALUES
   (562,TO_DATE(2448381,'J'),203,TO_DATE(2448396,'J'),2044.5);
INSERT INTO SALES_ORDER VALUES
   (529,TO_DATE(2447984,'J'),203,TO_DATE(2447987,'J'),1264.7);
INSERT INTO SALES_ORDER VALUES
   (563,TO_DATE(2448402,'J'),204,TO_DATE(2448403,'J'),889);
INSERT INTO SALES_ORDER VALUES
   (568,TO_DATE(2448451,'J'),204,TO_DATE(2448459,'J'),1217.4);
INSERT INTO SALES_ORDER VALUES
   (504,TO_DATE(2447628,'J'),204,TO_DATE(2447629,'J'),1434.7);
INSERT INTO SALES_ORDER VALUES
   (538,TO_DATE(2448066,'J'),204,TO_DATE(2448069,'J'),741);
INSERT INTO SALES_ORDER VALUES
   (535,TO_DATE(2448040,'J'),204,TO_DATE(2448052,'J'),810);
INSERT INTO SALES_ORDER VALUES
   (578,TO_DATE(2448580,'J'),204,TO_DATE(2448595,'J'),2275.6);
INSERT INTO SALES_ORDER VALUES
   (534,TO_DATE(2448023,'J'),206,TO_DATE(2448027,'J'),420);
INSERT INTO SALES_ORDER VALUES
   (536,TO_DATE(2448033,'J'),206,TO_DATE(2448049,'J'),2135.6);
INSERT INTO SALES_ORDER VALUES
   (572,TO_DATE(2448488,'J'),206,TO_DATE(2448493,'J'),1200.5);
INSERT INTO SALES_ORDER VALUES
   (514,TO_DATE(2447775,'J'),207,TO_DATE(2447786,'J'),1140);
INSERT INTO SALES_ORDER VALUES
   (521,TO_DATE(2447851,'J'),207,TO_DATE(2447854,'J'),896.9);
INSERT INTO SALES_ORDER VALUES
   (551,TO_DATE(2448279,'J'),208,TO_DATE(2448294,'J'),1142);
INSERT INTO SALES_ORDER VALUES
   (513,TO_DATE(2447776,'J'),208,TO_DATE(2447784,'J'),1497);
INSERT INTO SALES_ORDER VALUES
   (508,TO_DATE(2447673,'J'),208,TO_DATE(2447686,'J'),1080);
INSERT INTO SALES_ORDER VALUES
   (515,TO_DATE(2447789,'J'),208,TO_DATE(2447796,'J'),1428.5);
INSERT INTO SALES_ORDER VALUES
   (542,TO_DATE(2448115,'J'),208,TO_DATE(2448127,'J'),2409);
INSERT INTO SALES_ORDER VALUES
   (573,TO_DATE(2448540,'J'),201,TO_DATE(2448542,'J'),1627);
INSERT INTO SALES_ORDER VALUES
   (566,TO_DATE(2448417,'J'),201,TO_DATE(2448420,'J'),3389.2);
INSERT INTO SALES_ORDER VALUES
   (520,TO_DATE(2447847,'J'),201,TO_DATE(2447850,'J'),341.6);
INSERT INTO SALES_ORDER VALUES
   (519,TO_DATE(2447820,'J'),201,TO_DATE(2447836,'J'),955);
INSERT INTO SALES_ORDER VALUES
   (575,TO_DATE(2448534,'J'),201,TO_DATE(2448547,'J'),684);
INSERT INTO SALES_ORDER VALUES
   (547,TO_DATE(2448181,'J'),202,TO_DATE(2448192,'J'),984.4);
INSERT INTO SALES_ORDER VALUES
   (540,TO_DATE(2448088,'J'),202,TO_DATE(2448090,'J'),861.2);
INSERT INTO SALES_ORDER VALUES
   (567,TO_DATE(2448443,'J'),202,TO_DATE(2448445,'J'),200);
INSERT INTO SALES_ORDER VALUES
   (570,TO_DATE(2448455,'J'),202,TO_DATE(2448462,'J'),663.6);
INSERT INTO SALES_ORDER VALUES
   (571,TO_DATE(2448471,'J'),202,TO_DATE(2448481,'J'),1095.6);
INSERT INTO SALES_ORDER VALUES
   (541,TO_DATE(2448112,'J'),203,TO_DATE(2448122,'J'),400);
INSERT INTO SALES_ORDER VALUES
   (532,TO_DATE(2447990,'J'),203,TO_DATE(2448003,'J'),1295.4);
INSERT INTO SALES_ORDER VALUES
   (527,TO_DATE(2447950,'J'),204,TO_DATE(2447965,'J'),3054.4);
INSERT INTO SALES_ORDER VALUES
   (501,TO_DATE(2447533,'J'),204,TO_DATE(2447538,'J'),216);
INSERT INTO SALES_ORDER VALUES
   (564,TO_DATE(2448402,'J'),204,TO_DATE(2448403,'J'),898.8);
INSERT INTO SALES_ORDER VALUES
   (537,TO_DATE(2448057,'J'),204,TO_DATE(2448069,'J'),672.9);
INSERT INTO SALES_ORDER VALUES
   (522,TO_DATE(2447899,'J'),204,TO_DATE(2447902,'J'),2578.8);
INSERT INTO SALES_ORDER VALUES
   (554,TO_DATE(2448306,'J'),204,TO_DATE(2448310,'J'),282.8);
INSERT INTO SALES_ORDER VALUES
   (569,TO_DATE(2448454,'J'),205,TO_DATE(2448461,'J'),2073);
INSERT INTO SALES_ORDER VALUES
   (550,TO_DATE(2448284,'J'),205,TO_DATE(2448295,'J'),2356);
INSERT INTO SALES_ORDER VALUES
   (548,TO_DATE(2448222,'J'),205,TO_DATE(2448238,'J'),666.9);
INSERT INTO SALES_ORDER VALUES
   (505,TO_DATE(2447624,'J'),206,TO_DATE(2447639,'J'),650);
INSERT INTO SALES_ORDER VALUES
   (577,TO_DATE(2448536,'J'),206,TO_DATE(2448550,'J'),1265.75);
INSERT INTO SALES_ORDER VALUES
   (533,TO_DATE(2448010,'J'),206,TO_DATE(2448014,'J'),1122.1);
INSERT INTO SALES_ORDER VALUES
   (561,TO_DATE(2448367,'J'),207,TO_DATE(2448384,'J'),2558.3);
INSERT INTO SALES_ORDER VALUES
   (506,TO_DATE(2447644,'J'),208,TO_DATE(2447657,'J'),2600.4);
INSERT INTO SALES_ORDER VALUES
   (530,TO_DATE(2447985,'J'),208,TO_DATE(2447989,'J'),3026.5);
INSERT INTO SALES_ORDER VALUES
   (545,TO_DATE(2448171,'J'),208,TO_DATE(2448178,'J'),475);
INSERT INTO SALES_ORDER VALUES
   (557,TO_DATE(2448324,'J'),208,TO_DATE(2448328,'J'),2461.8);
INSERT INTO SALES_ORDER VALUES
   (546,TO_DATE(2448182,'J'),208,TO_DATE(2448188,'J'),3663);
INSERT INTO SALES_ORDER VALUES
   (510,TO_DATE(2447726,'J'),208,TO_DATE(2447729,'J'),1336.6);

INSERT INTO ITEM VALUES (600,1,100861,42,1,42);
INSERT INTO ITEM VALUES (610,3,100890,58,1,58);
INSERT INTO ITEM VALUES (611,1,100861,45,1,45);
INSERT INTO ITEM VALUES (612,1,100860,30,100,3000);
INSERT INTO ITEM VALUES (601,1,200376,2.4,12,28.8);
INSERT INTO ITEM VALUES (601,2,100860,32,1,32);
INSERT INTO ITEM VALUES (602,1,100870,2.8,20,56);
INSERT INTO ITEM VALUES (604,1,100890,58,3,174);
INSERT INTO ITEM VALUES (604,2,100861,42,2,84);
INSERT INTO ITEM VALUES (604,3,100860,32,12,384);
INSERT INTO ITEM VALUES (603,1,100860,32,7,224);
INSERT INTO ITEM VALUES (610,1,100860,35,1,35);
INSERT INTO ITEM VALUES (610,2,100870,2.8,3,8.4);
INSERT INTO ITEM VALUES (613,4,200376,2.2,200,440);
INSERT INTO ITEM VALUES (614,1,100860,35,444,15540);
INSERT INTO ITEM VALUES (614,2,100870,2.8,1000,2800);
INSERT INTO ITEM VALUES (612,2,100861,40.5,20,810);
INSERT INTO ITEM VALUES (612,3,101863,10,150,1500);
INSERT INTO ITEM VALUES (620,1,100860,35,10,350);
INSERT INTO ITEM VALUES (620,2,200376,2.4,1000,2400);
INSERT INTO ITEM VALUES (620,3,102130,3.4,500,1700);
INSERT INTO ITEM VALUES (613,1,100871,5.6,100,560);
INSERT INTO ITEM VALUES (613,2,101860,24,200,4800);
INSERT INTO ITEM VALUES (613,3,200380,4,150,600);
INSERT INTO ITEM VALUES (619,3,102130,3.4,100,340);
INSERT INTO ITEM VALUES (617,1,100860,35,50,1750);
INSERT INTO ITEM VALUES (617,2,100861,45,100,4500);
INSERT INTO ITEM VALUES (614,3,100871,5.6,1000,5600);
INSERT INTO ITEM VALUES (616,1,100861,45,10,450);
INSERT INTO ITEM VALUES (616,2,100870,2.8,50,140);
INSERT INTO ITEM VALUES (616,3,100890,58,2,116);
INSERT INTO ITEM VALUES (616,4,102130,3.4,10,34);
INSERT INTO ITEM VALUES (616,5,200376,2.4,10,24);
INSERT INTO ITEM VALUES (619,1,200380,4,100,400);
INSERT INTO ITEM VALUES (619,2,200376,2.4,100,240);
INSERT INTO ITEM VALUES (615,1,100861,45,4,180);
INSERT INTO ITEM VALUES (607,1,100871,5.6,1,5.6);
INSERT INTO ITEM VALUES (615,2,100870,2.8,100,280);
INSERT INTO ITEM VALUES (617,3,100870,2.8,500,1400);
INSERT INTO ITEM VALUES (617,4,100871,5.6,500,2800);
INSERT INTO ITEM VALUES (617,5,100890,58,500,29000);
INSERT INTO ITEM VALUES (617,6,101860,24,100,2400);
INSERT INTO ITEM VALUES (617,7,101863,12.5,200,2500);
INSERT INTO ITEM VALUES (617,8,102130,3.4,100,340);
INSERT INTO ITEM VALUES (617,9,200376,2.4,200,480);
INSERT INTO ITEM VALUES (617,10,200380,4,300,1200);
INSERT INTO ITEM VALUES (609,2,100870,2.5,5,12.5);
INSERT INTO ITEM VALUES (609,3,100890,50,1,50);
INSERT INTO ITEM VALUES (618,1,100860,35,23,805);
INSERT INTO ITEM VALUES (618,2,100861,45,50,2250);
INSERT INTO ITEM VALUES (618,3,100870,2.8,10,28);
INSERT INTO ITEM VALUES (621,1,100861,45,10,450);
INSERT INTO ITEM VALUES (621,2,100870,2.8,100,280);
INSERT INTO ITEM VALUES (615,3,100871,5,50,250);
INSERT INTO ITEM VALUES (608,1,101860,24,1,24);
INSERT INTO ITEM VALUES (608,2,100871,5.6,2,11.2);
INSERT INTO ITEM VALUES (609,1,100861,40,1,40);
INSERT INTO ITEM VALUES (606,1,102130,3.4,1,3.4);
INSERT INTO ITEM VALUES (605,1,100861,45,100,4500);
INSERT INTO ITEM VALUES (605,2,100870,2.8,500,1400);
INSERT INTO ITEM VALUES (605,3,100890,58,5,290);
INSERT INTO ITEM VALUES (605,4,101860,24,50,1200);
INSERT INTO ITEM VALUES (605,5,101863,9.5,100,950);
INSERT INTO ITEM VALUES (605,6,102130,3.4,10,34);
INSERT INTO ITEM VALUES (612,4,100871,5.5,100,550);
INSERT INTO ITEM VALUES (619,4,100871,5.6,50,280);
INSERT INTO ITEM VALUES (509,1,105123,35,30,1050);
INSERT INTO ITEM VALUES (509,2,105124,9,10,90);
INSERT INTO ITEM VALUES (509,3,102136,3.4,10,34);
INSERT INTO ITEM VALUES (523,1,102136,3.4,10,34);
INSERT INTO ITEM VALUES (523,2,105123,37.7,30,1131);
INSERT INTO ITEM VALUES (549,1,105123,38,5,190);
INSERT INTO ITEM VALUES (549,2,105127,6,30,180);
INSERT INTO ITEM VALUES (549,3,105125,3,200,600);
INSERT INTO ITEM VALUES (549,4,105124,13,50,650);
INSERT INTO ITEM VALUES (507,1,105123,35.3,20,706);
INSERT INTO ITEM VALUES (507,2,105124,9,20,180);
INSERT INTO ITEM VALUES (516,1,105124,9,60,540);
INSERT INTO ITEM VALUES (516,2,102136,3.2,250,800);
INSERT INTO ITEM VALUES (516,3,105125,1.9,250,475);
INSERT INTO ITEM VALUES (553,1,105127,6,500,3000);
INSERT INTO ITEM VALUES (553,2,200376,1.75,800,1400);
INSERT INTO ITEM VALUES (526,1,105123,32,100,3200);
INSERT INTO ITEM VALUES (526,2,105124,9,500,4500);
INSERT INTO ITEM VALUES (543,1,105123,34,100,3400);
INSERT INTO ITEM VALUES (543,2,105124,10,500,5000);
INSERT INTO ITEM VALUES (555,1,105123,34,100,3400);
INSERT INTO ITEM VALUES (555,2,105124,10,500,5000);
INSERT INTO ITEM VALUES (555,3,102136,2.8,50,140);
INSERT INTO ITEM VALUES (559,1,105123,40,5,200);
INSERT INTO ITEM VALUES (559,2,105124,15,5,75);
INSERT INTO ITEM VALUES (559,3,105127,6,5,30);
INSERT INTO ITEM VALUES (559,4,102136,3.4,3,10.2);
INSERT INTO ITEM VALUES (559,5,200376,2.4,30,72);
INSERT INTO ITEM VALUES (528,1,105123,37.7,100,3770);
INSERT INTO ITEM VALUES (531,1,105124,11,100,1100);
INSERT INTO ITEM VALUES (531,2,102136,3,100,300);
INSERT INTO ITEM VALUES (558,1,105124,14,100,1400);
INSERT INTO ITEM VALUES (558,2,102136,3,100,300);
INSERT INTO ITEM VALUES (525,1,105123,37.7,10,377);
INSERT INTO ITEM VALUES (552,1,105123,40,10,400);
INSERT INTO ITEM VALUES (552,2,105124,15,10,150);
INSERT INTO ITEM VALUES (552,3,102136,3.4,1,3.4);
INSERT INTO ITEM VALUES (552,4,200376,2.4,1,2.4);
INSERT INTO ITEM VALUES (556,1,102136,3.4,25,85);
INSERT INTO ITEM VALUES (560,1,200376,2.4,30,72);
INSERT INTO ITEM VALUES (565,1,105123,37,100,3700);
INSERT INTO ITEM VALUES (565,2,105124,12,100,1200);
INSERT INTO ITEM VALUES (574,1,104350,41.8,25,1045);
INSERT INTO ITEM VALUES (574,2,200380,3.2,200,640);
INSERT INTO ITEM VALUES (576,1,104350,44,10,440);
INSERT INTO ITEM VALUES (576,2,104351,26,10,260);
INSERT INTO ITEM VALUES (576,3,104362,4.25,170,722.5);
INSERT INTO ITEM VALUES (576,4,200376,2.16,90,194.4);
INSERT INTO ITEM VALUES (576,5,200380,3.4,130,442);
INSERT INTO ITEM VALUES (503,1,104350,38,30,1140);
INSERT INTO ITEM VALUES (503,2,104351,23.6,10,236);
INSERT INTO ITEM VALUES (503,3,104352,50,10,500);
INSERT INTO ITEM VALUES (518,1,104350,38,25,950);
INSERT INTO ITEM VALUES (518,2,104351,23.6,20,472);
INSERT INTO ITEM VALUES (518,3,104360,36,20,720);
INSERT INTO ITEM VALUES (518,4,104362,4.25,170,722.5);
INSERT INTO ITEM VALUES (518,5,102134,3.4,20,68);
INSERT INTO ITEM VALUES (517,1,104352,50,15,750);
INSERT INTO ITEM VALUES (517,2,102134,3.4,10,34);
INSERT INTO ITEM VALUES (544,1,104350,44,15,660);
INSERT INTO ITEM VALUES (544,2,104351,26,15,390);
INSERT INTO ITEM VALUES (544,3,104352,58.3,10,583);
INSERT INTO ITEM VALUES (544,4,104361,50,10,500);
INSERT INTO ITEM VALUES (544,5,104362,4.5,50,225);
INSERT INTO ITEM VALUES (524,1,104350,42,10,420);
INSERT INTO ITEM VALUES (524,2,104351,23.56,35,824.6);
INSERT INTO ITEM VALUES (524,3,104362,4.25,150,637.5);
INSERT INTO ITEM VALUES (524,4,102134,3.23,30,96.9);
INSERT INTO ITEM VALUES (502,1,104352,50,10,500);
INSERT INTO ITEM VALUES (539,1,104351,26,20,520);
INSERT INTO ITEM VALUES (539,2,104360,39,20,780);
INSERT INTO ITEM VALUES (511,1,104351,23.6,15,354);
INSERT INTO ITEM VALUES (511,2,104362,4.5,50,225);
INSERT INTO ITEM VALUES (511,3,102134,3.4,20,68);
INSERT INTO ITEM VALUES (512,1,104360,36,10,360);
INSERT INTO ITEM VALUES (512,2,102134,3.4,20,68);
INSERT INTO ITEM VALUES (562,1,104351,24.7,25,617.5);
INSERT INTO ITEM VALUES (562,2,104352,58.3,15,874.5);
INSERT INTO ITEM VALUES (562,3,104362,4.25,130,552.5);
INSERT INTO ITEM VALUES (529,1,104350,39.89,30,1196.7);
INSERT INTO ITEM VALUES (529,2,102134,3.4,20,68);
INSERT INTO ITEM VALUES (563,1,104352,58.3,10,583);
INSERT INTO ITEM VALUES (563,2,200376,2.04,150,306);
INSERT INTO ITEM VALUES (568,1,104351,24.7,30,741);
INSERT INTO ITEM VALUES (568,2,200376,2.04,110,224.4);
INSERT INTO ITEM VALUES (568,3,200380,3.6,70,252);
INSERT INTO ITEM VALUES (504,1,104350,40,10,400);
INSERT INTO ITEM VALUES (504,2,104351,22.42,35,784.7);
INSERT INTO ITEM VALUES (504,3,104352,50,5,250);
INSERT INTO ITEM VALUES (538,1,104351,24.7,30,741);
INSERT INTO ITEM VALUES (535,1,104352,54,15,810);
INSERT INTO ITEM VALUES (578,1,104350,41.8,40,1672);
INSERT INTO ITEM VALUES (578,2,200376,2.04,190,387.6);
INSERT INTO ITEM VALUES (578,3,200380,3.6,60,216);
INSERT INTO ITEM VALUES (534,1,104350,42,10,420);
INSERT INTO ITEM VALUES (536,1,104350,39.89,40,1595.6);
INSERT INTO ITEM VALUES (536,2,104352,54,10,540);
INSERT INTO ITEM VALUES (572,1,104351,24.7,25,617.5);
INSERT INTO ITEM VALUES (572,2,104352,58.3,10,583);
INSERT INTO ITEM VALUES (514,1,104350,38,30,1140);
INSERT INTO ITEM VALUES (521,1,104350,40,20,800);
INSERT INTO ITEM VALUES (521,2,102134,3.23,30,96.9);
INSERT INTO ITEM VALUES (551,1,104350,44,10,440);
INSERT INTO ITEM VALUES (551,2,104361,50,5,250);
INSERT INTO ITEM VALUES (551,3,102134,3.4,20,68);
INSERT INTO ITEM VALUES (551,4,200376,1.92,200,384);
INSERT INTO ITEM VALUES (513,1,104350,40,15,600);
INSERT INTO ITEM VALUES (513,2,104351,23.6,20,472);
INSERT INTO ITEM VALUES (513,3,104362,4.25,100,425);
INSERT INTO ITEM VALUES (508,1,104360,36,20,720);
INSERT INTO ITEM VALUES (508,2,104362,4.5,80,360);
INSERT INTO ITEM VALUES (515,1,104350,40,20,800);
INSERT INTO ITEM VALUES (515,2,104351,22.42,25,560.5);
INSERT INTO ITEM VALUES (515,3,102134,3.4,20,68);
INSERT INTO ITEM VALUES (542,1,104350,41.8,25,1045);
INSERT INTO ITEM VALUES (542,2,104360,39,20,780);
INSERT INTO ITEM VALUES (542,3,104361,50,11,550);
INSERT INTO ITEM VALUES (542,4,102134,3.4,10,34);
INSERT INTO ITEM VALUES (573,1,103120,22.5,50,1125);
INSERT INTO ITEM VALUES (573,2,103131,4.04,50,202);
INSERT INTO ITEM VALUES (573,3,103141,20,15,300);
INSERT INTO ITEM VALUES (566,1,103120,23.75,40,950);
INSERT INTO ITEM VALUES (566,2,103121,27,50,1350);
INSERT INTO ITEM VALUES (566,3,103130,3.77,60,226.2);
INSERT INTO ITEM VALUES (566,4,103131,3.9,170,663);
INSERT INTO ITEM VALUES (566,5,103141,20,10,200);
INSERT INTO ITEM VALUES (520,1,103130,4,10,40);
INSERT INTO ITEM VALUES (520,2,103131,3.77,80,301.6);
INSERT INTO ITEM VALUES (519,1,103130,3.5,110,385);
INSERT INTO ITEM VALUES (519,2,103140,19,30,570);
INSERT INTO ITEM VALUES (575,1,103140,19,30,570);
INSERT INTO ITEM VALUES (575,2,200380,3.8,30,114);
INSERT INTO ITEM VALUES (547,1,103130,3.77,80,301.6);
INSERT INTO ITEM VALUES (547,2,103131,4.04,70,282.8);
INSERT INTO ITEM VALUES (547,3,103140,20,15,300);
INSERT INTO ITEM VALUES (547,4,103141,20,5,100);
INSERT INTO ITEM VALUES (540,1,103130,3.98,40,159.2);
INSERT INTO ITEM VALUES (540,2,103131,3.9,180,702);
INSERT INTO ITEM VALUES (567,1,103140,20,10,200);
INSERT INTO ITEM VALUES (570,1,103131,4.04,90,363.6);
INSERT INTO ITEM VALUES (570,2,103140,20,15,300);
INSERT INTO ITEM VALUES (571,1,103131,4.04,70,282.8);
INSERT INTO ITEM VALUES (571,2,103140,19,25,475);
INSERT INTO ITEM VALUES (571,3,102132,3.4,15,51);
INSERT INTO ITEM VALUES (571,4,200376,2.16,80,172.8);
INSERT INTO ITEM VALUES (571,5,200380,3.8,30,114);
INSERT INTO ITEM VALUES (541,1,103140,20,10,200);
INSERT INTO ITEM VALUES (541,2,103141,20,10,200);
INSERT INTO ITEM VALUES (532,1,103120,21.59,60,1295.4);
INSERT INTO ITEM VALUES (527,1,103120,21.59,60,1295.4);
INSERT INTO ITEM VALUES (527,2,103121,27.35,40,1094);
INSERT INTO ITEM VALUES (527,3,103140,19,35,665);
INSERT INTO ITEM VALUES (501,1,103130,3.6,60,216);
INSERT INTO ITEM VALUES (564,1,103130,3.77,80,301.6);
INSERT INTO ITEM VALUES (564,2,103131,3.9,120,468);
INSERT INTO ITEM VALUES (564,3,102132,3.23,40,129.2);
INSERT INTO ITEM VALUES (537,1,103130,3.6,160,576);
INSERT INTO ITEM VALUES (537,2,102132,3.23,30,96.9);
INSERT INTO ITEM VALUES (522,1,103120,21.59,80,1727.2);
INSERT INTO ITEM VALUES (522,2,103121,28.8,10,288);
INSERT INTO ITEM VALUES (522,3,103131,4.04,90,363.6);
INSERT INTO ITEM VALUES (522,4,103141,20,10,200);
INSERT INTO ITEM VALUES (554,1,103131,4.04,70,282.8);
INSERT INTO ITEM VALUES (569,1,103120,22.5,50,1125);
INSERT INTO ITEM VALUES (569,2,103130,3.6,180,648);
INSERT INTO ITEM VALUES (569,3,103141,20,15,300);
INSERT INTO ITEM VALUES (550,1,103120,22.5,60,1350);
INSERT INTO ITEM VALUES (550,2,103140,19,45,855);
INSERT INTO ITEM VALUES (550,3,103141,20,5,100);
INSERT INTO ITEM VALUES (550,4,102132,3.4,15,51);
INSERT INTO ITEM VALUES (548,1,103140,19,30,570);
INSERT INTO ITEM VALUES (548,2,102132,3.23,30,96.9);
INSERT INTO ITEM VALUES (505,1,103130,3.5,100,350);
INSERT INTO ITEM VALUES (505,2,103140,20,15,300);
INSERT INTO ITEM VALUES (577,1,103121,30,20,600);
INSERT INTO ITEM VALUES (577,2,103131,3.9,150,585);
INSERT INTO ITEM VALUES (577,3,102132,3.23,25,80.75);
INSERT INTO ITEM VALUES (533,1,103121,27.35,30,820.5);
INSERT INTO ITEM VALUES (533,2,103130,3.77,80,301.6);
INSERT INTO ITEM VALUES (561,1,103120,22.5,80,1800);
INSERT INTO ITEM VALUES (561,2,103130,3.77,70,263.9);
INSERT INTO ITEM VALUES (561,3,103141,20,15,300);
INSERT INTO ITEM VALUES (561,4,200376,2.16,90,194.4);
INSERT INTO ITEM VALUES (506,1,103120,20.88,80,1670.4);
INSERT INTO ITEM VALUES (506,2,103130,3.5,180,630);
INSERT INTO ITEM VALUES (506,3,103141,20,15,300);
INSERT INTO ITEM VALUES (530,1,103121,25.91,50,1295.5);
INSERT INTO ITEM VALUES (530,2,103130,3.6,200,720);
INSERT INTO ITEM VALUES (530,3,103140,19,40,760);
INSERT INTO ITEM VALUES (530,4,103141,20,10,200);
INSERT INTO ITEM VALUES (530,5,102132,3.4,15,51);
INSERT INTO ITEM VALUES (545,1,103140,19,25,475);
INSERT INTO ITEM VALUES (557,1,103120,23.75,40,950);
INSERT INTO ITEM VALUES (557,2,103121,30,10,300);
INSERT INTO ITEM VALUES (557,3,103140,19,35,665);
INSERT INTO ITEM VALUES (557,4,200376,2.16,80,172.8);
INSERT INTO ITEM VALUES (557,5,200380,3.4,110,374);
INSERT INTO ITEM VALUES (546,1,103120,22.5,50,1125);
INSERT INTO ITEM VALUES (546,2,103121,30,20,600);
INSERT INTO ITEM VALUES (546,3,103130,3.6,120,432);
INSERT INTO ITEM VALUES (546,4,103131,3.9,140,546);
INSERT INTO ITEM VALUES (546,5,103140,19,40,760);
INSERT INTO ITEM VALUES (546,6,103141,20,10,200);
INSERT INTO ITEM VALUES (510,1,103120,20.88,60,1252.8);
INSERT INTO ITEM VALUES (510,2,103131,4.19,20,83.8);

INSERT INTO CUSTOMER
  (ZIP_CODE, STATE, SALESPERSON_ID, PHONE_NUMBER,
  NAME,
  CUSTOMER_ID, CREDIT_LIMIT, CITY, AREA_CODE, ADDRESS,
  COMMENTS)
  VALUES ('96711', 'CA', '7844', '5986609',
  'JOCKSPORTS',
  '100', '5000', 'BELMONT', '415', '345 VIEWRIDGE',
  'Very friendly people to work with -- sales rep likes to be called Mike.');

INSERT INTO CUSTOMER
  (ZIP_CODE, STATE, SALESPERSON_ID, PHONE_NUMBER,
  NAME,
  CUSTOMER_ID, CREDIT_LIMIT, CITY, AREA_CODE, ADDRESS,
  COMMENTS)
  VALUES ('94061', 'CA', '7521', '3681223',
  'TKB SPORT SHOP',
  '101', '10000', 'REDWOOD CITY', '415', '490 BOLI RD.',
  'Rep called 5/8 about change in order - contact shipping.');
                                                             
INSERT INTO CUSTOMER
  (ZIP_CODE, STATE, SALESPERSON_ID, PHONE_NUMBER,
  NAME,
  CUSTOMER_ID, CREDIT_LIMIT, CITY, AREA_CODE, ADDRESS,
  COMMENTS)
  VALUES ('95133', 'CA', '7654', '6443341',
  'VOLLYRITE',
  '102', '7000', 'BURLINGAME', '415', '9722 HAMILTON',
  'Company doing heavy promotion beginning 10/89. Prepare for large orders during winter.');

INSERT INTO CUSTOMER
  (ZIP_CODE, STATE, SALESPERSON_ID, PHONE_NUMBER,
  NAME,
  CUSTOMER_ID, CREDIT_LIMIT, CITY, AREA_CODE, ADDRESS,
  COMMENTS)
  VALUES ('97544', 'CA', '7521', '6779312',
  'JUST TENNIS',
  '103', '3000', 'BURLINGAME', '415', 'HILLVIEW MALL',
  'Contact rep about new line of tennis rackets.');
                                                            
INSERT INTO CUSTOMER
  (ZIP_CODE, STATE, SALESPERSON_ID, PHONE_NUMBER,
  NAME,
  CUSTOMER_ID, CREDIT_LIMIT, CITY, AREA_CODE, ADDRESS,
  COMMENTS)
  VALUES ('93301', 'CA', '7499', '9962323',
  'EVERY MOUNTAIN',
  '104', '10000', 'CUPERTINO', '408', '574 SURRY RD.',
  'Customer with high market share (23%) due to aggressive advertising.');
                                                     
INSERT INTO CUSTOMER
  (ZIP_CODE, STATE, SALESPERSON_ID, PHONE_NUMBER,
  NAME,
  CUSTOMER_ID, CREDIT_LIMIT, CITY, AREA_CODE, ADDRESS,
  COMMENTS)
  VALUES ('91003', 'CA', '7844', '3769966',
  'K + T SPORTS',
  '105', '5000', 'SANTA CLARA', '408', '3476 EL PASEO',
  'Tends to order large amounts of merchandise at once. Accounting is considering raising their credit limit. Usually pays on time.');
                                                     
INSERT INTO CUSTOMER
  (ZIP_CODE, STATE, SALESPERSON_ID, PHONE_NUMBER,
  NAME,
  CUSTOMER_ID, CREDIT_LIMIT, CITY, AREA_CODE, ADDRESS,
  COMMENTS)
  VALUES ('94301', 'CA', '7521', '3649777',
  'SHAPE UP',
  '106', '6000', 'PALO ALTO', '415', '908 SEQUOIA',
  'Support intensive. Orders small amounts (< 800) of merchandise at a time.');

INSERT INTO CUSTOMER
  (ZIP_CODE, STATE, SALESPERSON_ID, PHONE_NUMBER,
  NAME,
  CUSTOMER_ID, CREDIT_LIMIT, CITY, AREA_CODE, ADDRESS,
  COMMENTS)
  VALUES ('93301', 'CA', '7499', '9674398',
  'WOMENS SPORTS',
  '107', '10000', 'SUNNYVALE', '408', 'VALCO VILLAGE',
  'First sporting goods store geared exclusively towards women. Unusual promotional style and very willing to take chances towards new products!');
           
INSERT INTO CUSTOMER
  (ZIP_CODE, STATE, SALESPERSON_ID, PHONE_NUMBER,
  NAME,
  CUSTOMER_ID, CREDIT_LIMIT, CITY, AREA_CODE, ADDRESS,
  COMMENTS)
  VALUES ('55649', 'MN', '7844', '5669123',
  'NORTH WOODS HEALTH AND FITNESS SUPPLY CENTER',
  '108', '8000', 'HIBBING', '612', '98 LONE PINE WAY', '');

INSERT INTO CUSTOMER VALUES
  ( 201 , 'STADIUM SPORTS', '47 IRVING PL.',
  'NEW YORK', 'NY', '10003',
  '212', '5555335',  7557 ,  10000 ,
  'Large general-purpose sports store with an affluent customer base.');

INSERT INTO CUSTOMER VALUES
  ( 202 , 'HOOPS', '2345 ADAMS AVE.',
  'LEICESTER', 'MA', '01524',
  '508', '5557542',  7820 ,  5000 ,
  'Specializes in basketball equipment.');

INSERT INTO CUSTOMER VALUES
  ( 203 , 'REBOUND SPORTS', '2 E. 14TH ST.',
  'NEW YORK', 'NY', '10009',
  '212', '5555989',  7557 ,  10000 ,
  'Follow up on the promotion proposal.');

INSERT INTO CUSTOMER VALUES
  ( 204 , 'THE POWER FORWARD', '1 KNOTS LANDING',
  'DALLAS', 'TX', '75248',
  '214', '5550505',  7560 ,  12000 ,
  'Large floorspace.  Prefers maintaining large amounts of inventory on hand.');

INSERT INTO CUSTOMER VALUES
  ( 205 , 'POINT GUARD', '20 THURSTON ST.',
  'YONKERS', 'NY', '10956',
  '914', '5554766',  7557 ,  3000 ,
  'Tremendous potential for an exclusive agreement.');

INSERT INTO CUSTOMER VALUES
  ( 206 , 'THE COLISEUM', '5678 WILBUR PL.',
  'SCARSDALE', 'NY', '10583',
  '914', '5550217',  7557 ,  6000 ,
  'Contact rep. about new product lines.');

INSERT INTO CUSTOMER VALUES
  ( 207 , 'FAST BREAK', '1000 HERBERT LN.',
  'CONCORD', 'MA', '01742',
  '508', '5551298',  7820 ,  7000 ,
  'Customer requires written price quotes before making purchase requisitions.');

INSERT INTO CUSTOMER VALUES
  ( 208 , 'AL AND BOB''S SPORTS', '260 YORKTOWN CT.',
  'AUSTIN', 'TX', '78731',
  '512', '5557631',  7560 ,  4000 ,
  'Very personal purchasing agents -- Sharon and Scott.');

INSERT INTO CUSTOMER VALUES
  ( 211 , 'AT BAT', '234 BEACHEM ST.',
  'BROOKLINE', 'MA', '02146',
  '617', '5557385',  7820 ,  8000 ,
  'Have an open purchase order for $3000.  Ship immediately on request.');

INSERT INTO CUSTOMER VALUES
  ( 212 , 'ALL SPORT', '1000 38TH ST.',
  'BROOKLYN', 'NY', '11210',
  '718', '5551739',  7600 ,  6000 ,
  'Pursue a contract -- possible candidate for volume purchasing agreements.');

INSERT INTO CUSTOMER VALUES
  ( 213 , 'GOOD SPORT', '400 46TH ST.',
  'SUNNYSIDE', 'NY', '11104',
  '718', '5553771',  7600 ,  5000 ,
  'May be moving to a larger location.');

INSERT INTO CUSTOMER VALUES
  ( 214 , 'AL''S PRO SHOP', '45 SPRUCE ST.',
  'SPRING', 'TX', '77388',
  '713', '5555172',  7564 ,  8000 ,
  'Target market is serious athletes.');

INSERT INTO CUSTOMER VALUES
  ( 215 , 'BOB''S FAMILY SPORTS', '400 E. 23RD',
  'HOUSTON', 'TX', '77026',
  '713', '5558015',  7654 ,  8000 ,
  'Target market is casual and weekend athletes.  Offers a large selection.');

INSERT INTO CUSTOMER VALUES
  ( 216 , 'THE ALL AMERICAN', '547 PRENTICE RD.',
  'CHELSEA', 'MA', '02150',
  '617', '5553047',  7820 ,  5000 ,
  'Customer prefers to be called between 10 and 12.');

INSERT INTO CUSTOMER VALUES
  ( 217 , 'HIT, THROW, AND RUN', '333 WOOD COURT',
  'GRAPEVINE', 'TX', '76051',
  '817', '5552352',  7564 ,  6000 ,
  'General purpose sports store.');

INSERT INTO CUSTOMER VALUES
  ( 218 , 'THE OUTFIELD', '346 GARDEN BLVD.',
  'FLUSHING', 'NY', '11355',
  '718', '5552131',  7820 ,  4000 ,
  'Store does not open until 11am and does not have an answering service.');

INSERT INTO CUSTOMER VALUES
  ( 221 , 'WHEELS AND DEALS', '2 MEMORIAL DRIVE',
  'HOUSTON', 'TX', '77007',
  '713', '5554139',  7789 ,  10000 ,
  'Discount bicycle and sporting good store.');

INSERT INTO CUSTOMER VALUES
  ( 222 , 'JUST BIKES', '4000 PARKRIDGE BLVD.',
  'DALLAS', 'TX', '75205',
  '214', '5558735',  7789 ,  4000 ,
  'Exclusive bicycle dealer.');

INSERT INTO CUSTOMER VALUES
  ( 223 , 'VELO SPORTS', '23 WHITE ST.',
  'MALDEN', 'MA', '02148',
  '617', '5554983',  7820 ,  5000 ,
  'Clerk answers all phone lines.  Ask for Mike.');

INSERT INTO CUSTOMER VALUES
  ( 224 , 'JOE''S BIKE SHOP', '4500 FOX COURT',
  'GRAND PRARIE', 'TX', '75051',
  '214', '5559834',  7789 ,  6000 ,
  'Call Joe to make sure last shipment was complete.');

INSERT INTO CUSTOMER VALUES
  ( 225 , 'BOB''S SWIM, CYCLE, AND RUN', '300 HORSECREEK CIRCLE',
  'IRVING', 'TX', '75039',
  '214', '5558388',  7789 ,  7000 ,
  'Store catering to triathletes.');

INSERT INTO CUSTOMER VALUES
  ( 226 , 'CENTURY SHOP', '8 DAGMAR DR.',
  'HUNTINGTON', 'NY', '11743',
  '516', '5553006',  7555 ,  4000 ,
  'Customer in the midst of a cost-cutting program.');

INSERT INTO CUSTOMER VALUES
  ( 227 , 'THE TOUR', '2500 GARDNER RD.',
  'SOMERVILLE', 'MA', '02144',
  '617', '5556673',  7820 ,  5000 ,
  'Customer referred to us by The All American.');

INSERT INTO CUSTOMER VALUES
  ( 228 , 'FITNESS FIRST', '5000 85TH ST.',
  'JACKSON HEIGHTS', 'NY', '11372',
  '718', '5558710',  7555 ,  4000 ,
  'Recently acquired another sporting goods store.  Expect higher volume in the future.');

COMMIT;

REM Create indexes

CREATE UNIQUE INDEX I_LOCATION$LOCATION_ID ON LOCATION (LOCATION_ID);
CREATE UNIQUE INDEX I_DEPARTMENT$DEPARTMENT_ID ON DEPARTMENT (DEPARTMENT_ID);
CREATE UNIQUE INDEX I_JOB$JOB_ID ON JOB (JOB_ID);
CREATE UNIQUE INDEX I_EMPLOYEE$EMPLOYEE_ID ON EMPLOYEE (EMPLOYEE_ID);
CREATE UNIQUE INDEX I_SALARY_GRADE$GRADE_ID ON SALARY_GRADE (GRADE_ID);
CREATE UNIQUE INDEX I_PRODUCT$PRODUCT_ID ON PRODUCT (PRODUCT_ID);
CREATE UNIQUE INDEX I_PRICE ON PRICE (PRODUCT_ID, START_DATE);
CREATE UNIQUE INDEX I_CUSTOMER$CUSTOMER_ID ON CUSTOMER (CUSTOMER_ID);
CREATE UNIQUE INDEX I_SALES_ORDER$ORDER_ID ON SALES_ORDER (ORDER_ID);
CREATE UNIQUE INDEX I_ITEM ON ITEM (ORDER_ID, ITEM_ID);

ORACLE API for Lookup Code and Value Creation

Oracle APIs for Creation of  Lookup Code and Values in ORacle Apps....

DECLARE
   ln_rowid    VARCHAR2 (1000);
   ln_rowid1   VARCHAR2 (1000);
BEGIN
   fnd_lookup_types_pkg.insert_row (x_rowid                    => ln_rowid,
                                    x_lookup_type              => 'XXND BUSINESS CYCLE',
                                    x_security_group_id        => 0,
                                    x_view_application_id      => 3,
                                    x_application_id           => 20087,
                                    x_customization_level      => 'U',
                                    x_meaning                  => 'XXND BUSINESS CYCLE',
                                    x_description              => 'XXND BUSINESS CYCLE',
                                    x_creation_date            => SYSDATE,
                                    x_created_by               => 0,
                                    x_last_update_date         => SYSDATE,
                                    x_last_updated_by          => 0,
                                    x_last_update_login        => -1
                                   );
                                    
   DBMS_OUTPUT.put_line (ln_rowid);
   fnd_lookup_values_pkg.insert_row (x_rowid                    => ln_rowid1,
                                     x_lookup_type              => 'XXND BUSINESS CYCLE',
                                     x_security_group_id        => 0,
                                     x_view_application_id      => 3,
                                     x_lookup_code              => 'XXND_INFO',
                                     x_tag                      => NULL,
                                     x_attribute_category       => NULL,
                                     x_attribute1               => NULL,
                                     x_attribute2               => NULL,
                                     x_attribute3               => NULL,
                                     x_attribute4               => NULL,
                                     x_enabled_flag             => 'Y',
                                     x_start_date_active        => TO_DATE ('01-JAN-1950',
                                                                            'DD-MON-YYYY'
                                                                           ),
                                     x_end_date_active          => NULL,
                                     x_territory_code           => NULL,
                                     x_attribute5               => NULL,
                                     x_attribute6               => NULL,
                                     x_attribute7               => NULL,
                                     x_attribute8               => NULL,
                                     x_attribute9               => NULL,
                                     x_attribute10              => NULL,
                                     x_attribute11              => NULL,
                                     x_attribute12              => NULL,
                                     x_attribute13              => NULL,
                                     x_attribute14              => NULL,
                                     x_attribute15              => NULL,
                                     x_meaning                  => 'XXND Information',
                                     x_description              => NULL,
                                     x_creation_date            => SYSDATE,
                                     x_created_by               => 0,
                                     x_last_update_date         => SYSDATE,
                                     x_last_updated_by          => 0,
                                     x_last_update_login        => -1
                                    );
   DBMS_OUTPUT.put_line (ln_rowid1);
   COMMIT;
END;

Query for Specific User's Responsibilities and Application

How to find out User Name associate with the Responsibilities and Application........


SELECT fu.user_name                "User Name",
       frt.responsibility_name     "Responsibility Name",
       furg.start_date             "Start Date",
       furg.end_date               "End Date",     
       fr.responsibility_key       "Responsibility Key",
       fa.application_short_name   "Application Short Name",
       fat.application_name
  FROM fnd_user_resp_groups_direct        furg,
       applsys.fnd_user                   fu,
       applsys.fnd_responsibility_tl      frt,
       applsys.fnd_responsibility         fr,
       applsys.fnd_application_tl         fat,
       applsys.fnd_application            fa
 WHERE furg.user_id             =  fu.user_id
   AND furg.responsibility_id   =  frt.responsibility_id
   AND fr.responsibility_id     =  frt.responsibility_id
   AND fa.application_id        =  fat.application_id
   AND fr.application_id        =  fat.application_id
   AND frt.language             =  USERENV('LANG')
   AND UPPER(fu.user_name)      =  UPPER('NPATIL')  --
   AND (furg.end_date IS NULL OR furg.end_date >= TRUNC(SYSDATE))
 ORDER BY frt.responsibility_name;

GL Period Name Query:

How to find out Open / Close GL Period in ORacle Apps::


SELECT
  gps.period_num,
  gps.period_name,
  gps.set_of_books_id,
  gsob.period_set_name,
  DECODE (gps.closing_status,
    'O', 'Open',
    'C', 'Closed',
    'F', 'Future',
    'N', 'Never') status
FROM
  gl_period_statuses gps,
  gl_sets_of_books gsob
where
  gps.application_id = 101
  and gps.closing_status='O' and
  gsob.set_of_books_id = gps.set_of_books_id
  and gps.set_of_books_id=fnd_profile.value('GL_SET_OF_BKS_ID')
  and gps.PERIOD_YEAR=2013
  order by
  gps.period_num

Meaning of _ALL _TL in Oracle Apps

Meaning of _ALL _TL in Oracle Apps

Table-types and names in Oracle Apps:

_ALL are multi-org tables.

_TL are tables corresponding to another table with the same name minus the TL. These tables provide multiple language support. For each item in the table without TL there can be many rows in the _TL table, but all with different values in the LANGUAGE column.

_F these are date tracked tables which occur in HR and Payroll. For these there are two date columns EFFECTIVE_START_DATE and EFFECTIVE_END_DATE which together with the PK identifies a row uniquely. The date intervals cannot overlap.

_B these are the BASE tables.
They are very important and the data is stored in the these table with all validations.
It is supposed that these table will always contain the perfect format data.
If anything happens to the BASE table data, then it is a data corruption issue.

_V are views.

_VL are views for multi language tables which combines the row of the base table with the corresponding row of the _TL table where the LANGUAGE = USERENV('LANG').

_S are sequences, used for finding new values for the primary key of a table.

_A are Audit Shadow Tables.

_AVn and _ACn are Audit Shadow Views (when data was changed, and with what values).

what are the major difference between oracle 11i and R12 ?

Que: what are the major difference between oracle 11i and R12 ?

Ans :

Ø      11i only forms basis application but R12 is now forms and HTML pages.

Ø      11i is particularly in responsibility and operating unit basis but R12 is multi operating unit basis.

Ø      11i is particularly in set of books using and R12 using in ledgers.

Ø      11i in MRC Reporting level set of books called reporting set of books but in R12 reporting ledgers called as reporting currency. Banks are using at single operating unit level in 11i and ledgers level using in R12.

Differences between R12 & 11i.5.10 New R12 Upgrade to R12 – Pros and Cons Pros:

o       Sub-ledger Accounting – The new Oracle Sub-ledger Accounting (SLA) architecture allows users to customize the standard Oracle accounting entries. As a result of Cost Management's uptake of this new architecture, users can customize their accounting for Receiving, Inventory and Manufacturing transactions.

o       Enhanced Reporting Currency (MRC) Functionality – Multiple Reporting Currencies functionality is enhanced to support all journal sources. Reporting sets of books in R12 are now simply reporting currencies. Every journal that is posted in the primary currency of a ledger can be automatically converted into one or more reporting currencies.

o       Deferred COGS and Revenue Matching – R12 provides the ability to automatically maintain the same recognition rules for COGS and revenue for each sales order line for each period. Deferred COGS and Deferred Revenue are thus kept in synch.

Cons:

o       Resources – Availability of knowledgeable resources

o       Maturity – Though R12 is around since 2007, not all the modules are mature enough meaning modules like E-B Tax have many bugs being fixed by Oracle development.

o       Integration with customized applications – In a customized environment, all the extensions & interfaces need to be analyzed because of the architectural changes in R12

      R12 Features and differences with 11.5.10 – Inventory / Cost Management

o       Multi-Organization Access Control (MOAC) - Multi-Org Access Control enables uses to access multiple operating units data from single responsibility. Users can access reports , Concurrent programs , all setup screens of multiple operating units from single responsibility without switching responsibilities.

o       Unified Inventory - R12 merges Oracle Process Manufacturing OPM Inventory and Oracle Inventory applications into a single version . So OPM users can leverage the functionalities such as consigned & VMI and center led procurement which were available only to discrete inventory in 11i.5.10.

o       Inventory valuation Reports -There are a significant number of reports which have been enhanced in the area of Inventory Value Reporting

o       Inventory Genealogy - Enhanced genealogy tracking with simplified, complete access at the component level to critical lot and serial information for material throughout production.

o       Fixed Component Usage Materials Enhancement – Enhanced BOM setup screen and WIP Material Requirement screen that support materials having a fixed usage irrespective of the job size for WIP Jobs, OSFM lot-based jobs, or Flow Manufacturing

o       Component Yield Enhancements - New functionality that provides flexibility to control the value of component yield factors at WIP job level. This feature allows the user to include or exclude yield factor while calculating back flush transactions.

o       Periodic Average Cost Absorption Enhancements – Enhanced functionality for WIP Final Completion, WIP Scrap Absorption, PAC WIP Value Report, Material Overhead Absorption Rule, EAM work order, and PAC EAM Work Order Cost Estimate Processor Report.

o       Component Yield benefits - Component yield functionality user have the flexibility to control the value of component yield factors and use those factors for back flush transactions. Of course if the yield factor is not used, yield losses can be accounted for using the manual component issue transaction.

New Features:

    R12 Features and differences with 11.5.10 – Advanced Procurement Suite

o       Professional Buyer’s Work Center – To speed up buyers’ daily purchasing tasks – view & act upon requisition demand, create & manage orders and agreements, run negotiation events, manage supplier information.

o       Freight and Miscellaneous Charges – New page for viewing acquisition cost to track freight & miscellaneous delivery cost components while receiving. Actual delivery costs are tracked during invoice matching.

o       Complex Contract Payments – Support for payments for services related procurement including progress payments, recoupment of advances, and retainage.

o       Unified Inventory – Support for the converged inventory between Oracle Process Manufacturing – OPM Inventory & Oracle Inventory.

o       Document Publishing Enhancements – Support for RTF & PDF layouts and publish contracts using user specified layouts

o       Support for Contractor Purchasing Users – Support for contingent workers to create & maintain requisitions, conduct negotiations, and purchase orders.

New Features:

      R12 Features and differences with 11.5.10 – Order Management

o       Multi-Organization Access Control (MOAC) - Multi-Org Access Control enables uses to access multiple operating units data from single responsibility. Users can access reports , Concurrent programs , all setup screens of multiple operating units from single responsibility without switching responsibilities. They can also use Order Import to bring in orders for different Operating Units from within a single responsibility. The same applies to the Oracle Order Management Public Application Program Interfaces (APIs).

o       Post Booking Item Substitution - Item Substitution functionality support has been extended to post-Booking through Scheduling/re-scheduling in Sales Order, Quick Sales Order, and Scheduling Order Organizer forms. Item Substitution functionality is also supported from Planner’s Workbench (loop-back functionality) till the line is pick-released.

o       Item Orderability - Businesses need the ability to define which customers are allowed to order which products, and the ability to apply the business logic when the order is created.

o       Mass Scheduling Enhancements – Mass Scheduling can now schedule lines that never been scheduled or those that have failed manual scheduling. Mass Scheduling also supports unscheduling and rescheduling

o       Exception Management Enhancements – Improved visibility to workflow errors and eases the process of retrying workflows that have experienced processing errors

o       Sales Order Reservation for Lot-Based Jobs – Lot-Based Jobs as a Source of Supply to Reserve Against Sales Order(s). OSFM Displays Sales Order Information on Reserved Jobs

o       Cascading Attributes – Cascading means that if the Order header attributes change, the corresponding line attributes change

o       Customer Credit Check Hold Source Support across Operating Units - Order Management honors credit holds placed on customers from AR across operating Units. When Receivables places a customer on credit hold a hold source will be created in all operating units which have:

§         A site defined for that customer

§         An order placed against that customer.

New Features:

    R12 Features and differences with 11.5.10 – Shipping

o       Pick Release/Confirm Features

§         Pick Release enhancements - Enhancements will be made to the Release Sales Order Form and the Release Rules Form to support planned crossdocking and task priority for Oracle Warehouse Management (WMS) organizations. Pick release will allow a user to specify location methods and if crossdocking is required, a cross-dock rule. The task priority will be able to be set for each task in a sales order picking wave when that wave is pick released. The priority indicated at pick release will be defaulted to every Oracle WMS task created

§         Parallel Pick Release Submission - This new feature will allow users to run multiple pick release processes in parallel to improve overall performance. By distributing the workload across multiple processors, users can reduce the overall time required for a single pick release run.

o       Workflow Shipping Transaction Enhancement – Oracle has enabled Workflow in the Shipping process for: workflow, process workflow, activity and notification workflow, and business event

o       Support for Miscellaneous Shipping Transactions - Oracle Shipping Execution users will now be able to create a delivery for a shipment that is not tied to a sales order via XML (XML-equivalent of EDI 940 IN). Once this delivery has been created, users will be able to print shipping documents, plan, rate, tender, audit and record the issuance out of inventory. Additionally, an XML Shipment Advice (XML- equivalent of EDI 945 OUT) will be supported to record the outbound transactions.

o       Flexible Documents: With this new feature ,Shipping Execution users will be able to create template-based, easy-to-use formats to quickly produce and easily maintain shipping documents unique to their business. Additional attributes will be added to the XML templates for each report for added flexibility

o       Enhanced LPN Support - Oracle Shipping Execution users will now have improved visibility to the Oracle WMS packing hierarchy at Pick Confirmation. The packing hierarchy, including the License Plate Number (LPN), will be visible in the Shipping Transactions form as well as in the Quick Ship user interface.

New Features:

R12 Features and differences with 11.5.10 – Warehouse Management

o       Crossdock Execution – WMS allow you to determine final staging lane, merge with existing delivery or create a new delivery, synchronize inbound operation plan with outbound consolidation plan, enhance outbound consolidation plans and manage crossdock tasks.

o       Labor Management – WMS provides labor analysis. It gives the warehouse manager increased visibility to resource requirements. Detailed information for the productivity of individual employees and warehouses is provided

o       Warehouse Control Board Additions - Additional Task selection criteria

o       User Extensible Label Fields – WMS, users are now able to add their own variables without customizing the application, by simply defining in SQL the way to get to that data element

o       Material Consolidation across deliveries – WMS allows you to consolidate material across deliveries in a staging lane

New Features:

    R12 Features and differences with 11.5.10 – OSFM

o       Lot and Serial Controlled Assembly– Lot controlled job can now be associated with serial numbers to track and trace serialized lot/item during shop floor transactions as well as post manufacturing and beyond

o       Fixed Component Usage Support for Lot Based Jobs – OSFM now supports fixed component usage defined in the Bill of Material of an end it.

o       Support for Partial Move Transactions – Users are able to execute movement of a partial job quantity interoperation

o       Enhanced BOM to Capture Inverse Usage – Users can now capture the inverse component usage through the new inverse usage field in BOM UI

o       Support for Rosetta Net Transaction - comprising of 7B1 (work in process) and 7B5 (manufacturing work order).

New Features:

     R12 – Further Info…

o       The latest RCD (Release Content Documents) can be accessed from the metalink note 404152.1 (requires user name & password).

o       The TOI (Transfer Of Information) sessions released by Oracle Learning can be accessed from its portal at http:// www.oracle.com/education/oukc/ebs.html

o       Oracle White papers – Extending the value of Your Oracle E-Business Suite 11i.10 Investment & Application Upgrades and Service Oriented Architecture