APPS.ISC_DBI_PAST_DUE_DETAIL_PKG SQL Statements

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

Line: 64

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

SELECT	mv.customer_id				CUSTOMER_ID,
	mv.inv_org_id				INV_ORG_ID,
	mv.order_number				ISC_ATTRIBUTE_2,
	mv.time_booked_date_id			ISC_ATTRIBUTE_4,
	mv.line_number				ISC_ATTRIBUTE_8,
	null					ISC_MEASURE_1,  -- obsolete
	mv.days_late				ISC_MEASURE_2,
	mv.header_id				ISC_MEASURE_3,
	null					ISC_MEASURE_4,  -- obsolete
	null					ISC_MEASURE_5,  -- obsolete
	null					ISC_MEASURE_6,  -- obsolete
	null					CURRENCY	-- obsolete
   FROM ISC_DBI_FM_0008_MV	mv,
	(SELECT max(time_snapshot_date_id)		DAY
	   FROM	ISC_DBI_FM_0008_MV		mv
	  WHERE	mv.time_snapshot_date_id BETWEEN &BIS_CURRENT_EFFECTIVE_START_DATE
					     AND &BIS_CURRENT_ASOF_DATE
			)	a
  WHERE mv.time_snapshot_date_id = a.day'
	||l_inv_org_where||l_cust_where||l_inv_cat_where||l_item_where||l_bucket_low_where||l_bucket_high_where;

Line: 167

SELECT
      ISC_ATTRIBUTE_2,
	ISC_ATTRIBUTE_8,
	org.name	ISC_ATTRIBUTE_9,
	cust.value	ISC_ATTRIBUTE_3,
	ISC_ATTRIBUTE_4,ISC_MEASURE_2,
	ISC_MEASURE_3,ISC_MEASURE_1,ISC_MEASURE_4,ISC_MEASURE_5,ISC_MEASURE_6,CURRENCY
  FROM (SELECT (rank() over (&ORDER_BY_CLAUSE NULLS LAST, isc_measure_3, isc_attribute_8))-1 rnk,
	customer_id,
	inv_org_id,
	'||l_outer_sql||'
   FROM ('||l_sql_stmt||')) c,
	FII_CUSTOMERS_V		cust,
	HR_ALL_ORGANIZATION_UNITS_TL org
  WHERE	c.customer_id = cust.id
    AND c.inv_org_id = org.organization_id
    AND org.language = :ISC_LANG
    AND	((c.rnk between &START_INDEX and &END_INDEX) OR (&END_INDEX = -1))
  ORDER BY rnk';