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_DEPOT_MARGIN_RPT_PKG SQL Statements

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

Line: 190


    	' SELECT ' ||
    	ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||
    	l_description || ' BIV_ATTRIBUTE1 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE1 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE2 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE3 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE4 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE5 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE6 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE7 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE8 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE9 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE10 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE11 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE12 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE13 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE14 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE15 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE16 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE17 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE18 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE19 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE20 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE21 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE22 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE23 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE24 ' || fnd_global.newline || ', ' ||
	 l_cat_drill_down || ' BIV_DYNAMIC_URL1 ' || fnd_global.newline ||
	'FROM ( SELECT   ' ||
	' rank() over (&ORDER_BY_CLAUSE'||' nulls last, '|| p_view_by_col ||' ) - 1 rnk' || fnd_global.newline || ', ' ||
	p_view_by_col || fnd_global.newline || ', ' ||
    	'BIV_MEASURE1 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE2 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE3 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE4 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE5 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE6 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE7 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE8 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE9 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE10 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE11 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE12 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE13 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE14 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE15 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE16 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE17 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE18 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE19 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE20 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE21 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE22 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE23 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE24 ' || fnd_global.newline ||
	' FROM (SELECT ' || p_view_by_col || fnd_global.newline || ', ' ||
    	 'NVL (p_charges, 0) BIV_MEASURE1 ' || fnd_global.newline || ', ' ||
    	 'NVL (c_charges, 0) BIV_MEASURE2 ' || fnd_global.newline || ', ' ||
    	 poa_dbi_util_pkg.change_clause ('c_charges', 'p_charges') || ' BIV_MEASURE3 ' || fnd_global.newline || ', ' ||
    	 'NVL (p_costs, 0) BIV_MEASURE4 ' || fnd_global.newline || ', ' ||
  	 'NVL (c_costs, 0) BIV_MEASURE5 ' || fnd_global.newline || ', ' ||
    	 poa_dbi_util_pkg.change_clause ('c_costs', 'p_costs') || ' BIV_MEASURE6 ' || fnd_global.newline || ', ' ||
    	 l_p_margin || ' BIV_MEASURE7 ' || fnd_global.newline || ', ' ||
    	 l_c_margin || ' BIV_MEASURE8 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause (l_c_margin, l_p_margin) || ' BIV_MEASURE9 ' || fnd_global.newline || ', ' ||
    	 l_p_margin_percent || ' BIV_MEASURE10 ' || fnd_global.newline || ', ' ||
    	 l_c_margin_percent || ' BIV_MEASURE11 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause  (l_c_margin_percent, l_p_margin_percent, 'P')  || ' BIV_MEASURE12 ' || fnd_global.newline || ', ' ||
	 'NVL (c_charges_total, 0) BIV_MEASURE13 ' || fnd_global.newline || ', ' ||
	 poa_dbi_util_pkg.change_clause ('c_charges_total', 'p_charges_total') || ' BIV_MEASURE14 ' || fnd_global.newline || ', ' ||
	 'NVL (c_costs_total, 0) BIV_MEASURE15 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('c_costs_total', 'p_costs_total') || ' BIV_MEASURE16 ' || fnd_global.newline || ', ' ||
  	 l_c_margin_total || ' BIV_MEASURE17 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause (l_c_margin_total, l_p_margin_total) || ' BIV_MEASURE18 ' || fnd_global.newline || ', ' ||
	 l_c_margin_percent_total || ' BIV_MEASURE19 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause (l_c_margin_percent_total, l_p_margin_percent_total, 'P')  || ' BIV_MEASURE20 ' || fnd_global.newline || ', ' ||
         l_c_margin || ' BIV_MEASURE21 ' || fnd_global.newline || ', ' ||
	 l_p_margin || ' BIV_MEASURE22 ' || fnd_global.newline || ', ' ||
	 l_c_margin_total || ' BIV_MEASURE23 ' || fnd_global.newline || ', ' ||
	 l_p_margin_total || ' BIV_MEASURE24 ' || fnd_global.newline;

Line: 400


  	' SELECT ' ||
  	 ' cal.name VIEWBY ' || fnd_global.newline || ', ' ||
  	 'NVL (iset.p_charges, 0) BIV_MEASURE1 ' || fnd_global.newline || ', ' ||
  	 'NVL (iset.c_charges, 0) BIV_MEASURE2 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('iset.c_charges', 'iset.p_charges') || ' BIV_MEASURE3 ' || fnd_global.newline || ', ' ||
  	 'NVL (iset.p_costs, 0) BIV_MEASURE4 ' || fnd_global.newline || ', ' ||
	 'NVL (iset.c_costs, 0) BIV_MEASURE5 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('iset.c_costs', 'iset.p_costs') || ' BIV_MEASURE6 ' || fnd_global.newline || ', ' ||
  	 l_p_margin || ' BIV_MEASURE7 ' || fnd_global.newline || ', ' ||
  	 l_c_margin || ' BIV_MEASURE8 ' || fnd_global.newline || ', ' ||
	 poa_dbi_util_pkg.change_clause (l_c_margin, l_p_margin) || ' BIV_MEASURE9 ' || fnd_global.newline || ', ' ||
  	 l_p_margin_percent || ' BIV_MEASURE10 ' || fnd_global.newline || ', ' ||
  	 l_c_margin_percent || ' BIV_MEASURE11 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause  (l_c_margin_percent, l_p_margin_percent, 'P')  || ' BIV_MEASURE12 ' || fnd_global.newline;

Line: 564


     	' SELECT ' ||
      	ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||
      	l_description || ' BIV_ATTRIBUTE1 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE1 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE2 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE3 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE4 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE5 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE6 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE7 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE8 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE9 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE10 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE11 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE12 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE13 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE14 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE15 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE16 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE17 ' || fnd_global.newline || ',' ||
  	 l_cat_drill_down || ' BIV_DYNAMIC_URL1 ' || fnd_global.newline ||
  	'FROM ( SELECT   ' || fnd_global.newline ||
  	' rank() over (&ORDER_BY_CLAUSE'||' nulls last, '|| p_view_by_col ||' ) - 1 rnk ' || fnd_global.newline || ', ' ||
  	p_view_by_col || fnd_global.newline || ', ' ||
      	'BIV_MEASURE1 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE2 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE3 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE4 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE5 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE6 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE7 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE8 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE9 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE10 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE11 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE12 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE13 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE14 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE15 ' || fnd_global.newline || ',' ||
    	'BIV_MEASURE16 ' || fnd_global.newline || ',' ||
    	'BIV_MEASURE17 ' || fnd_global.newline ||
  	'FROM (' ||
  	' SELECT ' || p_view_by_col || fnd_global.newline || ', ' ||
  	 'NVL (c_m_charges, 0) BIV_MEASURE1 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('c_m_charges', 'p_m_charges') || ' BIV_MEASURE2 ' || fnd_global.newline || ', ' ||
  	 'NVL (c_l_charges, 0) BIV_MEASURE3 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('c_l_charges', 'p_l_charges') || ' BIV_MEASURE4 ' || fnd_global.newline || ', ' ||
  	 'NVL (c_e_charges, 0) BIV_MEASURE5 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('c_e_charges', 'p_e_charges') || ' BIV_MEASURE6 ' || fnd_global.newline || ', ' ||
  	 l_p_total_charges || ' BIV_MEASURE7 ' || fnd_global.newline || ', ' ||
  	 l_c_total_charges || ' BIV_MEASURE8 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause (l_c_total_charges, l_p_total_charges) || ' BIV_MEASURE9 ' || fnd_global.newline || ', ' ||
  	 'NVL (c_m_charges_total, 0) BIV_MEASURE10 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('c_m_charges_total', 'p_m_charges_total') || ' BIV_MEASURE11 ' || fnd_global.newline || ', ' ||
  	 'NVL (c_l_charges_total, 0) BIV_MEASURE12 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('c_l_charges_total', 'p_l_charges_total') || ' BIV_MEASURE13 ' || fnd_global.newline || ', ' ||
  	 'NVL (c_e_charges_total, 0) BIV_MEASURE14 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('c_e_charges_total', 'p_e_charges_total') || ' BIV_MEASURE15 ' || fnd_global.newline || ', ' ||
  	 l_c_total_charges_total || ' BIV_MEASURE16 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause (l_c_total_charges_total, l_p_total_charges_total) || ' BIV_MEASURE17 ' || fnd_global.newline;

Line: 757


  	' SELECT ' ||
  	 ' cal.name VIEWBY ' || fnd_global.newline || ', ' ||
  	 'NVL (iset.c_m_charges, 0) BIV_MEASURE1 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('iset.c_m_charges', 'iset.p_m_charges') || ' BIV_MEASURE2 ' || fnd_global.newline || ', ' ||
  	 'NVL (iset.c_l_charges, 0) BIV_MEASURE3 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('iset.c_l_charges', 'iset.p_l_charges') || ' BIV_MEASURE4 ' || fnd_global.newline || ', ' ||
  	 'NVL (iset.c_e_charges, 0) BIV_MEASURE5 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('iset.c_e_charges', 'iset.p_e_charges') || ' BIV_MEASURE6 ' || fnd_global.newline || ', ' ||
  	 l_p_total_charges || ' BIV_MEASURE7 ' || fnd_global.newline || ', ' ||
  	 l_c_total_charges || ' BIV_MEASURE8 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause (l_c_total_charges, l_p_total_charges) || ' BIV_MEASURE9 ' || fnd_global.newline;

Line: 917


     	' SELECT ' ||
      	ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||
      	l_description || ' BIV_ATTRIBUTE1 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE1 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE2 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE3 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE4 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE5 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE6 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE7 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE8 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE9 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE10 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE11 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE12 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE13 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE14 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE15 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE16 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE17 ' || fnd_global.newline || ',' ||
  	 l_cat_drill_down || ' BIV_DYNAMIC_URL1 ' || fnd_global.newline ||
  	'FROM ( SELECT   ' || fnd_global.newline ||
  	' rank() over (&ORDER_BY_CLAUSE'||' nulls last, '|| p_view_by_col ||' ) - 1 rnk' || fnd_global.newline || ', ' ||
  	 p_view_by_col  || fnd_global.newline || ', ' ||
      	'BIV_MEASURE1 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE2 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE3 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE4 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE5 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE6 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE7 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE8 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE9 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE10 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE11 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE12 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE13 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE14 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE15 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE16 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE17 ' || fnd_global.newline ||
  	'FROM (' || fnd_global.newline ||
  	' SELECT ' || p_view_by_col || fnd_global.newline || ', ' ||
  	 'NVL (c_m_cost, 0) BIV_MEASURE1 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('c_m_cost', 'p_m_cost') || ' BIV_MEASURE2 ' || fnd_global.newline || ', ' ||
  	 'NVL (c_l_cost, 0) BIV_MEASURE3 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('c_l_cost', 'p_l_cost') || ' BIV_MEASURE4 ' || fnd_global.newline || ', ' ||
  	 'NVL (c_e_cost,0) BIV_MEASURE5 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('c_e_cost', 'p_e_cost') || ' BIV_MEASURE6 ' || fnd_global.newline || ', ' ||
  	 l_p_total_cost || ' BIV_MEASURE7 ' || fnd_global.newline || ', ' ||
  	 l_c_total_cost || ' BIV_MEASURE8 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause (l_c_total_cost, l_p_total_cost) || ' BIV_MEASURE9 ' || fnd_global.newline || ', ' ||
  	 'NVL (c_m_cost_total, 0) BIV_MEASURE10 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('c_m_cost_total', 'p_m_cost_total') || ' BIV_MEASURE11 ' || fnd_global.newline || ', ' ||
  	 'NVL (c_l_cost_total, 0) BIV_MEASURE12 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('c_l_cost_total', 'p_l_cost_total') || ' BIV_MEASURE13 ' || fnd_global.newline || ', ' ||
  	 'NVL (c_e_cost_total, 0) BIV_MEASURE14 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('c_e_cost_total', 'p_e_cost_total') || ' BIV_MEASURE15 ' || fnd_global.newline || ', ' ||
  	 l_c_total_cost_total || ' BIV_MEASURE16 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause (l_c_total_cost_total, l_p_total_cost_total) || ' BIV_MEASURE17 ' || fnd_global.newline;

Line: 1108


  	' SELECT ' ||
  	 ' cal.name VIEWBY ' || fnd_global.newline || ', ' ||
  	 'NVL (iset.c_m_cost, 0) BIV_MEASURE1 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('iset.c_m_cost', 'iset.p_m_cost') || ' BIV_MEASURE2 ' || fnd_global.newline || ', ' ||
  	 'NVL (iset.c_l_cost, 0) BIV_MEASURE3 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('iset.c_l_cost', 'iset.p_l_cost') || ' BIV_MEASURE4 ' || fnd_global.newline || ', ' ||
  	 'NVL (iset.c_e_cost, 0) BIV_MEASURE5 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('iset.c_e_cost', 'iset.p_e_cost') || ' BIV_MEASURE6 ' || fnd_global.newline || ', ' ||
  	 l_p_total_cost || ' BIV_MEASURE7 ' || fnd_global.newline || ', ' ||
  	 l_c_total_cost || ' BIV_MEASURE8 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause (l_c_total_cost, l_p_total_cost) || ' BIV_MEASURE9 ' || fnd_global.newline;

Line: 1277


     	' SELECT ' ||
      	ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||
      	l_description || ' BIV_ATTRIBUTE1 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE1 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE2 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE3 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE4 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE5 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE6 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE7 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE8 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE9 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE10 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE11 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE12 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE13 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE14 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE15 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE16 ' || fnd_global.newline || ',' ||
      	'BIV_MEASURE17 ' || fnd_global.newline || ',' ||
  	 l_cat_drill_down || ' BIV_DYNAMIC_URL1 ' || fnd_global.newline ||
  	'FROM ( SELECT   ' || fnd_global.newline ||
  	' rank() over (&ORDER_BY_CLAUSE'||' nulls last, '|| p_view_by_col ||' ) - 1 rnk' || fnd_global.newline || ', ' ||
  	 p_view_by_col  || fnd_global.newline || ', ' ||
      	'BIV_MEASURE1 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE2 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE3 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE4 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE5 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE6 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE7 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE8 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE9 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE10 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE11 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE12 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE13 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE14 ' || fnd_global.newline || ', ' ||
      	'BIV_MEASURE15 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE16 ' || fnd_global.newline || ', ' ||
    	'BIV_MEASURE17 ' || fnd_global.newline ||
  	'FROM (' || fnd_global.newline ||
  	' SELECT ' || p_view_by_col || fnd_global.newline || ', ' ||
  	 'NVL (c_m_margin, 0) BIV_MEASURE1 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('c_m_margin', 'p_m_margin') || ' BIV_MEASURE2 ' || fnd_global.newline || ', ' ||
  	 'NVL (c_l_margin, 0) BIV_MEASURE3 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('c_l_margin', 'p_l_margin') || ' BIV_MEASURE4 ' || fnd_global.newline || ', ' ||
  	 'NVL (c_e_margin,0) BIV_MEASURE5 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('c_e_margin', 'p_e_margin') || ' BIV_MEASURE6 ' || fnd_global.newline || ', ' ||
  	 l_p_total_margin || ' BIV_MEASURE7 ' || fnd_global.newline || ', ' ||
  	 l_c_total_margin || ' BIV_MEASURE8 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause (l_c_total_margin, l_p_total_margin) || ' BIV_MEASURE9 ' || fnd_global.newline || ', ' ||
  	 'NVL (c_m_margin_total, 0) BIV_MEASURE10 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('c_m_margin_total', 'p_m_margin_total') || ' BIV_MEASURE11 ' || fnd_global.newline || ', ' ||
  	 'NVL (c_l_margin_total, 0) BIV_MEASURE12 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('c_l_margin_total', 'p_l_margin_total') || ' BIV_MEASURE13 ' || fnd_global.newline || ', ' ||
  	 'NVL (c_e_margin_total, 0) BIV_MEASURE14 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('c_e_margin_total', 'p_e_margin_total') || ' BIV_MEASURE15 ' || fnd_global.newline || ', ' ||
  	 l_c_total_margin_total || ' BIV_MEASURE16 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause (l_c_total_margin_total, l_p_total_margin_total) || ' BIV_MEASURE17 ' || fnd_global.newline;

Line: 1473


  	' SELECT ' ||
  	 ' cal.name VIEWBY ' || fnd_global.newline || ', ' ||
  	 'NVL (iset.c_m_margin, 0) BIV_MEASURE1 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('iset.c_m_margin', 'iset.p_m_margin') || ' BIV_MEASURE2 ' || fnd_global.newline || ', ' ||
  	 'NVL (iset.c_l_margin, 0) BIV_MEASURE3 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('iset.c_l_margin', 'iset.p_l_margin') || ' BIV_MEASURE4 ' || fnd_global.newline || ', ' ||
  	 'NVL (iset.c_e_margin, 0) BIV_MEASURE5 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause ('iset.c_e_margin', 'iset.p_e_margin') || ' BIV_MEASURE6 ' || fnd_global.newline || ', ' ||
  	 l_p_total_margin || ' BIV_MEASURE7 ' || fnd_global.newline || ', ' ||
  	 l_c_total_margin || ' BIV_MEASURE8 ' || fnd_global.newline || ', ' ||
  	 poa_dbi_util_pkg.change_clause (l_c_total_margin, l_p_total_margin) || ' BIV_MEASURE9 ' || fnd_global.newline;

Line: 1616


        'SELECT '||
		'BIV_ATTRIBUTE1 ' || fnd_global.newline || ', ' ||
		'BIV_ATTRIBUTE2 ' || fnd_global.newline || ', ' ||
		'BIV_ATTRIBUTE3 ' || fnd_global.newline || ', ' ||
		'BIV_ATTRIBUTE4 ' || fnd_global.newline || ', ' ||
		'BIV_ATTRIBUTE5 ' || fnd_global.newline || ', ' ||
		'BIV_MEASURE2 ' || fnd_global.newline || ', ' ||
		'BIV_MEASURE3 ' || fnd_global.newline || ', ' ||
		'BIV_MEASURE4 ' || fnd_global.newline || ', ' ||
		'BIV_MEASURE6 ' || fnd_global.newline || ', ' ||
		'BIV_MEASURE7 ' || fnd_global.newline || ', ' ||
		'BIV_MEASURE8 ' || fnd_global.newline || ', ' ||
		'BIV_MEASURE10 ' || fnd_global.newline || ', ' ||
		'BIV_MEASURE11 ' || fnd_global.newline || ', ' ||
		'BIV_MEASURE12 ' || fnd_global.newline || ', ' ||
		'BIV_MEASURE14 ' || fnd_global.newline || ', ' ||
		'BIV_MEASURE15 ' || fnd_global.newline || ', ' ||
		'BIV_MEASURE16 ' || fnd_global.newline || ', ' ||
		'BIV_MEASURE17 ' || fnd_global.newline || ', ' ||
		'BIV_MEASURE18 ' || fnd_global.newline || ', ' ||
		'BIV_MEASURE19 ' || fnd_global.newline || ', ' ||
		'BIV_MEASURE20 ' || fnd_global.newline || ', ' ||
		'BIV_MEASURE21 ' || fnd_global.newline || ', ' ||
		'BIV_MEASURE22 ' || fnd_global.newline || ', ' ||
		'BIV_MEASURE23 ' || fnd_global.newline || ', ' ||
		'BIV_MEASURE24 ' || fnd_global.newline || ', ' ||
		'BIV_MEASURE25 ' || fnd_global.newline || ', ' ||
		'BIV_MEASURE26 ' || fnd_global.newline || ', ' ||
		'BIV_MEASURE27 ' || fnd_global.newline || ', ' ||
		'BIV_MEASURE28 ' || fnd_global.newline || ', ' ||
		'BIV_MEASURE29 ' || fnd_global.newline || ', ' ||
		'BIV_MEASURE30 ' || fnd_global.newline || ', ' ||
		'''pFunctionName=CSD_RO_DETAILS&csdInvOrgId=''||BIV_MEASURE30||''&csdRepairLineId=''||BIV_MEASURE29 BIV_DYNAMIC_URL1'|| ', '||
		ISC_DEPOT_RPT_UTIL_PKG.get_service_request_url || '|| BIV_ATTRIBUTE5 BIV_DYNAMIC_URL2 '||
	 ' FROM ( ' || fnd_global.newline ||
		'SELECT ' || fnd_global.newline ||
	 		'rank() over (&ORDER_BY_CLAUSE  nulls last ,BIV_ATTRIBUTE1) - 1 rnk ' || fnd_global.newline || ', ' ||
			'BIV_ATTRIBUTE1 ' || fnd_global.newline || ', ' ||
			'BIV_ATTRIBUTE2 ' || fnd_global.newline || ', ' ||
			'BIV_ATTRIBUTE3 ' || fnd_global.newline || ', ' ||
			'BIV_ATTRIBUTE4 ' || fnd_global.newline || ', ' ||
			'BIV_ATTRIBUTE5 ' || fnd_global.newline || ', ' ||
			'BIV_MEASURE2 ' || fnd_global.newline || ', ' ||
			'BIV_MEASURE3 ' || fnd_global.newline || ', ' ||
			'BIV_MEASURE4 ' || fnd_global.newline || ', ' ||
			'BIV_MEASURE6 ' || fnd_global.newline || ', ' ||
			'BIV_MEASURE7 ' || fnd_global.newline || ', ' ||
			'BIV_MEASURE8 ' || fnd_global.newline || ', ' ||
			'BIV_MEASURE10 ' || fnd_global.newline || ', ' ||
			'BIV_MEASURE11 ' || fnd_global.newline || ', ' ||
			'BIV_MEASURE12 ' || fnd_global.newline || ', ' ||
			'BIV_MEASURE14 ' || fnd_global.newline || ', ' ||
			'BIV_MEASURE15 ' || fnd_global.newline || ', ' ||
			'BIV_MEASURE16 ' || fnd_global.newline || ', ' ||
			'BIV_MEASURE17 ' || fnd_global.newline || ', ' ||
			'BIV_MEASURE18 ' || fnd_global.newline || ', ' ||
			'BIV_MEASURE19 ' || fnd_global.newline || ', ' ||
			'BIV_MEASURE20 ' || fnd_global.newline || ', ' ||
			'BIV_MEASURE21 ' || fnd_global.newline || ', ' ||
			'BIV_MEASURE22 ' || fnd_global.newline || ', ' ||
			'BIV_MEASURE23 ' || fnd_global.newline || ', ' ||
			'BIV_MEASURE24 ' || fnd_global.newline || ', ' ||
			'BIV_MEASURE25 ' || fnd_global.newline || ', ' ||
			'BIV_MEASURE26 ' || fnd_global.newline || ', ' ||
			'BIV_MEASURE27 ' || fnd_global.newline || ', ' ||
			'BIV_MEASURE28 ' || fnd_global.newline || ', ' ||
			'BIV_MEASURE29 ' || fnd_global.newline || ', ' ||
			'BIV_MEASURE30 ' || fnd_global.newline ||
  		'FROM ( ' || fnd_global.newline ||
		'SELECT ' || fnd_global.newline ||
		 'repair_number BIV_ATTRIBUTE1 ' || fnd_global.newline || ', ' ||
		 'incident_number BIV_ATTRIBUTE2 ' || fnd_global.newline || ', ' ||
		 'fact.repair_line_id BIV_MEASURE29 ' || fnd_global.newline || ', ' ||
		 'fact.master_organization_id BIV_MEASURE30 ' || fnd_global.newline || ', ' ||
		 'crt.name  BIV_ATTRIBUTE3 ' || fnd_global.newline || ', ' ||
		 'eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline || ', ' ||
		 'incident_id BIV_ATTRIBUTE5 ' || fnd_global.newline || ', ' ||
		 'NVL(charges.material_charges_' || p_curr_suffix || ', 0) BIV_MEASURE2' || fnd_global.newline || ', ' ||
		 'NVL(costs.material_cost_' || p_curr_suffix || ', 0) BIV_MEASURE3' || fnd_global.newline || ', ' ||
		 'NVL(charges.material_charges_' || p_curr_suffix || ', 0) - ' ||
			'NVL(costs.material_cost_' || p_curr_suffix || ', 0) BIV_MEASURE4' || fnd_global.newline || ', ' ||
		 'NVL(charges.labor_charges_' || p_curr_suffix || ', 0) BIV_MEASURE6' || fnd_global.newline || ', ' ||
		 'NVL(costs.labor_cost_' || p_curr_suffix || ', 0) BIV_MEASURE7' || fnd_global.newline || ', ' ||
		 'NVL(charges.labor_charges_' || p_curr_suffix || ', 0) - ' ||
			'NVL(costs.labor_cost_' || p_curr_suffix || ', 0) BIV_MEASURE8' || fnd_global.newline || ', ' ||
		 'NVL(charges.expense_charges_' || p_curr_suffix || ', 0) BIV_MEASURE10' || fnd_global.newline || ', ' ||
		 'NVL(costs.expense_cost_' || p_curr_suffix || ', 0) BIV_MEASURE11' || fnd_global.newline || ', ' ||
		 'NVL(charges.expense_charges_' || p_curr_suffix || ', 0) - ' ||
			'NVL(costs.expense_cost_' || p_curr_suffix || ', 0) BIV_MEASURE12' || fnd_global.newline || ', ' ||
		  l_total_charges || ' BIV_MEASURE14' || fnd_global.newline || ', ' ||
		  l_total_cost || ' BIV_MEASURE15' || fnd_global.newline || ', ' ||
		  l_total_margin || ' BIV_MEASURE16' || fnd_global.newline || ', ' ||
		 'NVL(sum(charges.material_charges_' || p_curr_suffix || ') over(), 0)  BIV_MEASURE17' || fnd_global.newline || ', ' ||
		 'NVL(sum(costs.material_cost_' || p_curr_suffix || ') over(), 0) BIV_MEASURE18' || fnd_global.newline || ', ' ||
		 'NVL(sum(charges.material_charges_' || p_curr_suffix || ') over(), 0) - ' ||
			'NVL(sum(costs.material_cost_' || p_curr_suffix || ') over(), 0) BIV_MEASURE19' || fnd_global.newline || ', ' ||
		 'NVL(sum(charges.labor_charges_' || p_curr_suffix || ') over(), 0) BIV_MEASURE20' || fnd_global.newline || ', ' ||
		 'NVL(sum(costs.labor_cost_' || p_curr_suffix || ') over(), 0) BIV_MEASURE21' || fnd_global.newline || ', ' ||
		 'NVL(sum(charges.labor_charges_' || p_curr_suffix || ') over(), 0) - ' ||
			'NVL(sum(costs.labor_cost_' || p_curr_suffix || ') over(), 0) BIV_MEASURE22' || fnd_global.newline || ', ' ||
		 'NVL(sum(charges.expense_charges_' || p_curr_suffix || ') over(), 0) BIV_MEASURE23' || fnd_global.newline || ', ' ||
		 'NVL(sum(costs.expense_cost_' || p_curr_suffix || ') over(), 0) BIV_MEASURE24' || fnd_global.newline || ', ' ||
		 'NVL(sum(charges.expense_charges_' || p_curr_suffix || ') over(), 0) - ' ||
			'NVL(sum(costs.expense_cost_' || p_curr_suffix || ') over(), 0) BIV_MEASURE25' || fnd_global.newline || ', ' ||
		  l_total_charges_total || ' BIV_MEASURE26' || fnd_global.newline || ', ' ||
		  l_total_cost_total || ' BIV_MEASURE27' || fnd_global.newline || ', ' ||
		  l_total_margin_total || ' BIV_MEASURE28 ' || fnd_global.newline;