DBA Data[Home] [Help]

APPS.EDW_GEN_VIEW dependencies on USER_VIEWS

Line 1503: SELECT count(1) into l_dummy from user_views where view_name='EDW_DIMENSIONS_MD_V';

1499: END IF;
1500:
1501: /* Validate Object Type */
1502:
1503: SELECT count(1) into l_dummy from user_views where view_name='EDW_DIMENSIONS_MD_V';
1504:
1505: IF (l_dummy > 0) THEN /* EDW_DIMENSIONS_MD_V exists */
1506: open cv for 'select count(1) from edw_dimensions_md_v where dim_name =:s1' using p_obj_name;
1507: fetch cv into l_count;