--ABSN-7208
DROP TYPE T_CONTRACTPRICE_TAB;

DROP TYPE T_CONTRACTPRICE;

CREATE OR REPLACE TYPE T_CONTRACTPRICE AS OBJECT
(
 CONTRACT_ID        NUMBER,
 PRICETYPE          NUMBER, 
 PRICEDATE          DATE, 
 PRODUCT_ID         NUMBER,
 SIZEDEFINITION_ID  NUMBER, 
 FINISHINGMETHOD_ID NUMBER, 
 PRICE              NUMBER(15,6)
);

CREATE OR REPLACE TYPE T_CONTRACTPRICE_TAB AS TABLE OF T_CONTRACTPRICE;
