APPS.ISC_DBI_PLAN_DETAILS_PKG SQL Statements

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

Line: 27

SELECT	0	ISC_ATTRIBUTE_1,
	0	ISC_ATTRIBUTE_2,
	0	ISC_ATTRIBUTE_3,
	0	ISC_ATTRIBUTE_4,
	0 	ISC_ATTRIBUTE_5,
	0	ISC_ATTRIBUTE_6,
	0 	ISC_MEASURE_1,
	0	ISC_MEASURE_2
  FROM	dual
 WHERE	1 = 2 /* PLAN_SNAPSHOT dimension has not been populated */';

Line: 40

SELECT	f.compile_designator		ISC_ATTRIBUTE_1, -- Plan name
	f.description			ISC_ATTRIBUTE_2, -- Plan Description
	to_char(f.data_start_date)
	   ||'' - ''
	   || to_char(f.cutoff_date)	ISC_ATTRIBUTE_3, -- Plan Horizon
	lkup.meaning			ISC_ATTRIBUTE_4, -- Plan Type
	f.data_start_date		ISC_ATTRIBUTE_5, -- Run Date
	f.snapshot_date			ISC_ATTRIBUTE_6, -- Snapshot Date
	f.org_cnt			ISC_MEASURE_1, -- Planned Organizations
	f.snapshot_id			ISC_MEASURE_2 -- Snapshot ID
  FROM	ISC_DBI_PLAN_SNAPSHOTS	f,
	MFG_LOOKUPS		lkup
 WHERE 	lkup.lookup_type = ''MSC_PLAN_TYPE_LONG''
   AND	lkup.lookup_code = f.curr_plan_type
   AND	enabled_flag = ''Y''
   AND	f.snapshot_id IN (&PLAN_SNAPSHOT+PLAN_SNAPSHOT)
&ORDER_BY_CLAUSE NULLS LAST';