CREATE OR REPLACE VIEW OE.ACCOUNT_MANAGERS AS 
SELECT          c.account_mgr_id                ACCT_MGR,
                cr.region_id                    REGION,
                c.cust_address.country_id       COUNTRY,
                c.cust_address.state_province   PROVINCE,
                count(*)                        NUM_CUSTOMERS
FROM            customers c, countries cr
WHERE           c.cust_address.country_id = cr.country_id
GROUP BY ROLLUP (c.account_mgr_id,
                 cr.region_id,
                 c.cust_address.country_id,
                 c.cust_address.state_province)

CREATE OR REPLACE VIEW IX.AQ$ORDERS_QUEUETABLE AS 
SELECT  q_name QUEUE, qt.msgid MSG_ID, corrid CORR_ID,  priority MSG_PRIORITY,  decode(h.dequeue_time, NULL,	  
			      (decode(state, 0,   'READY',	     
                              		     1,   'WAIT',	     
					     2,   'PROCESSED',	     
                                             3,   'EXPIRED',
                                             8,   'DEFERRED')),      
  			      (decode(h.transaction_id,     
				      NULL, 'UNDELIVERABLE',	  
				      'PROCESSED'))) MSG_STATE,  cast(FROM_TZ(qt.delay, '-08:00')
                 at time zone sessiontimezone as date) delay,  delay DELAY_TIMESTAMP, expiration,  cast(FROM_TZ(qt.enq_time, '-08:00')
                 at time zone sessiontimezone as date) enq_time,  cast(FROM_TZ(qt.enq_time, '-08:00')
                 at time zone sessiontimezone as timestamp)
                 enq_timestamp,   enq_uid ENQ_USER_ID,  enq_tid ENQ_TXN_ID,  decode(h.transaction_id, NULL, TO_DATE(NULL), 	  
                        cast(FROM_TZ(h.dequeue_time, '-08:00')
            

CREATE OR REPLACE VIEW IX.AQ$ORDERS_QUEUETABLE_R AS 
SELECT queue_name QUEUE, s.name NAME , address ADDRESS , protocol PROTOCOL, rule_condition RULE, ruleset_name RULE_SET, trans_name TRANSFORMATION  FROM "AQ$_ORDERS_QUEUETABLE_S" s , sys.all_rules r WHERE (bitand(s.subscriber_type, 1) = 1) AND s.rule_name = r.rule_name and r.rule_owner = 'IX'  WITH READ ONLY

CREATE OR REPLACE VIEW IX.AQ$ORDERS_QUEUETABLE_S AS 
SELECT queue_name QUEUE, name NAME , address ADDRESS , protocol PROTOCOL, trans_name TRANSFORMATION  FROM "AQ$_ORDERS_QUEUETABLE_S" s  WHERE (bitand(s.subscriber_type, 1) = 1)  WITH READ ONLY

CREATE OR REPLACE VIEW IX.AQ$STREAMS_QUEUE_TABLE AS 
SELECT  q_name QUEUE, qt.msgid MSG_ID, corrid CORR_ID,  priority MSG_PRIORITY,  decode(h.dequeue_time, NULL,	  
			      (decode(state, 0,   'READY',	     
                              		     1,   'WAIT',	     
					     2,   'PROCESSED',	     
                                             3,   'EXPIRED',
                                             8,   'DEFERRED')),      
  			      (decode(h.transaction_id,     
				      NULL, 'UNDELIVERABLE',	  
				      'PROCESSED'))) MSG_STATE,  cast(FROM_TZ(qt.delay, '-08:00')
                 at time zone sessiontimezone as date) delay,  delay DELAY_TIMESTAMP, expiration,  cast(FROM_TZ(qt.enq_time, '-08:00')
                 at time zone sessiontimezone as date) enq_time,  cast(FROM_TZ(qt.enq_time, '-08:00')
                 at time zone sessiontimezone as timestamp)
                 enq_timestamp,   enq_uid ENQ_USER_ID,  enq_tid ENQ_TXN_ID,  decode(h.transaction_id, NULL, TO_DATE(NULL), 	  
                        cast(FROM_TZ(h.dequeue_time, '-08:00')
            

CREATE OR REPLACE VIEW IX.AQ$STREAMS_QUEUE_TABLE_R AS 
SELECT queue_name QUEUE, s.name NAME , address ADDRESS , protocol PROTOCOL, rule_condition RULE, ruleset_name RULE_SET, trans_name TRANSFORMATION  FROM "AQ$_STREAMS_QUEUE_TABLE_S" s , sys.all_rules r WHERE (bitand(s.subscriber_type, 1) = 1) AND s.rule_name = r.rule_name and r.rule_owner = 'IX'  WITH READ ONLY

CREATE OR REPLACE VIEW IX.AQ$STREAMS_QUEUE_TABLE_S AS 
SELECT queue_name QUEUE, name NAME , address ADDRESS , protocol PROTOCOL, trans_name TRANSFORMATION  FROM "AQ$_STREAMS_QUEUE_TABLE_S" s  WHERE (bitand(s.subscriber_type, 1) = 1)  WITH READ ONLY

CREATE OR REPLACE VIEW OE.BOMBAY_INVENTORY AS 
SELECT p.product_id
,      p.product_name
,      i.quantity_on_hand
FROM   inventories i
,      warehouses  w
,      products    p
WHERE  p.product_id = i.product_id
AND    i.warehouse_id = w.warehouse_id
AND    w.warehouse_name = 'Bombay'

CREATE OR REPLACE VIEW OE.CUSTOMERS_VIEW AS 
SELECT
  c.customer_id,
  c.cust_first_name,
  c.cust_last_name,
  c.cust_address.street_address street_address,
  c.cust_address.postal_code postal_code,
  c.cust_address.city city,
  c.cust_address.state_province state_province,
  co.country_id,
  co.country_name,
  co.region_id,
  c.nls_language,
  c.nls_territory,
  c.credit_limit,
  c.cust_email,
  substr(get_phone_number_f(1,phone_numbers),1,25) Primary_Phone_number,
  substr(get_phone_number_f(2,phone_numbers),1,25) Phone_number_2,
  substr(get_phone_number_f(3,phone_numbers),1,25) Phone_number_3,
  substr(get_phone_number_f(4,phone_numbers),1,25) Phone_number_4,
  substr(get_phone_number_f(5,phone_numbers),1,25) Phone_number_5,
  c.account_mgr_id,
  c.cust_geo_location.sdo_gtype location_gtype,
  c.cust_geo_location.sdo_srid location_srid,
  c.cust_geo_location.sdo_point.x location_x,
  c.cust_geo_location.sdo_point.y location_y,
  c.cust_geo_location.sdo_point.z location_z
FROM
  countries co,
  customers c
WHERE
  c.cust_address.country_id = co.coun

CREATE OR REPLACE VIEW OE.DEPTVIEW AS 
SELECT xmlelement("Department", xmlForest(department_name, location_id),
       (SELECT sys_xmlagg(xmlelement("Employee",xmlForest(last_name,
                                                           job_id,manager_id,
                                                           hire_date,
                                                           salary,
                                                           commission_pct)
                                    ), xmlformat('EmployeeList'))
        FROM employees e WHERE e.department_id = d.department_id
       )) xml
FROM departments d

CREATE OR REPLACE VIEW HR.EMP_DETAILS_VIEW AS 
SELECT
  e.employee_id,
  e.job_id,
  e.manager_id,
  e.department_id,
  d.location_id,
  l.country_id,
  e.first_name,
  e.last_name,
  e.salary,
  e.commission_pct,
  d.department_name,
  j.job_title,
  l.city,
  l.state_province,
  c.country_name,
  r.region_name
FROM
  employees e,
  departments d,
  jobs j,
  locations l,
  countries c,
  regions r
WHERE e.department_id = d.department_id
  AND d.location_id = l.location_id
  AND l.country_id = c.country_id
  AND c.region_id = r.region_id
  AND j.job_id = e.job_id
WITH READ ONLY

CREATE OR REPLACE VIEW OE.OC_CORPORATE_CUSTOMERS AS 
SELECT c.customer_id, c.cust_first_name, c.cust_last_name,
              c.cust_address, c.phone_numbers,c.nls_language,c.nls_territory,
              c.credit_limit, c.cust_email,
              CAST(MULTISET(SELECT o.order_id, o.order_mode,
                               MAKE_REF(oc_customers,o.customer_id),
                               o.order_status,
                               o.order_total,o.sales_rep_id,
                               CAST(MULTISET(SELECT l.order_id,l.line_item_id,
                                         l.unit_price,l.quantity,
                                         make_ref(oc_product_information,
                                                    l.product_id)
                                             FROM order_items l
                                             WHERE o.order_id = l.order_id)
                                    AS order_item_list_typ)
                            FROM orders o
                            WHERE c.customer_id = o.customer_id)
             

CREATE OR REPLACE VIEW OE.OC_CUSTOMERS AS 
SELECT c.customer_id, c.cust_first_name, c.cust_last_name, c.cust_address,
           c.phone_numbers,c.nls_language,c.nls_territory,c.credit_limit,
           c.cust_email,
           CAST(MULTISET(SELECT o.order_id, o.order_mode,
                               MAKE_REF(oc_customers,o.customer_id),
                               o.order_status,
                               o.order_total,o.sales_rep_id,
                               CAST(MULTISET(SELECT l.order_id,l.line_item_id,
                                                    l.unit_price,l.quantity,
                                             MAKE_REF(oc_product_information,
                                                      l.product_id)
                                             FROM order_items l
                                             WHERE o.order_id = l.order_id)
                                    AS order_item_list_typ)
                         FROM orders o
                         WHERE c.customer_id = o.customer_id)
            

CREATE OR REPLACE VIEW OE.OC_INVENTORIES AS 
SELECT i.product_id,
           warehouse_typ(w.warehouse_id, w.warehouse_name, w.location_id),
           i.quantity_on_hand
    FROM inventories i, warehouses w
    WHERE i.warehouse_id=w.warehouse_id

CREATE OR REPLACE VIEW OE.OC_ORDERS AS 
SELECT o.order_id, o.order_mode,MAKE_REF(oc_customers,o.customer_id),
        o.order_status,o.order_total,o.sales_rep_id,
       CAST(MULTISET(SELECT l.order_id,l.line_item_id,l.unit_price,l.quantity,
                       make_ref(oc_product_information,l.product_id)
                     FROM order_items l
                     WHERE o.order_id = l.order_id)
            AS order_item_list_typ)
    FROM orders o

CREATE OR REPLACE VIEW OE.OC_PRODUCT_INFORMATION AS 
SELECT p.product_id, p.product_name, p.product_description, p.category_id,
           p.weight_class, p.warranty_period, p.supplier_id, p.product_status,
           p.list_price, p.min_price, p.catalog_url,
           CAST(MULTISET(SELECT i.product_id,i.warehouse,i.quantity_on_hand
                         FROM oc_inventories i
                         WHERE p.product_id=i.product_id)
                AS inventory_list_typ)
    FROM product_information p

CREATE OR REPLACE VIEW OE.ORDERS_VIEW AS 
SELECT
  order_id,
  TO_DATE(TO_CHAR(order_date,'DD-MON-YY HH:MI:SS'),'DD-MON-YY HH:MI:SS') ORDER_DATE,
  order_mode,
  customer_id,
  order_status,
  order_total,
  sales_rep_id,
  promotion_id
FROM orders

CREATE OR REPLACE VIEW OE.PRODUCT_PRICES AS 
SELECT category_id
,      COUNT(*)        as "#_OF_PRODUCTS"
,      MIN(list_price) as low_price
,      MAX(list_price) as high_price
FROM   product_information
GROUP BY category_id

CREATE OR REPLACE VIEW OE.PRODUCTS AS 
SELECT i.product_id
,      d.language_id
,      CASE WHEN d.language_id IS NOT NULL
            THEN d.translated_name
            ELSE TRANSLATE(i.product_name USING NCHAR_CS)
       END    AS product_name
,      i.category_id
,      CASE WHEN d.language_id IS NOT NULL
            THEN d.translated_description
            ELSE TRANSLATE(i.product_description USING NCHAR_CS)
       END    AS product_description
,      i.weight_class
,      i.warranty_period
,      i.supplier_id
,      i.product_status
,      i.list_price
,      i.min_price
,      i.catalog_url
FROM   product_information  i
,      product_descriptions d
WHERE  d.product_id  (+) = i.product_id
AND    d.language_id (+) = sys_context('USERENV','LANG')

CREATE OR REPLACE VIEW SH.PROFITS AS 
SELECT
        s.channel_id,
        s.cust_id,
        s.prod_id,
        s.promo_id,
        s.time_id,
        c.unit_cost,
        c.unit_price,
        s.amount_sold,
        s.quantity_sold,
        c.unit_cost * s.quantity_sold TOTAL_COST
 FROM   costs c, sales s
 WHERE c.prod_id = s.prod_id
   AND c.time_id = s.time_id
   AND c.channel_id = s.channel_id
   AND c.promo_id = s.promo_id

CREATE OR REPLACE VIEW OE.SYDNEY_INVENTORY AS 
SELECT p.product_id
,      p.product_name
,      i.quantity_on_hand
FROM   inventories i
,      warehouses  w
,      products    p
WHERE  p.product_id = i.product_id
AND    i.warehouse_id = w.warehouse_id
AND    w.warehouse_name = 'Sydney'

CREATE OR REPLACE VIEW OE.TORONTO_INVENTORY AS 
SELECT p.product_id
,      p.product_name
,      i.quantity_on_hand
FROM   inventories i
,      warehouses  w
,      products    p
WHERE  p.product_id = i.product_id
AND    i.warehouse_id = w.warehouse_id
AND    w.warehouse_name = 'Toronto'

CREATE OR REPLACE PROCEDURE add_job_history
  (  p_emp_id          job_history.employee_id%type
   , p_start_date      job_history.start_date%type
   , p_end_date        job_history.end_date%type
   , p_job_id          job_history.job_id%type
   , p_department_id   job_history.department_id%type
   )
IS
BEGIN
  INSERT INTO job_history (employee_id, start_date, end_date,
                           job_id, department_id)
    VALUES(p_emp_id, p_start_date, p_end_date, p_job_id, p_department_id);
END add_job_history;

CREATE OR REPLACE PROCEDURE secure_dml
IS
BEGIN
  IF TO_CHAR (SYSDATE, 'HH24:MI') NOT BETWEEN '08:00' AND '18:00'
        OR TO_CHAR (SYSDATE, 'DY') IN ('SAT', 'SUN') THEN
	RAISE_APPLICATION_ERROR (-20205,
		'You may only make changes during normal office hours');
  END IF;
END secure_dml;

CREATE OR REPLACE FUNCTION get_phone_number_f
  (p_in INTEGER, p_phonelist phone_list_typ)
RETURN VARCHAR2 AS
  TYPE phone_list IS VARRAY(5) OF VARCHAR2(25);
  phone_out varchar2(25) := null;
  v_size INTEGER;
BEGIN
    IF p_phonelist.FIRST IS NULL OR
       p_in > (p_phonelist.LAST + 1) - p_phonelist.FIRST THEN
      RETURN phone_out;
    ELSE
      phone_out := p_phonelist(p_in);
      RETURN phone_out;
    END IF;
END;

CREATE OR REPLACE TYPE "ADHEADER_TYP"                                                                                                                     AS OBJECT
    ( header_name        VARCHAR2(256)
    , creation_date      DATE
    , header_text        VARCHAR2(1024)
    , logo               BLOB
    );

CREATE OR REPLACE TYPE catalog_typ
                                         UNDER composite_category_typ
      (
    MEMBER FUNCTION getCatalogName RETURN VARCHAR2
       , OVERRIDING MEMBER FUNCTION category_describe RETURN VARCHAR2
      );TYPE BODY catalog_typ AS
  OVERRIDING MEMBER FUNCTION category_describe RETURN varchar2 IS
  BEGIN
    RETURN 'catalog_typ';
  END;
  MEMBER FUNCTION getCatalogName RETURN varchar2 IS
  BEGIN
    -- Return the category name from the supertype
    RETURN self.category_name;
  END;
END;

CREATE OR REPLACE TYPE category_typ
                                         AS OBJECT
    ( category_name           VARCHAR2(50)
    , category_description    VARCHAR2(1000)
    , category_id             NUMBER(2)
    , NOT instantiable
      MEMBER FUNCTION category_describe RETURN VARCHAR2
      )
  NOT INSTANTIABLE NOT FINAL
 ALTER TYPE category_typ
 ADD ATTRIBUTE (parent_category_id number(2)) CASCADE

CREATE OR REPLACE TYPE composite_category_typ
                                         UNDER category_typ
      (
    subcategory_ref_list subcategory_ref_list_typ
      , OVERRIDING MEMBER FUNCTION  category_describe RETURN VARCHAR2
      )
  NOT FINAL;TYPE BODY composite_category_typ  AS
    OVERRIDING MEMBER FUNCTION category_describe RETURN VARCHAR2 IS
    BEGIN
      RETURN 'composite_category_typ';
    END;
   END;

CREATE OR REPLACE TYPE corporate_customer_typ
                                         UNDER customer_typ
      ( account_mgr_id     NUMBER(6)
      );

CREATE OR REPLACE TYPE "CUST_ADDRESS_TYP"                                                                                                                     AS OBJECT
    ( street_address     VARCHAR2(40)
    , postal_code        VARCHAR2(10)
    , city               VARCHAR2(30)
    , state_province     VARCHAR2(10)
    , country_id         CHAR(2)
    );

CREATE OR REPLACE TYPE customer_typ
 AS OBJECT
    ( customer_id        NUMBER(6)
    , cust_first_name    VARCHAR2(20)
    , cust_last_name     VARCHAR2(20)
    , cust_address       cust_address_typ
    , phone_numbers      phone_list_typ
    , nls_language       VARCHAR2(3)
    , nls_territory      VARCHAR2(30)
    , credit_limit       NUMBER(9,2)
    , cust_email         VARCHAR2(30)
    , cust_orders        order_list_typ
    )
NOT FINAL;

CREATE OR REPLACE TYPE inventory_list_typ
                                         AS TABLE OF inventory_typ;

CREATE OR REPLACE TYPE inventory_typ
                                         AS OBJECT
    ( product_id          NUMBER(6)
    , warehouse           warehouse_typ
    , quantity_on_hand    NUMBER(8)
    ) ;

CREATE OR REPLACE TYPE leaf_category_typ
                                         UNDER category_typ
    (
    product_ref_list    product_ref_list_typ
    , OVERRIDING MEMBER FUNCTION  category_describe RETURN VARCHAR2
    );TYPE BODY leaf_category_typ AS
    OVERRIDING MEMBER FUNCTION  category_describe RETURN VARCHAR2 IS
    BEGIN
       RETURN  'leaf_category_typ';
    END;
   END;

CREATE OR REPLACE TYPE "ORDER_EVENT_TYP"                                                                          AS OBJECT (
	order_id 	NUMBER(12),
	product_id  	NUMBER(6),
	customer_id	NUMBER(6),
	cust_first_name	VARCHAR2(20),
	cust_last_name	VARCHAR2(20),
	order_status  	NUMBER(2),
	delivery_date	DATE
);

CREATE OR REPLACE TYPE order_item_list_typ
                                         AS TABLE OF order_item_typ;

CREATE OR REPLACE TYPE order_item_typ
                                         AS OBJECT
    ( order_id           NUMBER(12)
    , line_item_id       NUMBER(3)
    , unit_price         NUMBER(8,2)
    , quantity           NUMBER(8)
    , product_ref  REF   product_information_typ
    ) ;

CREATE OR REPLACE TYPE order_list_typ
                                         AS TABLE OF order_typ;

CREATE OR REPLACE TYPE order_typ
                                         AS OBJECT
    ( order_id           NUMBER(12)
    , order_mode         VARCHAR2(8)
    , customer_ref  REF  customer_typ
    , order_status       NUMBER(2)
    , order_total        NUMBER(8,2)
    , sales_rep_id       NUMBER(6)
    , order_item_list    order_item_list_typ
    ) ;

CREATE OR REPLACE TYPE "PHONE_LIST_TYP"                                                                                                                     AS VARRAY(5) OF VARCHAR2(25);

CREATE OR REPLACE TYPE product_information_typ
                                         AS OBJECT
    ( product_id           NUMBER(6)
    , product_name         VARCHAR2(50)
    , product_description  VARCHAR2(2000)
    , category_id          NUMBER(2)
    , weight_class         NUMBER(1)
    , warranty_period      INTERVAL YEAR(2) TO MONTH
    , supplier_id          NUMBER(6)
    , product_status       VARCHAR2(20)
    , list_price           NUMBER(8,2)
    , min_price            NUMBER(8,2)
    , catalog_url          VARCHAR2(50)
    , inventory_list       inventory_list_typ
    ) ;

CREATE OR REPLACE TYPE product_ref_list_typ
                                         AS TABLE OF number(6);

CREATE OR REPLACE TYPE subcategory_ref_list_typ
                                         AS TABLE OF REF category_typ;

CREATE OR REPLACE type      "SYS_YOID0000050342$" as object( "SYS_NC00001$" NUMBER(6,0))

CREATE OR REPLACE type      "SYS_YOID0000050344$" as object( "SYS_NC00001$" NUMBER(6,0))

CREATE OR REPLACE type      "SYS_YOID0000050346$" as object( "SYS_NC00001$" NUMBER(6,0))

CREATE OR REPLACE type      "SYS_YOID0000050348$" as object( "SYS_NC00001$" NUMBER(6,0))

CREATE OR REPLACE type      "SYS_YOID0000050350$" as object( "SYS_NC00001$" NUMBER(12,0))

CREATE OR REPLACE TYPE "TEXTDOC_TAB"                                                                                                                     AS TABLE OF textdoc_typ;

CREATE OR REPLACE TYPE "TEXTDOC_TYP"                                                                                                                     AS OBJECT
    ( document_typ      VARCHAR2(32)
    , formatted_doc     BLOB
    ) ;

CREATE OR REPLACE TYPE warehouse_typ
                                         AS OBJECT
    ( warehouse_id       NUMBER(3)
    , warehouse_name     VARCHAR2(35)
    , location_id        NUMBER(4)
    ) ;

CREATE OR REPLACE TYPE      "XDBPO_ACTION_COLLECTION" AS VARRAY(4) OF "XDBPO_ACTION_TYPE"

CREATE OR REPLACE TYPE      "XDBPO_ACTION_TYPE" AS OBJECT ("SYS_XDBPD$" "XDB"."XDB$RAW_LIST_T","Manager" VARCHAR2(10 CHAR),"Date" DATE)FINAL INSTANTIABLE 

CREATE OR REPLACE TYPE      "XDBPO_ACTIONS_TYPE" AS OBJECT ("SYS_XDBPD$" "XDB"."XDB$RAW_LIST_T","ACTION" "XDBPO_ACTION_COLLECTION")NOT FINAL INSTANTIABLE 

CREATE OR REPLACE TYPE      "XDBPO_LINEITEM_COLLECTION" AS VARRAY(2147483647) OF "XDBPO_LINEITEM_TYPE"

CREATE OR REPLACE TYPE      "XDBPO_LINEITEM_TYPE" AS OBJECT ("SYS_XDBPD$" "XDB"."XDB$RAW_LIST_T","ITEMNUMBER" NUMBER(38),"Description" VARCHAR2(256 CHAR),"Part" "XDBPO_PART_TYPE")NOT FINAL INSTANTIABLE 

CREATE OR REPLACE TYPE      "XDBPO_LINEITEMS_TYPE" AS OBJECT ("SYS_XDBPD$" "XDB"."XDB$RAW_LIST_T","LINEITEM" "XDBPO_LINEITEM_COLLECTION")NOT FINAL INSTANTIABLE 

CREATE OR REPLACE TYPE      "XDBPO_PART_TYPE" AS OBJECT ("SYS_XDBPD$" "XDB"."XDB$RAW_LIST_T","PARTNO" VARCHAR2(14 CHAR),"Quantity" NUMBER(12,2),"UNITPRICE" NUMBER(8,4))FINAL INSTANTIABLE 

CREATE OR REPLACE TYPE      "XDBPO_REJECTION_TYPE" AS OBJECT ("SYS_XDBPD$" "XDB"."XDB$RAW_LIST_T","Manager" VARCHAR2(10 CHAR),"Date" DATE,"Comments" VARCHAR2(2048 CHAR))NOT FINAL INSTANTIABLE 

CREATE OR REPLACE TYPE      "XDBPO_SHIPINSTRUCTIONS_TYPE" AS OBJECT ("SYS_XDBPD$" "XDB"."XDB$RAW_LIST_T","name" VARCHAR2(20 CHAR),"address" VARCHAR2(256 CHAR),"telephone" VARCHAR2(24 CHAR))NOT FINAL INSTANTIABLE 

CREATE OR REPLACE TYPE      "XDBPO_TYPE" AS OBJECT ("SYS_XDBPD$" "XDB"."XDB$RAW_LIST_T","Reference" VARCHAR2(30 CHAR),"ACTIONS" "XDBPO_ACTIONS_TYPE","REJECTION" "XDBPO_REJECTION_TYPE","Requestor" VARCHAR2(128 CHAR),"EmployeeID" NUMBER(38),"DepartmentID" VARCHAR2(4 CHAR),"SHIPPINGINSTRUCTIONS" "XDBPO_SHIPINSTRUCTIONS_TYPE","SpecialInstructions" VARCHAR2(2048 CHAR),"LINEITEMS" "XDBPO_LINEITEMS_TYPE")FINAL INSTANTIABLE 

CREATE SEQUENCE IX.AQ$_ORDERS_QUEUETABLE_N
INCREMENT BY 1
START WITH 1
MAXVALUE 
CACHE  CYCLE
						

CREATE SEQUENCE IX.AQ$_STREAMS_QUEUE_TABLE_N
INCREMENT BY 1
START WITH 1
MAXVALUE 
CACHE  CYCLE
						

CREATE SEQUENCE HR.DEPARTMENTS_SEQ
INCREMENT BY 10
START WITH 1
MAXVALUE 9990
CACHE  CYCLE
						

CREATE SEQUENCE HR.EMPLOYEES_SEQ
INCREMENT BY 1
START WITH 1
MAXVALUE 
CACHE  CYCLE
						

CREATE SEQUENCE HR.LOCATIONS_SEQ
INCREMENT BY 100
START WITH 1
MAXVALUE 9900
CACHE  CYCLE
						

CREATE SEQUENCE OE.ORDERS_SEQ
INCREMENT BY 1
START WITH 1
MAXVALUE 
CACHE  CYCLE