APPS.ISC_DBI_PDUE_PRM_TREND_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 = 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: 159

 SELECT	fii.name						VIEWBY,
	s.prev_pdue_value					ISC_MEASURE_1, -- pdue prior
	s.curr_pdue_value					ISC_MEASURE_2, -- pdue
	(s.curr_pdue_value - s.prev_pdue_value)
	  / decode(s.prev_pdue_value, 0, NULL,
		   abs(s.prev_pdue_value)) * 100		ISC_MEASURE_3  -- pdue change
   FROM	(SELECT	dates.start_date						START_DATE,
		sum(decode(fact.time_snapshot_date_id, dates.curr_day,
			   fact.pdue_amt_'||l_curr_suffix||', NULL))		CURR_PDUE_VALUE,
		sum(decode(fact.time_snapshot_date_id, dates.prev_day,
			   fact.pdue_amt_'||l_curr_suffix||', NULL))		PREV_PDUE_VALUE
	   FROM	(SELECT	curr.start_date	START_DATE,
			curr.day	CURR_DAY,
			prev.day	PREV_DAY
		   FROM	(SELECT start_date,
				day,
				rownum	ID
			   FROM
			(SELECT	fii.start_date					START_DATE,
				max(fact.time_snapshot_date_id)			DAY
			   FROM	'||l_period_type||'		fii,
				'||l_mv||'		fact
			  WHERE	fii.start_date BETWEEN &BIS_CURRENT_REPORT_START_DATE
						   AND &BIS_CURRENT_ASOF_DATE
			    AND	fact.time_snapshot_date_id (+) >= fii.start_date
			    AND	fact.time_snapshot_date_id (+) <= fii.end_date
			    AND	fact.time_snapshot_date_id (+) <= &BIS_CURRENT_ASOF_DATE
			GROUP BY fii.start_date)
			ORDER BY start_date DESC)		curr,
			(SELECT start_date,
				day,
				rownum	ID
			   FROM
			(SELECT	fii.start_date					START_DATE,
				max(fact.time_snapshot_date_id)			DAY
			   FROM	'||l_period_type||'		fii,
				'||l_mv||'		fact
			  WHERE	fii.start_date BETWEEN &BIS_PREVIOUS_REPORT_START_DATE
						   AND &BIS_PREVIOUS_ASOF_DATE
			    AND	fact.time_snapshot_date_id (+) >= fii.start_date
			    AND	fact.time_snapshot_date_id (+) <= fii.end_date
			    AND	fact.time_snapshot_date_id (+) <= &BIS_PREVIOUS_ASOF_DATE
			GROUP BY fii.start_date)
			ORDER BY start_date DESC)		prev
		  WHERE	curr.id = prev.id(+))			dates,
		'||l_mv||' 				fact'||l_prod_cat_from||'
	  WHERE	fact.time_snapshot_date_id IN (dates.curr_day, dates.prev_day)
	    AND ((fact.late_promise_flag = 1'
		||l_flags_where
		||l_inv_org_where
		||l_prod_cat_where
		||l_prod_where
		||l_cust_where
		||') OR fact.inv_org_id IS NULL)
	GROUP BY dates.start_date)	s,
	'||l_period_type||'		fii
  WHERE	fii.start_date BETWEEN &BIS_CURRENT_REPORT_START_DATE
			   AND &BIS_CURRENT_ASOF_DATE
    AND	fii.start_date = s.start_date(+)
ORDER BY fii.start_date';