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

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

Line: 174


        'SELECT    '|| ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||
		    l_description || ' BIV_ATTRIBUTE10 ';

Line: 221


	'FROM ( SELECT
		     rank() over (&ORDER_BY_CLAUSE'||' nulls last, '||p_view_by_col||') - 1 rnk
	           ,'||p_view_by_col;

Line: 266


        'FROM ( SELECT  '  || fnd_global.newline ||
                         p_view_by_col || fnd_global.newline ||
	         ',' || 'NVL(p_ro_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
	         ',' || 'NVL(c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
	         ',' || poa_dbi_util_pkg.change_clause( cur_col     => 'c_ro_count'
	                                               ,prior_col   => 'p_ro_count'
	                                               ,change_type =>  'NP') -- 'P' for Percent ; 'NP' for non percent

Line: 476


        'SELECT  cal.name VIEWBY ' || fnd_global.newline ||
		 ',' || 'NVL(iset.p_ro_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
                 ',' || 'NVL(iset.c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
                 ',' || poa_dbi_util_pkg.change_clause( cur_col     => 'iset.c_ro_count'
                                                       ,prior_col   => 'iset.p_ro_count'
                                                       ,change_type =>  'NP') -- 'P' for Percent ; 'NP' for non percent

Line: 586


        'SELECT
		 BIV_ATTRIBUTE1
		,BIV_ATTRIBUTE2
		,BIV_ATTRIBUTE3
		,BIV_ATTRIBUTE4
		,BIV_ATTRIBUTE5
		,BIV_ATTRIBUTE6
		,BIV_MEASURE1
		,BIV_ATTRIBUTE7
		,BIV_ATTRIBUTE8
		,BIV_DATE1
		,BIV_DATE2
		,BIV_DATE3
		,BIV_MEASURE2
		,BIV_MEASURE3
		,BIV_MEASURE4
		,''pFunctionName=CSD_RO_DETAILS&csdInvOrgId=''||BIV_MEASURE4||''&csdRepairLineId=''||BIV_MEASURE3 BIV_DYNAMIC_URL1
		,' || ISC_DEPOT_RPT_UTIL_PKG.get_service_request_url || '|| BIV_ATTRIBUTE8 BIV_DYNAMIC_URL2
	 FROM (
		SELECT
	 		 rank() over (&ORDER_BY_CLAUSE nulls last,repair_line_id ) - 1 rnk
			,BIV_ATTRIBUTE1
			,BIV_ATTRIBUTE2
			,BIV_ATTRIBUTE3
			,BIV_ATTRIBUTE4
			,BIV_ATTRIBUTE5
			,BIV_ATTRIBUTE6
			,BIV_MEASURE1
			,BIV_ATTRIBUTE7
			,BIV_ATTRIBUTE8
			,BIV_DATE1
			,BIV_DATE2
			,BIV_DATE3
			,BIV_MEASURE2
			,BIV_MEASURE3
			,BIV_MEASURE4
	  FROM ( SELECT fact1.repair_line_id repair_line_id' || fnd_global.newline ||
			 ',' ||	' fact.repair_number BIV_ATTRIBUTE1 ' || fnd_global.newline ||
        	         ',' || ' fact.incident_number BIV_ATTRIBUTE2 ' || fnd_global.newline ||
        	         ',' || ' crt.name BIV_ATTRIBUTE3 ' || fnd_global.newline ||
        	         ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||
        	         ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||
        	         ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||
        	         ',' || ' fact.incident_id    BIV_ATTRIBUTE8 ' || fnd_global.newline ||
        	         ',' || ' fact.repair_line_id  BIV_MEASURE3 ' || fnd_global.newline ||
        	         ',' || ' fact.master_organization_id    BIV_MEASURE4 ' || fnd_global.newline ||
        	         ',' || ' fact.quantity BIV_MEASURE1 ' || fnd_global.newline ||
        	         ',' || ' fact.serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||
        	         ',' || ' fact.promise_date BIV_DATE1 ' || fnd_global.newline ||
        	         ',' || ' trunc(fact1.repair_start_date) BIV_DATE2 ' || fnd_global.newline ||
        	         ',' || ' trunc(fact1.repair_end_date) BIV_DATE3 ' || fnd_global.newline ||
        	         ',' || ' fact1.time_to_repair BIV_MEASURE2 ' || fnd_global.newline ||
        	         '        FROM '|| fnd_global.newline || l_mv ||
        	         '        ISC_DR_REPAIR_ORDERS_F fact' || fnd_global.newline ||
        	         ',' || ' ISC_DR_MTTR_F fact1' || fnd_global.newline ||
        	         ',' || ' MTL_UNITS_OF_MEASURE_VL mum' || fnd_global.newline ||
        	         ',' || ' ENI_ITEM_V eiov' || fnd_global.newline ||
        	         '        WHERE fact.dbi_date_closed BETWEEN &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline ||
        	         '        AND fact.item_org_id = eiov.id' || fnd_global.newline ||
        	         '        AND fact.repair_line_id = fact1.repair_line_id' || fnd_global.newline ||
			 '	  AND fact1.time_to_repair >= 0' || fnd_global.newline ||
        	         '        AND mum.uom_code = fact.uom_code' || fnd_global.newline || l_where_clause
        	  	     || ' ) ) where (rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1)
				  ORDER BY rnk' ;

Line: 801


        'SELECT    '|| ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||
		    l_description || ' BIV_ATTRIBUTE10
		    ,BIV_MEASURE11
		    ,BIV_MEASURE1
		    ,BIV_MEASURE2
		    ,BIV_MEASURE12
		    ,BIV_MEASURE3
		    ,BIV_MEASURE4
		    ,BIV_MEASURE21
		    ,BIV_MEASURE22
		    ,BIV_MEASURE23
		    ,BIV_MEASURE24';

Line: 832


	'FROM ( SELECT rank() over (&ORDER_BY_CLAUSE'||' nulls last, '||p_view_by_col||' ) - 1 rnk
	           ,'||p_view_by_col||'
		    ,BIV_MEASURE11
		    ,BIV_MEASURE1
		    ,BIV_MEASURE2
		    ,BIV_MEASURE12
		    ,BIV_MEASURE3
		    ,BIV_MEASURE4
		    ,BIV_MEASURE21
		    ,BIV_MEASURE22
		    ,BIV_MEASURE23
		    ,BIV_MEASURE24';

Line: 861


        l_sel_clause := l_sel_clause || 'FROM ( SELECT  '  || fnd_global.newline ||
                     p_view_by_col || fnd_global.newline ||
                 ',' || 'NVL(p_ro_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
                 ',' || 'NVL(c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
                 ',' || poa_dbi_util_pkg.change_clause( cur_col     => 'c_ro_count'
                                                       ,prior_col   => 'p_ro_count'
                                                       ,change_type =>  'NP') -- 'P' for Percent ; 'NP' for non percent

Line: 1042


        'SELECT  cal.name VIEWBY ' || fnd_global.newline ||
		 ',' || 'NVL(iset.p_ro_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
                 ',' || 'NVL(iset.c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
                 ',' || poa_dbi_util_pkg.change_clause( cur_col     => 'iset.c_ro_count'
                                                       ,prior_col   => 'iset.p_ro_count'
                                                       ,change_type =>  'NP') -- 'P' for Percent ; 'NP' for non percent

Line: 1195


        'SELECT    '|| ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||
	           ' v.description BIV_ATTRIBUTE6 ' || fnd_global.newline ||
		   ',BIV_MEASURE11
		    ,BIV_MEASURE1
		    ,BIV_MEASURE2
		    ,BIV_MEASURE12
		    ,BIV_MEASURE5
		    ,BIV_MEASURE6
		    ,BIV_MEASURE7' || fnd_global.newline ||
	'FROM ( SELECT
		     rank() over (&ORDER_BY_CLAUSE'||' nulls last ,'||p_view_by_col||' ) - 1 rnk
 	           ,'||p_view_by_col||'
         	   ,BIV_MEASURE11
		   ,BIV_MEASURE1
		   ,BIV_MEASURE2
		   ,BIV_MEASURE12
		   ,BIV_MEASURE5
		   ,BIV_MEASURE6
		   ,BIV_MEASURE7' || fnd_global.newline ||
        'FROM ( SELECT  '  || fnd_global.newline ||
                     p_view_by_col || fnd_global.newline ||
                 ',' || ' NVL(p_ro_count,0) BIV_MEASURE11' || fnd_global.newline ||
 	         ',' || ' NVL(c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
                 ',' ||   poa_dbi_util_pkg.change_clause( cur_col     => 'c_ro_count'
                                                         ,prior_col   => 'p_ro_count'
                                                         ,change_type =>  'NP') -- 'P' for Percent ; 'NP' for non percent