APPS.ISC_DBI_RETURN_DETAIL_PKG SQL Statements

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

Line: 73

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

Line: 129

 SELECT	ISC_ATTRIBUTE_7,ISC_ATTRIBUTE_3, ISC_ATTRIBUTE_4,
	org.name						ISC_ATTRIBUTE_8,
	cust.value						ISC_ATTRIBUTE_5,
	ISC_ATTRIBUTE_6,  ISC_MEASURE_1, ISC_MEASURE_2
   FROM
(SELECT	(rank() over (&ORDER_BY_CLAUSE, isc_attribute_7, isc_attribute_4)) - 1	rnk,
	customer_id,
	inv_org_id,
	ISC_ATTRIBUTE_3, ISC_ATTRIBUTE_4, ISC_ATTRIBUTE_6, ISC_ATTRIBUTE_7,
	ISC_MEASURE_1, ISC_MEASURE_2
   FROM
(SELECT	mv.customer_id						CUSTOMER_ID,
	mv.inv_org_id						INV_ORG_ID,
	mv.order_number						ISC_ATTRIBUTE_3,
	mv.line_number						ISC_ATTRIBUTE_4,
	mv.time_fulfilled_date_id				ISC_ATTRIBUTE_6,
	mv.header_id						ISC_ATTRIBUTE_7,
	mv.'||l_return_amt||'					ISC_MEASURE_1,
	sum(mv.'||l_return_amt||') over()			ISC_MEASURE_2
   FROM ISC_DBI_CFM_003_MV	mv'
	||l_prod_cat_from||'
  WHERE mv.time_fulfilled_date_id BETWEEN &BIS_CURRENT_EFFECTIVE_START_DATE
				      AND &BIS_CURRENT_ASOF_DATE'
	||l_org_where
	||l_prod_cat_where
	||l_prod_where
	||l_cust_where
	||l_ret_reason_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';