APPS.ENI_DBI_OEX_PKG SQL Statements

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

Line: 45

l_lookup_select VARCHAR2(100);

Line: 178

         ' SELECT '|| l_cbo_hint ||'
            VIEWBY
           ,VIEWBYID
           , ' || l_drill_to_cat_url || ' AS ENI_ATTRIBUTE2
           ,ENI_MEASURE1
           ,ENI_MEASURE2
           ,ENI_MEASURE4
           ,ENI_MEASURE5
          FROM
           (
            SELECT ' || l_view_by_col || ',
                SUM
                (
                    case when ftrs.report_date = '||'&'||'BIS_CURRENT_ASOF_DATE
                    then
                            ' || l_currency_column ||   '
                    else
                        0
                    end
                ) AS ENI_MEASURE1,
                                SUM
                (
                    case when ftrs.report_date = '||'&'||'BIS_PREVIOUS_ASOF_DATE
                                        then
                        ' || l_currency_column ||   '
                                        else
                        0
                    end
                ) AS ENI_MEASURE2,

                SUM
                (
                    SUM
                    (
                    case when ftrs.report_date = '||'&'||'BIS_CURRENT_ASOF_DATE
                    then
                            ' || l_currency_column ||   '
                        else
                            0
                        end
                    )
                ) OVER() AS ENI_MEASURE4,

                SUM
                (
                    SUM
                    (
                    case when ftrs.report_date = '||'&'||'BIS_PREVIOUS_ASOF_DATE
                    then
                            ' || l_currency_column ||   '
                        else
                            0
                        end
                    )
                ) OVER() AS ENI_MEASURE5
            FROM
                ' || l_summary || ' fgbm,
                fii_time_rpt_struct ftrs,
                ' || l_lookup || '
            WHERE
                fgbm.time_id = ftrs.time_id
                AND
                (
                    ftrs.report_date = '||'&'||'BIS_CURRENT_ASOF_DATE
                        OR ftrs.report_date = '||'&'||'BIS_PREVIOUS_ASOF_DATE
                )
                AND BITAND(ftrs.record_type_id, ' || '&' || 'BIS_NESTED_PATTERN) = ftrs.record_type_id
                ' || l_where_clause || '
            GROUP BY
                ' || l_group_by_col || '
                )
            ORDER BY
                ' || l_order_by;