APPS.EDW_FLEX_MAPPING SQL Statements

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

Line: 28

	select loc.edw_set_of_books_id into l_edw_sob
	from edw_local_set_of_books loc,
	edw_local_instance inst
	where P_set_of_books_id = loc.set_of_books_id
	AND loc.instance = inst.instance_code;

Line: 40

	select EQUI_SET_OF_BOOKS_ID into l_parent_equi_sob
	from edw_local_equi_set_of_books
	where l_edw_sob = EDW_SET_OF_BOOKS_ID;

Line: 44

	select set_of_books_id, instance into l_parent_sob, l_instance
	from edw_local_set_of_books loc
	where edw_set_of_books_id = l_parent_equi_sob;

Line: 65

	SELECT
		map.application_column_name,
		map.value_set_id,
		map.instance_code
	INTO
		l_application_column_name,
		l_value_set_id,
		l_instance_code
	FROM
		edw_local_instance inst,
		edw_local_flex_seg_mappings_v map,
		edw_local_fact_flex_fk_maps_v fact
	WHERE
		fact.fact_short_name 		= p_fact_name
	--	AND fact.fk_physical_name 	= p_fk_name
		AND map.dimension_short_name 	= fact.dimension_short_name
		AND fact.dimension_short_name   = p_dim_name
		AND map.instance_code		= inst.instance_code
		AND map.structure_num		= p_structure_id
		AND upper(fact.enabled_flag)	= 'Y';

Line: 95

			SELECT 	segment1
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 102

			SELECT 	segment2
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 109

			SELECT 	segment3
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 116

			SELECT 	segment4
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 123

			SELECT 	segment5
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 130

			SELECT 	segment6
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 137

			SELECT 	segment7
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 144

			SELECT 	segment8
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 151

			SELECT 	segment9
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 158

			SELECT 	segment10
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 165

			SELECT 	segment11
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 172

			SELECT 	segment12
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 179

			SELECT 	segment13
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 186

			SELECT 	segment14
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 193

			SELECT 	segment15
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 200

			SELECT 	segment16
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 207

			SELECT 	segment17
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 214

			SELECT 	segment18
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 221

			SELECT 	segment19
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 228

			SELECT 	segment20
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 234

			SELECT 	segment21
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 240

			SELECT 	segment22
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 246

			SELECT 	segment23
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 252

			SELECT 	segment24
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 258

			SELECT 	segment25
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 264

			SELECT 	segment26
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 270

			SELECT 	segment27
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 276

			SELECT 	segment28
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 282

			SELECT 	segment29
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;

Line: 288

			SELECT 	segment30
			INTO   	l_segment_value
			FROM 	gl_code_combinations
			WHERE	code_combination_id	= p_ccid
			AND	chart_of_accounts_id	= p_structure_id;