APPS.ISC_DBI_SHIP_PERF_PKG SQL Statements

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

Line: 63

		(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.inv_org_id)
		OR EXISTS
		(SELECT 1
		FROM mtl_parameters org
		WHERE org.organization_id = f.inv_org_id
		AND NOT EXISTS
			(SELECT 1
			FROM org_access ora
			WHERE org.organization_id = ora.organization_id)))';

Line: 263

     l_stmt := 'SELECT org.name 	VIEWBY,
		org.organization_id	VIEWBYID,
		null			ISC_ATTRIBUTE_2,
		null			ISC_ATTRIBUTE_3,
		org.organization_id	ISC_ATTRIBUTE_4,
		'||l_outer_sql||'
		FROM(select
		(rank() over (&ORDER_BY_CLAUSE nulls last,inv_org_id))-1 rnk,
		inv_org_id,
		'||l_outer_sql||'
		FROM (select inv_org_id,
		'||l_formula_sql||'
		FROM (select f.inv_org_id INV_ORG_ID,
		'||l_inner_sql||'
		GROUP BY f.inv_org_id) c)) a,
		HR_ALL_ORGANIZATION_UNITS_TL org
		WHERE org.organization_id = a.inv_org_id
		AND org.language = :ISC_LANG
		AND ((a.rnk between &START_INDEX and &END_INDEX) OR (&END_INDEX = -1))
  		ORDER BY rnk';

Line: 285

     l_stmt := 'SELECT items.value	VIEWBY,
		items.id		VIEWBYID,
		items.id 		ISC_ATTRIBUTE_4,
		items.description	ISC_ATTRIBUTE_2,
		uom.unit_of_measure	ISC_ATTRIBUTE_3,
		'||l_outer_sql||'
		FROM(select (rank() over (&ORDER_BY_CLAUSE nulls last,item_id))-1 rnk,
		item_id,uom,
		'||l_outer_sql||'
		FROM (select item_id, uom,
		'||l_formula_sql||'
		FROM (select f.item_id ITEM_ID,f.uom,
		'||l_inner_sql||'
		GROUP by f.item_id,f.uom) c)) a,
		 ENI_ITEM_ORG_V items,
		 MTL_UNITS_OF_MEASURE_TL uom
  		WHERE a.item_id = items.id
		AND uom.uom_code= a.uom
		AND uom.language = :ISC_LANG
		AND ((a.rnk between &START_INDEX and &END_INDEX) OR (&END_INDEX = -1))
		ORDER BY rnk';

Line: 308

    l_stmt := 'SELECT 	eniv.value 	VIEWBY,
		eniv.id			VIEWBYID,
		eniv.id	 		ISC_ATTRIBUTE_4,
		null			ISC_ATTRIBUTE_2,
		null			ISC_ATTRIBUTE_3,
		'||l_outer_sql||'
		FROM(select (rank() over (&ORDER_BY_CLAUSE nulls last,item_category_id))-1 rnk,
		item_category_id,
		'||l_outer_sql||'
		FROM (select item_category_id,
		'||l_formula_sql||'
		FROM (select f.item_category_id ITEM_CATEGORY_ID,
		'||l_inner_sql||'
		GROUP by f.item_category_id) c)) a,
 		ENI_ITEM_INV_CAT_V 	eniv
		WHERE a.item_category_id = eniv.id
		AND ((a.rnk between &START_INDEX and &END_INDEX) OR (&END_INDEX = -1))
  		ORDER BY rnk';

Line: 328

    l_stmt := 'SELECT 	cust.value	VIEWBY,
		cust.id			VIEWBYID,
		cust.id	 		ISC_ATTRIBUTE_4,
		null			ISC_ATTRIBUTE_2,
		null			ISC_ATTRIBUTE_3,
		'||l_outer_sql||'
		FROM(select (rank() over (&ORDER_BY_CLAUSE nulls last,customer_id))-1 rnk,
		customer_id,
		'||l_outer_sql||'
		FROM (select customer_id,
		'||l_formula_sql||'
		FROM (select f.customer_id CUSTOMER_ID,
		'||l_inner_sql||'
		GROUP by f.customer_id) c)) a,
 		FII_CUSTOMERS_V 	cust
		WHERE a.customer_id = cust.id
		AND ((a.rnk between &START_INDEX and &END_INDEX) OR (&END_INDEX = -1))
  		ORDER BY rnk';