CREATE GLOBAL TEMPORARY TABLE TMP_PEDCOLETA
(
   CDREGIAO       VARCHAR2(4),     
   NMREGIAO       VARCHAR2(30),
   CDOPERADOR     VARCHAR2(20),   
   NMOPERADOR     VARCHAR2(40),
   CDFORNECED     VARCHAR2(21),   
   NRINSJURFORN   VARCHAR2(14), 
   IDTPIJURFORN   VARCHAR2(3), 
   NMRAZSOCFORN   VARCHAR2(100),
   NMFANTFORN     VARCHAR2(40),
   CDPRODUTO      VARCHAR2(20),
   NMPRODUTO      VARCHAR2(50),    
   SGUNIDADE      VARCHAR2(12),
   CDPRODESTO     VARCHAR2(20),   
   IDTPFRETFORN   VARCHAR2(3),
   CDMARCA        VARCHAR2(5),      
   NMMARCA        VARCHAR2(20),
   CDMARCAPADR    VARCHAR2(5),  
   CDARVPROD      VARCHAR2(12),
   QTACOMPRAR     FLOAT,
   NRCOMPRA       VARCHAR2(20)
) ON COMMIT PRESERVE ROWS
/

ALTER TABLE TMP_PEDCOLETA MODIFY CDFORNECED VARCHAR2(21)