APPS.ISC_DBI_WMS_PTS_PKG SQL Statements

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

Line: 225

     Description:   builds the outer select clause
    ---------------------------------------------------*/
    FUNCTION get_sel_clause1(p_view_by_dim IN VARCHAR2,
                                   p_join_tbl IN
                                   poa_dbi_util_pkg.POA_DBI_JOIN_TBL)
        RETURN VARCHAR2
    IS
        l_sel_clause                VARCHAR2(32000);

Line: 247

        l_view_by_fact_col := isc_dbi_sutil_pkg.get_fact_select_columns (p_join_tbl);

Line: 252

        'SELECT
        ' || isc_dbi_sutil_pkg.get_view_by_select_clause (p_view_by_dim);

Line: 300

	   (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_14,ISC_MEASURE_15,
           ISC_MEASURE_16,ISC_MEASURE_17,ISC_MEASURE_19
              FROM
	      (SELECT
            ' || l_view_by_fact_col || ',
            ' || l_inner_qty_sel_clause1 || '
	    p_pick_release_cnt		ISC_MEASURE_2,
	    c_pick_release_cnt 		ISC_MEASURE_3,
            ' || 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_4') || ',
            ' || l_inner_qty_sel_clause2 || '
	    p_ship_confirm_cnt 		ISC_MEASURE_6,
   	    c_ship_confirm_cnt 		ISC_MEASURE_7,
            ' || 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_8') || ',
            CASE WHEN p_ship_confirm_cnt = 0 THEN to_number (NULL)
                 ELSE (p_release_to_ship*24/p_ship_confirm_cnt)
                 END			ISC_MEASURE_9,
            CASE WHEN c_ship_confirm_cnt = 0 THEN to_number (NULL)
                 ELSE (c_release_to_ship*24/c_ship_confirm_cnt)
                 END			ISC_MEASURE_10,
            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_11,
	    c_pick_release_cnt_total	ISC_MEASURE_12,
            ' || isc_dbi_sutil_pkg.change_str (
                    p_new_numerator     => 'c_pick_release_cnt_total',
                    p_old_numerator     => 'p_pick_release_cnt_total',
                    p_denominator       => 'p_pick_release_cnt_total',
                    p_measure_name      => 'ISC_MEASURE_13') || ',
	    c_ship_confirm_cnt_total	ISC_MEASURE_14,
            ' || isc_dbi_sutil_pkg.change_str (
                    p_new_numerator     => 'c_ship_confirm_cnt_total',
                    p_old_numerator     => 'p_ship_confirm_cnt_total',
                    p_denominator       => 'p_ship_confirm_cnt_total',
                    p_measure_name      => 'ISC_MEASURE_15') || ',
            CASE WHEN c_ship_confirm_cnt_total = 0 THEN to_number (NULL)
                 ELSE (c_release_to_ship_total*24/c_ship_confirm_cnt_total)
                 END			ISC_MEASURE_16,
            CASE WHEN c_ship_confirm_cnt_total = 0 THEN to_number(NULL)
                 WHEN p_ship_confirm_cnt_total = 0 THEN to_number(NULL)
	         ELSE ((c_release_to_ship_total*24/c_ship_confirm_cnt_total
                         - p_release_to_ship_total*24/p_ship_confirm_cnt_total))
                 END			ISC_MEASURE_17,
            CASE WHEN p_ship_confirm_cnt_total = 0 THEN to_number (NULL)
                 ELSE (p_release_to_ship_total*24/p_ship_confirm_cnt_total)
                 END			ISC_MEASURE_19
';

Line: 369

     Description:   builds the outer select clause
    ---------------------------------------------------*/
    FUNCTION get_sel_clause2(p_view_by_dim IN VARCHAR2,
                                   p_join_tbl IN
                                   poa_dbi_util_pkg.POA_DBI_JOIN_TBL)
        RETURN VARCHAR2
    IS
        l_sel_clause                VARCHAR2(32000);

Line: 390

        l_view_by_fact_col := isc_dbi_sutil_pkg.get_fact_select_columns (p_join_tbl);

Line: 395

        'SELECT
        ' || isc_dbi_sutil_pkg.get_view_by_select_clause (p_view_by_dim);

Line: 440

	   (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_14,ISC_MEASURE_15,
           ISC_MEASURE_16,ISC_MEASURE_17,ISC_MEASURE_19
              FROM
	      (SELECT
            ' || l_view_by_fact_col || ',
            NULL 			ISC_MEASURE_1,
            ' || l_inner_qty_sel_clause || '
	    NULL 			ISC_MEASURE_2,
	    NULL 			ISC_MEASURE_3,
	    NULL			ISC_MEASURE_4,
	    p_ship_confirm_cnt 		ISC_MEASURE_6,
   	    c_ship_confirm_cnt 		ISC_MEASURE_7,
            ' || 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_8') || ',
            CASE WHEN p_ship_confirm_cnt = 0 THEN to_number (NULL)
                 ELSE (p_release_to_ship*24/p_ship_confirm_cnt)
                 END			ISC_MEASURE_9,
            CASE WHEN c_ship_confirm_cnt = 0 THEN to_number (NULL)
                 ELSE (c_release_to_ship*24/c_ship_confirm_cnt)
                 END			ISC_MEASURE_10,
            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_11,
	    c_ship_confirm_cnt_total	ISC_MEASURE_14,
            ' || isc_dbi_sutil_pkg.change_str (
                    p_new_numerator     => 'c_ship_confirm_cnt_total',
                    p_old_numerator     => 'p_ship_confirm_cnt_total',
                    p_denominator       => 'p_ship_confirm_cnt_total',
                    p_measure_name      => 'ISC_MEASURE_15') || ',
            CASE WHEN c_ship_confirm_cnt_total = 0 THEN to_number (NULL)
                 ELSE (c_release_to_ship_total*24/c_ship_confirm_cnt_total)
                 END			ISC_MEASURE_16,
            CASE WHEN c_ship_confirm_cnt_total = 0 THEN to_number(NULL)
                 WHEN p_ship_confirm_cnt_total = 0 THEN to_number(NULL)
	         ELSE ((c_release_to_ship_total*24/c_ship_confirm_cnt_total
                         - p_release_to_ship_total*24/p_ship_confirm_cnt_total))
                 END			ISC_MEASURE_17,
            CASE WHEN p_ship_confirm_cnt_total = 0 THEN to_number (NULL)
                 ELSE (p_release_to_ship_total*24/p_ship_confirm_cnt_total)
                 END			ISC_MEASURE_19
';