APPS.ISC_DBI_WMS_PTS_TREND_PKG SQL Statements

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

Line: 206

     Description:   builds the outer select clause
    ---------------------------------------------------*/

    FUNCTION get_sel_clause1 (p_view_by_dim IN VARCHAR2)
        RETURN VARCHAR2
    IS
        l_sel_clause varchar2(7500);

Line: 218

   'SELECT
            cal_name			VIEWBY,
            p_pick_release_cnt 		ISC_MEASURE_1,
            c_pick_release_cnt		ISC_MEASURE_2,
            ' || isc_dbi_sutil_pkg.change_str (
                    p_new_numerator     => 'c_pick_release_cnt',
                    p_old_numerator     => 'p_pick_release_cnt',
                    p_denominator       => 'p_pick_release_cnt',
                    p_measure_name      => 'ISC_MEASURE_3') || ',
            p_ship_confirm_cnt 		ISC_MEASURE_4,
            c_ship_confirm_cnt 		ISC_MEASURE_5,
            ' || isc_dbi_sutil_pkg.change_str (
                    p_new_numerator     => 'c_ship_confirm_cnt',
                    p_old_numerator     => 'p_ship_confirm_cnt',
                    p_denominator       => 'p_ship_confirm_cnt',
                    p_measure_name      => 'ISC_MEASURE_6') || ',
            CASE WHEN p_ship_confirm_cnt = 0 THEN to_number (NULL)
                 ELSE (p_release_to_ship*24/p_ship_confirm_cnt)
                 END			ISC_MEASURE_7,
            CASE WHEN c_ship_confirm_cnt = 0 THEN to_number (NULL)
                 ELSE (c_release_to_ship*24/c_ship_confirm_cnt)
                 END			ISC_MEASURE_8,
            CASE WHEN c_ship_confirm_cnt = 0 THEN to_number(NULL)
                 WHEN p_ship_confirm_cnt = 0 THEN to_number(NULL)
	         ELSE ((c_release_to_ship*24/c_ship_confirm_cnt
                         - p_release_to_ship*24/p_ship_confirm_cnt))
                 END			ISC_MEASURE_9
';

Line: 254

     Description:   builds the outer select clause
    ---------------------------------------------------*/

    FUNCTION get_sel_clause2 (p_view_by_dim IN VARCHAR2)
        RETURN VARCHAR2
    IS
        l_sel_clause varchar2(7500);

Line: 266

   'SELECT
            cal.name			VIEWBY,
            NULL	 		ISC_MEASURE_1,
            NULL			ISC_MEASURE_2,
            NULL			ISC_MEASURE_3,
            p_ship_confirm_cnt 		ISC_MEASURE_4,
            c_ship_confirm_cnt 		ISC_MEASURE_5,
            ' || isc_dbi_sutil_pkg.change_str (
                    p_new_numerator     => 'c_ship_confirm_cnt',
                    p_old_numerator     => 'p_ship_confirm_cnt',
                    p_denominator       => 'p_ship_confirm_cnt',
                    p_measure_name      => 'ISC_MEASURE_6') || ',
            CASE WHEN p_ship_confirm_cnt = 0 THEN to_number (NULL)
                 ELSE (p_release_to_ship*24/p_ship_confirm_cnt)
                 END			ISC_MEASURE_7,
            CASE WHEN c_ship_confirm_cnt = 0 THEN to_number (NULL)
                 ELSE (c_release_to_ship*24/c_ship_confirm_cnt)
                 END			ISC_MEASURE_8,
            CASE WHEN c_ship_confirm_cnt = 0 THEN to_number(NULL)
                 WHEN p_ship_confirm_cnt = 0 THEN to_number(NULL)
	         ELSE ((c_release_to_ship*24/c_ship_confirm_cnt
                         - p_release_to_ship*24/p_ship_confirm_cnt))
                 END			ISC_MEASURE_9
';