DBA Data[Home] [Help]

APPS.ISC_DBI_PLAN_CB_SUM_PKG SQL Statements

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

Line: 107

		(SELECT 1
		FROM org_access o
		WHERE o.responsibility_id = fnd_global.resp_id
		AND o.resp_application_id = fnd_global.resp_appl_id
		AND o.organization_id = f.organization_id)
	     OR EXISTS
		(SELECT 1
		FROM mtl_parameters org
		WHERE org.organization_id = f.organization_id
		AND NOT EXISTS
			(SELECT 1
			FROM org_access ora
			WHERE org.organization_id = ora.organization_id)))';
Line: 168

SELECT	0	VIEWBY,
	0	VIEWBYID,
	0	ISC_ATTRIBUTE_1,
	0 	ISC_MEASURE_1,
	0 	ISC_MEASURE_2,
	0 	ISC_MEASURE_3,
	0 	ISC_MEASURE_4,
	0 	ISC_MEASURE_5,
	0 	ISC_MEASURE_6,
	0 	ISC_MEASURE_7,
	0 	ISC_MEASURE_8,
	0 	ISC_MEASURE_9,
	0 	ISC_MEASURE_10,
	0 	ISC_MEASURE_11,
	0 	ISC_MEASURE_12,
	0 	ISC_MEASURE_13,
	0 	ISC_MEASURE_14,
	0 	ISC_MEASURE_15,
	0 	ISC_MEASURE_16,
	0 	ISC_MEASURE_17,
	0 	ISC_MEASURE_18,
	0 	ISC_MEASURE_19,
	0 	ISC_MEASURE_20
  FROM	dual
 WHERE	1 = 2 /* PLAN_SNAPSHOT dimension has not been populated */';
Line: 261

SELECT	items.value		VIEWBY,
	items.id		VIEWBYID,
	items.description  	ISC_ATTRIBUTE_1, -- Description
	'||l_outer_sql||'
  FROM	(SELECT	(rank() over (&ORDER_BY_CLAUSE NULLS LAST,item_id))-1 RNK,
	item_id,
	'||l_outer_sql||'
    FROM (SELECT item_id,
	'||l_formula_sql||'
     FROM (SELECT f.item_id			ITEM_ID,
	  '||l_inner_sql||'
	      GROUP BY f.item_id) c)'
		||l_row_filter||'
	)		a,
	ENI_ITEM_ORG_V	items
  WHERE a.item_id = items.id
    AND	((a.rnk between &START_INDEX and &END_INDEX) OR (&END_INDEX = -1))
  ORDER BY rnk';
Line: 282

SELECT	org.name 		VIEWBY,
	org.organization_id	VIEWBYID,
	null			ISC_ATTRIBUTE_1, -- Description
	'||l_outer_sql||'
  FROM	(SELECT	(rank() over (&ORDER_BY_CLAUSE NULLS LAST,organization_id))-1 RNK,
	organization_id,
	'||l_outer_sql||'
    FROM (SELECT organization_id,
	 '||l_formula_sql||'
   	FROM (SELECT f.organization_id			ORGANIZATION_ID,
	     '||l_inner_sql||'
	      GROUP BY f.organization_id) c)'
		||l_row_filter||'
	)				a,
	HR_ALL_ORGANIZATION_UNITS_TL	org
  WHERE org.organization_id = a.organization_id
    AND org.language = :ISC_LANG
    AND	((a.rnk between &START_INDEX and &END_INDEX) OR (&END_INDEX = -1))
  ORDER BY rnk';
Line: 304

SELECT	eni.value 		VIEWBY,
	eni.id			VIEWBYID,
	null			ISC_ATTRIBUTE_1, -- Description
	'||l_outer_sql||'
  FROM	(SELECT	(rank() over (&ORDER_BY_CLAUSE NULLS LAST,inv_category_id))-1 RNK,
	inv_category_id,
	'||l_outer_sql||'
    FROM (SELECT inv_category_id,
	 '||l_formula_sql||'
   	FROM (SELECT f.inv_category_id		INV_CATEGORY_ID,
	     '||l_inner_sql||'
	      GROUP BY f.inv_category_id) c)'
		||l_row_filter||'
	)			a,
	ENI_ITEM_INV_CAT_V	eni
  WHERE a.inv_category_id = eni.id
    AND	((a.rnk between &START_INDEX and &END_INDEX) OR (&END_INDEX = -1))
  ORDER BY rnk';