APPS.ZPB_OLAP_VIEWS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 163

   p_modelCmd := p_modelCmd||') RULES UPDATE SEQUENTIAL ORDER()';

Line: 223

   select sys_context('USERENV', 'CURRENT_SCHEMA') into l_schemaName from dual;

Line: 227

      select distinct(VERSION)
         into l_version
         from PRODUCT_COMPONENT_VERSION
         where PRODUCT like '%Enterprise Edition%';

Line: 240

      'create or replace view '||p_dimView||' as select '||p_cols||
      ' from table(CAST (OLAP_TABLE('''||l_aw||
      ' DURATION SESSION'', '''|| l_schemaName || '.' || l_dimTable||
      ''', '''||l_olapCmd||''', '||p_lmap||') AS '||l_dimTable||'))'||
      l_model;

Line: 294

      select 'alter view '||object_name||' compile' CMD
         from USER_OBJECTS
         where STATUS = 'INVALID'
         and OBJECT_NAME like 'ZPB%_V'
         and OBJECT_TYPE = 'VIEW';

Line: 1345

         select BUSINESS_AREA_ID, SHADOW_ID
            into l_ba_id, l_shadow
            from ZPB_CURRENT_USER_V;

Line: 1364

            select LAST_AW_UPDATE
               into l_last_upd
               from ZPB_BUSINESS_AREAS
               where BUSINESS_AREA_ID = l_ba_id;

Line: 1402

      select ZPB_AW.GET_SCHEMA||'.'||PERSONAL_AW
         into l_persAw
         from ZPB_USERS
         where BUSINESS_AREA_ID = l_ba_id
         and USER_ID = l_shadow;

Line: 1466

      select BUSINESS_AREA_ID, SHADOW_ID
         into l_ba_id, l_shadow
         from ZPB_CURRENT_USER_V;

Line: 1493

         select LAST_AW_UPDATE
            into l_last_upd
            from ZPB_BUSINESS_AREAS
            where BUSINESS_AREA_ID = l_ba_id;

Line: 1522

      select ZPB_AW.GET_SCHEMA||'.'||PERSONAL_AW
         into l_persAw
         from ZPB_USERS
         where BUSINESS_AREA_ID = l_ba_id
         and USER_ID = l_shadow;

Line: 1584

       select view_name from user_views
          where view_name like l_aw||'\_%' escape '\' or
            view_name like l_aw||'PRS\_%' escape '\' or
             view_name like 'ZPB' || p_business_area ||'PRS\_%' escape '\' or
              view_name like 'ZPB' || p_business_area || '\_D%' escape '\';

Line: 1592

         select user_id
            from ZPB_USERS
            where BUSINESS_AREA_ID = p_business_area;

Line: 1596

   select DATA_AW
      into l_aw
      from ZPB_BUSINESS_AREAS
      where BUSINESS_AREA_ID = p_business_area;

Line: 1625

         select view_name
            from user_views
            where view_name like l_aw||'\_%' escape '\';