APPS.POA_DBI_RDE_PKG SQL Statements

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

Line: 175

  l_sel_clause :='select cal.name VIEWBY,
  ' || poa_dbi_util_pkg.rate_clause('c_amt_expt','c_amt_receipt') || ' POA_PERCENT1,
  ' || poa_dbi_util_pkg.change_clause(poa_dbi_util_pkg.rate_clause('c_amt_expt','c_amt_receipt'),poa_dbi_util_pkg.rate_clause('p_amt_expt','p_amt_receipt'),'P') || ' POA_MEASURE1,
    ' ||
poa_dbi_util_pkg.rate_clause('(nvl(c_cnt_early,0) + nvl(c_cnt_late,0))','c_cnt_receipt') || ' POA_PERCENT3,
  ' || poa_dbi_util_pkg.change_clause(
	poa_dbi_util_pkg.rate_clause('(nvl(c_cnt_early,0) + nvl(c_cnt_late,0))','c_cnt_receipt'),
	poa_dbi_util_pkg.rate_clause('(nvl(p_cnt_early,0) + nvl(p_cnt_late,0))','p_cnt_receipt'),'P') || ' POA_MEASURE2';

Line: 478

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

Line: 521

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

Line: 546

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

Line: 606

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

Line: 642

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

Line: 663

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

Line: 699

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

Line: 736

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

Line: 757

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

Line: 867

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

Line: 885

     (select (rank() over

                   (&ORDER_BY_CLAUSE nulls last, ' || p_view_by_col || ', base_uom)) - 1 rnk,'

        || p_view_by_col || ',
           base_uom, POA_MEASURE2, POA_MEASURE3, POA_MEASURE4,
           POA_MEASURE5, POA_MEASURE6, POA_MEASURE7,
           POA_MEASURE8, POA_MEASURE9, POA_MEASURE10,
	   POA_MEASURE11, POA_MEASURE12,POA_MEASURE13 from
     (select ' || p_view_by_col || ',
             ' || p_view_by_col || ' VIEWBY,
           base_uom,
           decode(base_uom,null,to_number(null),nvl(c_qty_beforedue,0)) POA_MEASURE2,
           decode(base_uom,null,to_number(null),nvl(c_qty_intol,0)) POA_MEASURE3,
           decode(base_uom,null,to_number(null),nvl(c_qty_afterdue,0)) POA_MEASURE4,
           decode(base_uom,null,to_number(null),(nvl(c_qty_beforedue,0)+nvl(c_qty_intol,0)+nvl(c_qty_afterdue,0))) POA_MEASURE5,

           nvl(c_amt_expt,0) POA_MEASURE6,
	   nvl(c_amt_receipt,0) POA_MEASURE7,
	   nvl(c_early_cnt,0)+nvl(c_late_cnt,0) POA_MEASURE8,
	   nvl(c_cnt_receipt,0) POA_MEASURE9,
           nvl(c_amt_expt_total,0) POA_MEASURE10,
	   nvl(c_amt_receipt_total,0) POA_MEASURE11,
	   nvl(c_early_cnt_total,0)+nvl(c_late_cnt_total,0) POA_MEASURE12,
           nvl(c_cnt_receipt_total,0) POA_MEASURE13';

Line: 981

  l_sel_clause :='select cal.name VIEWBY,
  nvl(p_amt_expt,0) POA_MEASURE3,
  nvl(c_amt_expt,0) POA_MEASURE1,
  ' || poa_dbi_util_pkg.change_clause('c_amt_expt','p_amt_expt') || ' POA_PERCENT1,
  nvl(p_early_cnt,0)+nvl(p_late_cnt,0) POA_MEASURE4,
  nvl(c_early_cnt,0)+nvl(c_late_cnt,0) POA_MEASURE2,
  ' || poa_dbi_util_pkg.change_clause('(nvl(c_early_cnt,0)+nvl(c_late_cnt,0))','(nvl(p_early_cnt,0)+nvl(p_late_cnt,0))') || ' POA_PERCENT3';