APPS.POA_DBI_REJ_PKG SQL Statements

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

Line: 178

    l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(P_VIEWBY     =>  p_view_by_dim
                                                              ,P_FUNC_AREA  =>  'PO'
                                                              ,P_VERSION    =>  '6.0');

Line: 215

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

Line: 238

    FROM   (SELECT ' || p_view_by_col || ',' || p_view_by_col || ' VIEWBY,' || p_view_by_col || ' VIEWBYID, ';

Line: 374

    l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(P_VIEWBY       =>  p_view_by_dim
                                                              ,P_FUNC_AREA    =>  'PO'
                                                              ,P_VERSION      =>  '6.0');

Line: 389

                FROM (SELECT (rank() over(&ORDER_BY_CLAUSE nulls last, ' || p_view_by_col || ')) - 1 rnk,' || p_view_by_col || ',';

Line: 396

                    FROM   (SELECT ' || p_view_by_col || ',' || p_view_by_col || ' VIEWBY,' || p_view_by_col || ' VIEWBYID, ' || p_view_by_col || ' POA_ATTRIBUTE1,';