eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ISC_DBI_CARR_BILL_PAY_PKG SQL Statements

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

Line: 239


        l_view_by_fact_col := isc_dbi_sutil_pkg.get_fact_select_columns (p_join_tbl);

Line: 244


       'SELECT ' || isc_dbi_sutil_pkg.get_view_by_select_clause (p_view_by_dim)
	  || 'oset.ISC_MEASURE_9	ISC_MEASURE_9,
        ' || 'oset.ISC_MEASURE_10	ISC_MEASURE_10,
        ' || 'oset.ISC_MEASURE_11 	ISC_MEASURE_11,
        ' || 'oset.ISC_MEASURE_12	ISC_MEASURE_12,
        ' || 'oset.ISC_MEASURE_13 	ISC_MEASURE_13,
        ' || 'oset.ISC_MEASURE_15 	ISC_MEASURE_15,
        ' || 'oset.ISC_MEASURE_16	ISC_MEASURE_16,
        ' || 'oset.ISC_MEASURE_17	ISC_MEASURE_17,
        ' || 'oset.ISC_MEASURE_18	ISC_MEASURE_18,
        ' || 'oset.ISC_MEASURE_19	ISC_MEASURE_19,
        ' || 'oset.ISC_MEASURE_21	ISC_MEASURE_21,
        ' || 'oset.ISC_MEASURE_22	ISC_MEASURE_22,
        ' || 'oset.ISC_MEASURE_23	ISC_MEASURE_23,
        ' || 'oset.ISC_MEASURE_24	ISC_MEASURE_24,
        ' || 'oset.ISC_MEASURE_1	ISC_MEASURE_1,
        ' || 'oset.ISC_MEASURE_2	ISC_MEASURE_2,
        ' || 'oset.ISC_MEASURE_3	ISC_MEASURE_3,
        ' || 'oset.ISC_MEASURE_4	ISC_MEASURE_4,
        ' || 'oset.ISC_MEASURE_5	ISC_MEASURE_5,
        ' || 'oset.ISC_MEASURE_6	ISC_MEASURE_6,
        ' || 'oset.ISC_MEASURE_7	ISC_MEASURE_7,
        ' || 'oset.ISC_MEASURE_8	ISC_MEASURE_8,
        ' || 'oset.ISC_MEASURE_25	ISC_MEASURE_25,
        ' || 'oset.ISC_MEASURE_26	ISC_MEASURE_26,
        ' || 'oset.ISC_MEASURE_27	ISC_MEASURE_27,
        ' || 'oset.ISC_MEASURE_28	ISC_MEASURE_28,
        ' || 'oset.ISC_MEASURE_30	ISC_MEASURE_30,
        ' || 'oset.ISC_MEASURE_32	ISC_MEASURE_32,
        ' || 'oset.ISC_MEASURE_33	ISC_MEASURE_33,
        ' || 'oset.ISC_MEASURE_34	ISC_MEASURE_34,
        ' || 'oset.ISC_MEASURE_35	ISC_MEASURE_35
        ' || 'FROM
        ' || '(SELECT (rank () over
        ' || ' (&ORDER_BY_CLAUSE nulls last,
        ' || l_view_by_fact_col || ')) - 1 rnk,
        ' || l_view_by_fact_col || ',
        ' || 'ISC_MEASURE_1,ISC_MEASURE_2,ISC_MEASURE_3,ISC_MEASURE_4,ISC_MEASURE_5,
           ISC_MEASURE_6,ISC_MEASURE_7,ISC_MEASURE_8,ISC_MEASURE_9,ISC_MEASURE_10,
           ISC_MEASURE_11,ISC_MEASURE_12,ISC_MEASURE_13,ISC_MEASURE_15,
           ISC_MEASURE_16,ISC_MEASURE_17,ISC_MEASURE_18,ISC_MEASURE_19,
 	   ISC_MEASURE_21,ISC_MEASURE_22,ISC_MEASURE_23,ISC_MEASURE_24,
	   ISC_MEASURE_25,ISC_MEASURE_26,ISC_MEASURE_27,ISC_MEASURE_28,
	   ISC_MEASURE_30,ISC_MEASURE_32,ISC_MEASURE_33,ISC_MEASURE_34,ISC_MEASURE_35
        ' || 'FROM
        ' || '(SELECT
            ' || l_view_by_fact_col || ',
	p_payment_amt 			ISC_MEASURE_9,
	c_payment_amt 			ISC_MEASURE_10,
	p_payment_amt_total 		ISC_MEASURE_32,
	c_payment_amt_total	        ISC_MEASURE_1,
	c_fully_paid_amt		ISC_MEASURE_13,
	c_fully_paid_amt_total		ISC_MEASURE_4,
	c_bill_amt			ISC_MEASURE_15,
	c_bill_amt_total		ISC_MEASURE_5,
	c_bill_amt - c_fully_paid_amt	ISC_MEASURE_16,
	c_bill_amt_total - c_fully_paid_amt_total	ISC_MEASURE_6,
	c_approved_amt			ISC_MEASURE_21,
	c_bill_amt - c_approved_amt     ISC_MEASURE_22,
	c_approved_amt_total 		ISC_MEASURE_25,
	c_bill_amt_total - c_approved_amt_total     ISC_MEASURE_26,
	    ' || isc_dbi_sutil_pkg.change_str (
                    p_new_numerator     => 'c_payment_amt',
                    p_old_numerator     => 'p_payment_amt',
                    p_denominator       => 'p_payment_amt',
                    p_measure_name      => 'ISC_MEASURE_11') || ', -- Payment Change

	    ' || isc_dbi_sutil_pkg.change_str (
                    p_new_numerator     => 'c_payment_amt_total',
                    p_old_numerator     => 'p_payment_amt_total',
                    p_denominator       => 'p_payment_amt_total',
                    p_measure_name      => 'ISC_MEASURE_2') || ', -- GT - Total Payment Change

   	    ' || isc_dbi_sutil_pkg.rate_str (
                    p_numerator     => 'c_payment_amt',
                    p_denominator   => 'c_payment_amt_total',
                    p_rate_type     => 'PERCENT',
                    p_measure_name  => 'ISC_MEASURE_12') || ', -- Percent of Total

   	    ' || isc_dbi_sutil_pkg.rate_str (
                    p_numerator     => 'c_payment_amt_total',
                    p_denominator   => 'c_payment_amt_total',
                    p_rate_type     => 'PERCENT',
                    p_measure_name  => 'ISC_MEASURE_3') || ', -- GT- Percent of Total

  	    ' || isc_dbi_sutil_pkg.change_str (
                    p_new_numerator     => 'p_bill_amt',
                    p_old_numerator     => 'p_fully_paid_amt',
                    p_denominator       => 'p_fully_paid_amt',
                    p_measure_name      => 'ISC_MEASURE_17') || ', -- (Bill-to-Paid Variance Percent) Prior

  	    ' || isc_dbi_sutil_pkg.change_str (
                    p_new_numerator     => 'p_bill_amt',
                    p_old_numerator     => 'p_fully_paid_amt',
                    p_denominator       => 'p_fully_paid_amt',
                    p_measure_name      => 'ISC_MEASURE_35') || ', -- KPI (Bill-to-Paid Variance Percent) Prior

  	    ' || isc_dbi_sutil_pkg.change_str (
                    p_new_numerator     => 'p_bill_amt_total',
                    p_old_numerator     => 'p_fully_paid_amt_total',
                    p_denominator       => 'p_fully_paid_amt_total',
                    p_measure_name      => 'ISC_MEASURE_30') || ', -- GT (Bill-to-Paid Variance Percent) Prior

 	    ' || isc_dbi_sutil_pkg.change_str (
                    p_new_numerator     => 'c_bill_amt',
                    p_old_numerator     => 'c_fully_paid_amt',
                    p_denominator       => 'c_fully_paid_amt',
                    p_measure_name      => 'ISC_MEASURE_18') || ', --(Bill-to-Paid Variance Percent) Current

 	    ' || isc_dbi_sutil_pkg.change_str (
                    p_new_numerator     => 'c_bill_amt',
                    p_old_numerator     => 'c_fully_paid_amt',
                    p_denominator       => 'c_fully_paid_amt',
                    p_measure_name      => 'ISC_MEASURE_33') || ', --(Bill-to-Paid Variance Percent) Current (for KPI)

 	    ' || isc_dbi_sutil_pkg.change_str (
                    p_new_numerator     => 'c_bill_amt_total',
                    p_old_numerator     => 'c_fully_paid_amt_total',
                    p_denominator       => 'c_fully_paid_amt_total',
                    p_measure_name      => 'ISC_MEASURE_7') || ', -- GT-(Bill-to-Paid Variance Percent) Current

 	    ' || isc_dbi_sutil_pkg.change_str (
                    p_new_numerator     => 'c_bill_amt_total',
                    p_old_numerator     => 'c_fully_paid_amt_total',
                    p_denominator       => 'c_fully_paid_amt_total',
                    p_measure_name      => 'ISC_MEASURE_34') || ', -- KPIGT-(Bill-to-Paid Variance Percent) Current

	    ' || isc_dbi_sutil_pkg.change_rate_str (
                    p_new_numerator     => '(c_bill_amt - c_fully_paid_amt)',
                    p_new_denominator   => 'c_fully_paid_amt',
                    p_old_numerator     => '(p_bill_amt - p_fully_paid_amt)',
                    p_old_denominator   => 'p_fully_paid_amt',
                    p_rate_type         => 'RATIO',
                    p_measure_name      => 'ISC_MEASURE_19') || ', -- Bill-to_Paid Variance Percent Change

	    ' || isc_dbi_sutil_pkg.change_rate_str (
                    p_new_numerator     => '(c_bill_amt_total - c_fully_paid_amt_total)',
                    p_new_denominator   => 'c_fully_paid_amt_total',
                    p_old_numerator     => '(p_bill_amt_total - p_fully_paid_amt_total)',
                    p_old_denominator   => 'p_fully_paid_amt_total',
                    p_rate_type         => 'RATIO',
                    p_measure_name      => 'ISC_MEASURE_8') || ', --GT - Bill-to_Paid Variance Percent Change

	     ' || isc_dbi_sutil_pkg.change_str (
                    p_new_numerator     => 'c_bill_amt',
                    p_old_numerator     => 'c_approved_amt',
                    p_denominator       => 'c_approved_amt',
                    p_measure_name      => 'ISC_MEASURE_23') ||',--(Bill-to-Approved Var Percent) Current

             ' || isc_dbi_sutil_pkg.change_rate_str (
                    p_new_numerator     => '(c_bill_amt - c_approved_amt)',
                    p_new_denominator   => 'c_approved_amt',
                    p_old_numerator     => '(p_bill_amt - p_approved_amt)',
                    p_old_denominator   => 'p_approved_amt',
                    p_rate_type         => 'RATIO',
                    p_measure_name      => 'ISC_MEASURE_24') || ', -- Bill-to-Approved Variance Percent Change

	     ' || isc_dbi_sutil_pkg.change_str (
                    p_new_numerator     => 'c_bill_amt_total',
                    p_old_numerator     => 'c_approved_amt_total',
                    p_denominator       => 'c_approved_amt_total',
                    p_measure_name      => 'ISC_MEASURE_27') ||',--GT (Bill-to-Approved Var Percent) Current

             ' || isc_dbi_sutil_pkg.change_rate_str (
                    p_new_numerator     => '(c_bill_amt_total - c_approved_amt_total)',
                    p_new_denominator   => 'c_approved_amt_total',
                    p_old_numerator     => '(p_bill_amt_total - p_approved_amt_total)',
                    p_old_denominator   => 'p_approved_amt_total',
                    p_rate_type         => 'RATIO',
                    p_measure_name      => 'ISC_MEASURE_28'); -- GT Bill-to-Approved Variance Percent Change