APPS.POA_DBI_RET_PKG SQL Statements

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

Line: 169

  l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim
                                                            ,'PO'
                                                            ,'6.0');

Line: 213

    (select (rank() over(&ORDER_BY_CLAUSE nulls last, ' || p_view_by_col;

Line: 237

     from   (select ' || p_view_by_col || ',' || p_view_by_col || ' VIEWBY,' || p_view_by_col || ' VIEWBYID, ';

Line: 343

  l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim,'PO','6.0');

Line: 378

      from (select (rank() over(&ORDER_BY_CLAUSE nulls last, ' || p_view_by_col ;

Line: 399

	    from   (select ' || p_view_by_col || ',' || p_view_by_col || ' VIEWBY,' || p_view_by_col || ' VIEWBYID,';

Line: 624

  l_query :=  poa_dbi_sutil_pkg.get_viewby_select_clause(l_view_by, 'PO','6.0');

Line: 636

          (select * from
           (select ' || l_view_by_col_name || ',';

Line: 668

  l_sel_clause := 'select cal.name VIEWBY,';