APPS.ISC_DBI_PLAN_RM_PKG SQL Statements

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

Line: 15

  l_inner_select_stmt		VARCHAR2(10000);

Line: 19

  l_qty_select			VARCHAR2(10000);

Line: 104

		  (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: 189

SELECT	0	VIEWBY,
	0	VIEWBYID,
	0	ISC_ATTRIBUTE_1,
	0	ISC_ATTRIBUTE_2,
	0	ISC_ATTRIBUTE_3,
	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,
	0 	ISC_MEASURE_21,
	0 	ISC_MEASURE_22,
	0 	ISC_MEASURE_23,
	0 	ISC_MEASURE_24
  FROM	dual
 WHERE	1 = 2 /* PLAN_SNAPSHOT dimension has not been populated */';

Line: 225

	l_inner_select_stmt := 'SELECT eni_cat.parent_id			VBH_CATEGORY_ID,';

Line: 229

	l_inner_select_stmt := 'SELECT eni_cat.imm_child_id			VBH_CATEGORY_ID,';

Line: 238

	l_inner_select_stmt := 'SELECT f.parent_id			VBH_CATEGORY_ID,';

Line: 253

    THEN l_qty_select := '
		sum(decode(f.snapshot_id, &PLAN_SNAPSHOT+PLAN_SNAPSHOT+PLAN_SNAPSHOT,
			   f.mds_quantity, 0))		QTY,';

Line: 256

    ELSE l_qty_select := '
		null					QTY,';

Line: 312

  l_inner_sql := l_qty_select||'
		sum(decode(f.snapshot_id, &PLAN_SNAPSHOT+PLAN_SNAPSHOT+PLAN_SNAPSHOT,
			   f.mds_price'||l_curr_suffix||', 0))		REV,
		decode(&PLAN_SNAPSHOT+PLAN_SNAPSHOT+PLAN_SNAPSHOT_2, -1, null,
			sum(decode(f.snapshot_id, &PLAN_SNAPSHOT+PLAN_SNAPSHOT+PLAN_SNAPSHOT_2,
				   f.mds_price'||l_curr_suffix||', 0)))	COMP_REV,
		sum(decode(f.snapshot_id, &PLAN_SNAPSHOT+PLAN_SNAPSHOT+PLAN_SNAPSHOT,
			   f.mds_cost'||l_curr_suffix||', 0))		COST,
		decode(&PLAN_SNAPSHOT+PLAN_SNAPSHOT+PLAN_SNAPSHOT_2, -1, null,
			sum(decode(f.snapshot_id, &PLAN_SNAPSHOT+PLAN_SNAPSHOT+PLAN_SNAPSHOT_2,
				   f.mds_cost'||l_curr_suffix||', 0)))	COMP_COST
	   FROM	'||l_mv||'		f'
		||l_prod_cat_from||'
	  WHERE	f.start_date = :ISC_TIME_FROM
	    AND	f.period_type_id =:ISC_PERIOD_TYPE_ID
	    AND f.snapshot_id IN (&PLAN_SNAPSHOT+PLAN_SNAPSHOT+PLAN_SNAPSHOT, &PLAN_SNAPSHOT+PLAN_SNAPSHOT+PLAN_SNAPSHOT_2)'
		||l_flags_where
		||l_org_where
		||l_prod_cat_where
		||l_prod_where;

Line: 335

SELECT	items.value		VIEWBY,
	items.id		VIEWBYID,
	null		 	ISC_ATTRIBUTE_1, -- drill across URL
	items.description	ISC_ATTRIBUTE_2, -- Description
	mtl.unit_of_measure	ISC_ATTRIBUTE_3, -- UOM
	'||l_outer_sql||'
  FROM	(SELECT	(rank() over (&ORDER_BY_CLAUSE NULLS LAST,item_id))-1 RNK,
	item_id, uom,
	'||l_outer_sql||'
    FROM (SELECT c.item_id, c.uom,'
	 ||l_formula_sql||'
     FROM (SELECT f.item_id				ITEM_ID,
		  f.uom_code				UOM,'
	   ||l_inner_sql||'
	      GROUP BY f.item_id, f.uom_code) c)'
		||l_row_filter||'
	   OR (ISC_MEASURE_1 IS NOT NULL AND ISC_MEASURE_1 <> 0)
	)			a,
	ENI_ITEM_ORG_V		items,
	MTL_UNITS_OF_MEASURE_TL	mtl
  WHERE a.item_id = items.id
    AND a.uom = mtl.uom_code
    AND mtl.language = :ISC_LANG
    AND	((a.rnk between &START_INDEX and &END_INDEX) OR (&END_INDEX = -1))
  ORDER BY rnk';

Line: 363

SELECT	org.name 		VIEWBY,
	org.organization_id	VIEWBYID,
	null			ISC_ATTRIBUTE_1, -- drill across URL
	null			ISC_ATTRIBUTE_2, -- Description
	null			ISC_ATTRIBUTE_3, -- UOM
	'||l_outer_sql||'
  FROM	(SELECT	(rank() over (&ORDER_BY_CLAUSE NULLS LAST,organization_id))-1 RNK,
	organization_id,
	'||l_outer_sql||'
    FROM (SELECT c.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: 387

SELECT	eni.value 		VIEWBY,
	eni.id			VIEWBYID,
	decode(eni.leaf_node_flag, ''Y'',
		''pFunctionName=ISC_DBI_PLAN_RM&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=ITEM+ENI_ITEM_ORG&pParamIds=Y'',
		''pFunctionName=ISC_DBI_PLAN_RM&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=ITEM+ENI_ITEM_VBH_CAT&pParamIds=Y'')
				ISC_ATTRIBUTE_1, -- drill across URL
	null			ISC_ATTRIBUTE_2, -- Description
	null			ISC_ATTRIBUTE_3, -- UOM
	'||l_outer_sql||'
  FROM	(SELECT	(rank() over (&ORDER_BY_CLAUSE NULLS LAST,vbh_category_id))-1 RNK,
	vbh_category_id,
	'||l_outer_sql||'
    FROM (SELECT c.vbh_category_id,'
	  ||l_formula_sql||'
   	FROM ('||l_inner_select_stmt
	       ||l_inner_sql
	       ||l_inner_group_by_stmt||') c)'
		||l_row_filter||'
	)			a,
	ENI_ITEM_VBH_NODES_V	eni
  WHERE a.vbh_category_id = eni.id
    AND	eni.parent_id = eni.child_id
    AND	((a.rnk between &START_INDEX and &END_INDEX) OR (&END_INDEX = -1))
  ORDER BY rnk';