-- 1단계만 (VIEW 안에 VIEW, FUNCTION 등이 있는 경우 계층쿼리로 수정하여 조회)
SELECT  b.owner,
        b.object_name,
        b.object_type
FROM    
        (select referenced_object_id
         from   all_objects a,
                public_dependency b
         where  a.owner = :owner
         and    a.object_name = :objectName
         and    a.object_id = b.object_id) a,  
        all_objects b 
where   a.referenced_object_id = b.object_id;

-- 또는 view source 확인
SELECT text
FROM all_views
WHERE view_name = :viewName;