APPS.ISC_DBI_DAYS_SHIP_PKG SQL Statements

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

Line: 61

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

SELECT	items.value					 	VIEWBY,
	items.id						VIEWBYID,
	items.value					  	ISC_ATTRIBUTE_2,
	items.description  					ISC_ATTRIBUTE_3,
	'||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)
	WHERE ISC_MEASURE_5 IS NOT NULL OR ISC_MEASURE_8 IS NOT NULL) 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: 252

SELECT	org.name 						VIEWBY,
	org.organization_id					VIEWBYID,
	org.name						ISC_ATTRIBUTE_2,
	null							ISC_ATTRIBUTE_3,
	'||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)
	WHERE ISC_MEASURE_5 IS NOT NULL OR ISC_MEASURE_8 IS NOT NULL) 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: 273

SELECT	cust.value						VIEWBY,
	cust.id							VIEWBYID,
	cust.value						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)
	WHERE ISC_MEASURE_5 IS NOT NULL OR ISC_MEASURE_8 IS NOT NULL) 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';

Line: 293

SELECT	eni.value 						VIEWBY,
	eni.id				 			VIEWBYID,
	eni.value					  	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)
	WHERE ISC_MEASURE_5 IS NOT NULL OR ISC_MEASURE_8 IS NOT NULL) a,
	ENI_ITEM_INV_CAT_V		eni
  WHERE a.item_category_id = eni.id
    AND	((a.rnk between &START_INDEX and &END_INDEX) OR (&END_INDEX = -1))
  ORDER BY rnk';