DROP TYPE FCT_CCUSTO_CONTRATO_REL_TABLE
/

DROP TYPE FCT_CCUSTO_CONTRATO_REL_TYPE
/

CREATE TYPE FCT_CCUSTO_CONTRATO_REL_TYPE AS OBJECT (
    NRSEQCONTRATO      NUMBER,
	NRCONTRATOFCT      VARCHAR2(30),
	NRSEQMODCONTRA     NUMBER,
	NMMODCONTRATO      VARCHAR2(100),
	IDSITUACAOCONTRATO VARCHAR2(1),
	DTAPROVACAO       DATE,
	NRTIPOORCAMENTO    NUMBER,
	NMTIPOORCAMENTO    VARCHAR2(100),
	NRPARCNEGOCIO      NUMBER,
	NMPRINCIPALPARC    VARCHAR2(250),
	NMSECUNDARIPARC	   VARCHAR2(250),	   
	NRINSCRICAOPARC    VARCHAR2(20),
	CDOPERRESPONSAVEL  VARCHAR2(12),
	NMOPERADOR  VARCHAR2(250),
	NRORCAMENTO        VARCHAR2(30),
	NMORCAMENTOMODELO  VARCHAR2(250),
	DTACEITEORCA       DATE,
	NMITEMCONTRATO     VARCHAR2(250),
	CDSERVORCA         NUMBER,
	NMSERVORCA         VARCHAR2(250),
	QTMEDIDACALCULADA  NUMBER,
	CDTPMEDIDAVARIAVEL NUMBER,
    DSTPMEDIDAVARIAVEL VARCHAR2(250),
	VRTOTITEMCONT      NUMBER,
	IDATIVO            VARCHAR2(1),
	CDCENTCUST         VARCHAR2(4),
	NMCENTCUST         VARCHAR2(100),
	PERCCENTCUSTCONTR  NUMBER,
	VRCENTCUSTITEM     NUMBER
)
/

CREATE TYPE FCT_CCUSTO_CONTRATO_REL_TABLE AS TABLE OF FCT_CCUSTO_CONTRATO_REL_TYPE
/
