CREATE OR REPLACE VIEW FUNC_MEDICO(
CDEMPRESA,CDFILIAL,CDFUNC,NMFUNC,
CDCARGO,NMCARGO)
AS
	SELECT FU.CDEMPRESA,FU.CDFILIAL,FU.CDFUNC,
          FU.NMFUNC,FU.CDCARGO,CA.NMCARGO
   FROM FUNCIONARIO FU, CARGO CA, PARGERALHOSP PG
   WHERE (FU.CDCARGO     = CA.CDCARGO     ) AND
         (CA.CDTIPOCARGO = PG.CDTIPOCARMED)
/
