CREATE TABLE "IFSAPP"."MATLIST2" 
   (	"LOC" VARCHAR2(1000 BYTE), 
	"QTY" VARCHAR2(1000 BYTE), 
	"LIN" VARCHAR2(1000 BYTE), 
	"PART_" VARCHAR2(1000 BYTE), 
	"SHOP_ORD" VARCHAR2(1000 BYTE), 
	"PICK_KEY" VARCHAR2(1000 BYTE), 
	"QTY_REQ" VARCHAR2(200 BYTE)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "IFSAPP_DATA" ;
REM INSERTING into IFSAPP.MATLIST2
SET DEFINE OFF;
Insert into IFSAPP.MATLIST2 (LOC,QTY,LIN,PART_,SHOP_ORD,PICK_KEY,QTY_REQ) values ('10800B41','4','14','1020123','49507','24377',null);
Insert into IFSAPP.MATLIST2 (LOC,QTY,LIN,PART_,SHOP_ORD,PICK_KEY,QTY_REQ) values ('10800A01','2','14','1020123','49507','24377',null);
Insert into IFSAPP.MATLIST2 (LOC,QTY,LIN,PART_,SHOP_ORD,PICK_KEY,QTY_REQ) values ('10800B01','2','14','1020123','49507','24377',null);
Insert into IFSAPP.MATLIST2 (LOC,QTY,LIN,PART_,SHOP_ORD,PICK_KEY,QTY_REQ) values ('10800B21','2','14','1020123','49507','24377',null);
Insert into IFSAPP.MATLIST2 (LOC,QTY,LIN,PART_,SHOP_ORD,PICK_KEY,QTY_REQ) values ('10800B61','2','14','1020123','49507','24377',null);
Insert into IFSAPP.MATLIST2 (LOC,QTY,LIN,PART_,SHOP_ORD,PICK_KEY,QTY_REQ) values ('10800A01','1','14','1020123','49507','24377',null);
Insert into IFSAPP.MATLIST2 (LOC,QTY,LIN,PART_,SHOP_ORD,PICK_KEY,QTY_REQ) values ('10800A21','1','14','1020123','49507','24377',null);
Insert into IFSAPP.MATLIST2 (LOC,QTY,LIN,PART_,SHOP_ORD,PICK_KEY,QTY_REQ) values ('10800B21','1','14','1020123','49507','24377',null);