APPS.POA_DBI_APL_PKG SQL Statements

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

Line: 444

    l_query := 'select v.value VIEWBY,
          oset.POA_PERCENT1 POA_PERCENT1,  --Current
          oset.POA_PERCENT2 POA_PERCENT2,  --Prior
          oset.POA_MEASURE1 POA_MEASURE1,  --Current Leakage Amount
          oset.POA_MEASURE2 POA_MEASURE2   --Current Amount
           from
      (select * from
        (select org_id,
             ' || poa_dbi_util_pkg.rate_clause('c_leakage_amount','c_amount') || ' POA_PERCENT1,
             ' || poa_dbi_util_pkg.rate_clause('p_leakage_amount','p_amount') || ' POA_PERCENT2,
             ' || poa_dbi_util_pkg.rate_clause('c_leakage_amount_total','c_amount_total') || ' POA_MEASURE1,
             ' || poa_dbi_util_pkg.rate_clause('p_leakage_amount_total','p_amount_total') || ' POA_MEASURE2
     from
    ' || poa_dbi_template_pkg.status_sql(
           p_fact_name      => l_mv,
           p_where_clause   => l_where_clause,
           p_join_tables    => l_join_tbl,
           p_use_windowing  => 'N',
           p_col_name       => l_col_tbl,
           p_use_grpid      => 'N',
           p_filter_where   => get_kpi_filter_where,
           p_in_join_tables => l_in_join_tbl);

Line: 500

    'select ' || case p_view_by_col
               when 'inv_d_created_by' then 'decode(v.value, null, fnd_message.get_string(''POA'', ''POA_DBI_APL_UNASSIGNED''), v.value) '
               else 'v.value ' end ||
               'VIEWBY,
    decode(v.id, null, -1, v.id) VIEWBYID,
    oset.POA_MEASURE1 POA_MEASURE1,  --Leakage Amount
    oset.POA_MEASURE1 POA_MEASURE2,  --Leakage
    oset.POA_PERCENT1 POA_PERCENT1,  --Change
    oset.POA_MEASURE3 POA_MEASURE3,  --Invoice Amount
    oset.POA_PERCENT2 POA_PERCENT2,  --Leakage Rate
    oset.POA_MEASURE4 POA_MEASURE4,  --Total Leakage Amount
    oset.POA_MEASURE5 POA_MEASURE5,  --Total Invoice Amount
    oset.POA_MEASURE6 POA_MEASURE6,  --Total Change
    oset.POA_MEASURE7 POA_MEASURE7,  --Total Leakage Rate
    ''' || p_url || ''' POA_MEASURE8,
    ''' || p_url || ''' POA_MEASURE9,';

Line: 537

    (select (rank() over (&ORDER_BY_CLAUSE nulls last, ' || p_view_by_col || ')) - 1 rnk,'
        || p_view_by_col || ',
           POA_MEASURE1, POA_PERCENT1, POA_MEASURE3, POA_PERCENT2, POA_MEASURE4,
           POA_MEASURE5, POA_MEASURE6, POA_MEASURE7 from
     (select ' || p_view_by_col || ',
             ' || p_view_by_col || ' VIEWBY,
           nvl(c_leakage_amount,0) POA_MEASURE1,
           ' || poa_dbi_util_pkg.change_clause('c_leakage_amount','p_leakage_amount') || ' POA_PERCENT1,
           nvl(c_amount,0) POA_MEASURE3,
           ' || poa_dbi_util_pkg.rate_clause('c_leakage_amount','c_amount') || ' POA_PERCENT2,
           nvl(c_leakage_amount_total,0) POA_MEASURE4,
           nvl(c_amount_total,0) POA_MEASURE5,
           ' || poa_dbi_util_pkg.change_clause('c_leakage_amount_total','p_leakage_amount_total') || ' POA_MEASURE6,
           ' || poa_dbi_util_pkg.rate_clause('c_leakage_amount_total','c_amount_total') || ' POA_MEASURE7';

Line: 562

    l_sel_clause := 'select cal.name VIEWBY,'||fnd_global.newline;

Line: 564

    l_sel_clause := 'select cal_name VIEWBY,'||fnd_global.newline;