APPS.ISC_DBI_SHIP_LATE_TP_D_PKG SQL Statements

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

Line: 50

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

   l_stmt := 'SELECT ISC_ATTRIBUTE_2,
		ISC_MEASURE_1,
		org.name	ISC_ATTRIBUTE_5,
		cust.value  	ISC_ATTRIBUTE_3,
		ISC_ATTRIBUTE_4,
		ISC_MEASURE_2,ISC_MEASURE_3
		FROM (select (rank() over (&ORDER_BY_CLAUSE nulls last,ISC_MEASURE_3,ISC_MEASURE_1)) - 1 rnk,
		customer_id,
		inv_org_id,
		ISC_ATTRIBUTE_2,ISC_ATTRIBUTE_4,ISC_MEASURE_1,
		ISC_MEASURE_2,ISC_MEASURE_3
		FROM(select customer_id,
		inv_org_id,
		order_number				ISC_ATTRIBUTE_2,
		time_shipped_date_id			ISC_ATTRIBUTE_4,
		line_number				ISC_MEASURE_1,
		days_late_promise			ISC_MEASURE_2,
		header_id				ISC_MEASURE_3
		FROM ISC_DBI_FM_0003_MV f
		WHERE f.time_shipped_date_id between
		&BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE
		AND f.late_promise_flag = :ISC_LATE_PROMISE_FLAG'
		||l_org_where||l_inv_cat_where||l_item_where||l_cust_where||')) a,
		FII_CUSTOMERS_V		cust,
		HR_ALL_ORGANIZATION_UNITS_TL org
  		WHERE a.customer_id = cust.id
		AND a.inv_org_id = org.organization_id
		AND org.language = :ISC_LANG
		AND ((a.rnk between &START_INDEX and &END_INDEX) OR(&END_INDEX = -1))
		ORDER BY rnk';