DBA Data[Home] [Help]

APPS.EDW_FACT_SV dependencies on EDW_SOURCE_VIEWS

Line 30: FROM edw_source_views

26: viewname VARCHAR2(300);
27:
28: CURSOR c_getViewNamesForFact(p_fact_name in varchar2) IS
29: SELECT flex_view_name, generated_view_name, collection_view_name
30: FROM edw_source_views
31: WHERE upper(object_name) = p_fact_name
32: AND version =edw_gen_view.g_version;
33:
34: BEGIN