APPS.ISC_DBI_PDUE_SCH_DETAIL_PKG SQL Statements

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

Line: 90

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

Line: 189

	SELECT 1
	  FROM ISC_DBI_CFM_013_MV	fact
	 WHERE fact.time_snapshot_date_id BETWEEN :l_effective_start_date
					      AND :l_as_of_date
	   AND rownum = 1 ';

Line: 223

	 SELECT	0		ISC_ATTRIBUTE_2,
		0		ISC_ATTRIBUTE_3,
		0		ISC_ATTRIBUTE_8,
		0		ISC_ATTRIBUTE_4,
		null		ISC_ATTRIBUTE_5,
		0		ISC_ATTRIBUTE_7,
		0		ISC_MEASURE_1,
		0		ISC_MEASURE_2,
		0		ISC_MEASURE_3
	   FROM	dual
	  WHERE 1 = 2 -- no snapshot taken in the current period';

Line: 236

 SELECT
	ISC_ATTRIBUTE_2,
	ISC_ATTRIBUTE_3,
	org.name						ISC_ATTRIBUTE_8,
	cust.value						ISC_ATTRIBUTE_4,
	ISC_ATTRIBUTE_5,
	ISC_ATTRIBUTE_7,
	ISC_MEASURE_1, ISC_MEASURE_2, ISC_MEASURE_3
   FROM
(SELECT	(rank() over (&ORDER_BY_CLAUSE, isc_attribute_7, isc_attribute_3)) - 1	rnk,
	customer_id,
	inv_org_id,
	'||l_measures||'
   FROM
(SELECT	fact.customer_id					CUSTOMER_ID,
	fact.inv_org_id						INV_ORG_ID,
	fact.order_number					ISC_ATTRIBUTE_2, -- order number
	fact.line_number					ISC_ATTRIBUTE_3, -- line number
	fact.time_booked_date_id				ISC_ATTRIBUTE_5, -- booked date
	fact.header_id						ISC_ATTRIBUTE_7, -- header_id
	fact.pdue_amt_'||l_curr_suffix||'			ISC_MEASURE_1, -- pdue
	fact.days_late						ISC_MEASURE_2, -- days late
	sum(fact.pdue_amt_'||l_curr_suffix||') over ()		ISC_MEASURE_3  -- gd total pdue
   FROM	ISC_DBI_CFM_013_MV			fact,
	(SELECT max(fact.time_snapshot_date_id)		day
	   FROM	ISC_DBI_CFM_013_MV			fact
	  WHERE	fact.time_snapshot_date_id BETWEEN &BIS_CURRENT_EFFECTIVE_START_DATE
					       AND &BIS_CURRENT_ASOF_DATE)	snap'||l_prod_cat_from||'
  WHERE	fact.time_snapshot_date_id = snap.day
    AND fact.late_schedule_flag = 1'
	||l_inv_org_where
	||l_prod_cat_where
	||l_prod_where
	||l_cust_where
	||l_bucket_low_where
	||l_bucket_high_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';