APPS.ISC_DBI_SHIP_LATE_TP_PKG SQL Statements

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

Line: 59

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

    l_stmt := '	SELECT eni.value 	VIEWBY,
		eni.id			VIEWBYID,
		eni.id  		ISC_ATTRIBUTE_2,
		null			ISC_ATTRIBUTE_3,
		null			ISC_ATTRIBUTE_4,
		'||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) a)
		WHERE ISC_MEASURE_1<>:ISC_CONST) c,
		ENI_ITEM_INV_CAT_V 	eni
		WHERE c.item_category_id = eni.id
		AND ((c.rnk between &START_INDEX and &END_INDEX) OR(&END_INDEX = -1))
		ORDER BY rnk';

Line: 197

     l_stmt := 'SELECT org.name 		VIEWBY,
		org.organization_id		VIEWBYID,
		org.organization_id		ISC_ATTRIBUTE_2,
		null				ISC_ATTRIBUTE_3,
		null				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) a)
		WHERE ISC_MEASURE_1<>:ISC_CONST) c,
		HR_ALL_ORGANIZATION_UNITS_TL org
		WHERE org.organization_id = c.inv_org_id
		AND org.language = :ISC_LANG
		AND ((c.rnk between &START_INDEX and &END_INDEX) OR(&END_INDEX = -1))
		ORDER BY rnk' ;

Line: 220

     l_stmt := 'SELECT items.value	VIEWBY,
		items.id		VIEWBYID,
		items.id		ISC_ATTRIBUTE_2,
		items.description	ISC_ATTRIBUTE_3,
		uom.unit_of_measure	ISC_ATTRIBUTE_4,
		'||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 UOM,
		'||l_inner_sql||'
		group by f.item_id,f.uom) a)
		WHERE ISC_MEASURE_1<>:ISC_CONST) c,
		 ENI_ITEM_ORG_V 	items,
		 MTL_UNITS_OF_MEASURE_TL uom
  		WHERE c.item_id = items.id
		AND uom.uom_code = c.uom
		AND uom.language = :ISC_LANG
		AND ((c.rnk between &START_INDEX and &END_INDEX) OR(&END_INDEX = -1))
		ORDER BY rnk';

Line: 244

     l_stmt := 'SELECT cust.value 	VIEWBY,
		cust.id			VIEWBYID,
		cust.id  		ISC_ATTRIBUTE_2,
		null			ISC_ATTRIBUTE_3,
		null			ISC_ATTRIBUTE_4,
		'||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) a)
		WHERE ISC_MEASURE_1<>:ISC_CONST) c,
		FII_CUSTOMERS_V 	cust
  		WHERE c.customer_id = cust.id
		AND ((c.rnk between &START_INDEX and &END_INDEX) OR(&END_INDEX = -1))
		ORDER BY rnk';