APPS.BIS_PMF_MIGRATE_DIMENSIONS_PVT SQL Statements

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

Line: 30

  SELECT dim.name dimshortname, dim.longname dimname, dim.description dimdesc
  FROM  cmpwbdimension_v dim;

Line: 34

  SELECT  dim.name dimshortname, dim.longname dimname, dim.description dimdesc
         ,lvl.name lvlshortname, lvl.longname lvlname ,lvl.description lvldesc
  FROM
          cmpwbdimension_v dim, cmplevel_v lvl
  WHERE
         lvl.dimension = dim.elementid
  ;

Line: 63

  l_dim_sql  := ' SELECT dim.name dimshortname, dim.longname dimname, dim.description dimdesc '||
                ' FROM  cmpwbdimension_v dim '||
                ' WHERE dim.name NOT IN '|| G_LEVEL_EXCLUSION_STRING;

Line: 66

  l_dimlvl_sql :=' SELECT  dim.name dimshortname, dim.longname dimname, dim.description dimdesc '||
                 ' ,lvl.name lvlshortname, lvl.longname lvlname ,lvl.description lvldesc ' ||
                 ' FROM   ' ||
                 ' cmpwbdimension_v dim, cmplevel_v lvl ' ||
                 ' WHERE  '||
                 ' lvl.dimension = dim.elementid '||
                 ' AND dim.name NOT IN ' || G_LEVEL_EXCLUSION_STRING ;

Line: 74

  l_dim_sql  := ' SELECT dim.DIM_NAME dimshortname, dim.DIM_LONG_NAME dimname, dim.DIM_DESCRIPTION dimdesc '||
                ' FROM  edw_dimensions_md_v dim '||
                ' WHERE dim.DIM_NAME NOT IN '|| G_LEVEL_EXCLUSION_STRING;

Line: 78

  l_dimlvl_sql :=' SELECT  dim.DIM_NAME dimshortname, dim.DIM_LONG_NAME dimname, dim.DIM_DESCRIPTION dimdesc '||
                 ' ,lvl.LEVEL_NAME lvlshortname, lvl.LEVEL_LONG_NAME lvlname ,lvl.description lvldesc ' ||
                 ' FROM   ' ||
                 ' edw_dimensions_md_v dim, edw_levels_md_v lvl ' ||
                 ' WHERE  '||
                 ' lvl.DIM_ID = dim.DIM_ID '||
                 ' AND dim.DIM_NAME NOT IN ' || G_LEVEL_EXCLUSION_STRING ;