DBA Data[Home] [Help]

APPS.GL_ACCOUNTS_MAP_GRP dependencies on GL_CONS_SEGMENT_MAP

Line 180: FROM gl_cons_segment_map

176:
177: -- Get the number of segments taken care of in all the segment rules
178: SELECT COUNT(DISTINCT to_application_column_name)
179: INTO g_num_segment_rules
180: FROM gl_cons_segment_map
181: WHERE coa_mapping_id = mapping_id;
182:
183: -- This statement is necessary to use the fnd_flex_key_api package's
184: -- subroutines.

Line 262: -- gl_cons_segment_map GL_CSM

258: -- GL_CSM.single_value target_flex_value,
259: -- 'N' summary_flag
260: -- FROM fnd_flex_values GL_FV,
261: -- fnd_flex_value_hierarchies FVH,
262: -- gl_cons_segment_map GL_CSM
263: -- WHERE GL_CSM.coa_mapping_id = v_mapping_id
264: -- AND GL_CSM.to_application_column_name =
265: -- v_to_application_column_name
266: -- AND GL_CSM.parent_rollup_value = FVH.parent_flex_value

Line 281: -- gl_cons_segment_map GL_CSM

277: -- GL_CSM.single_value target_flex_value,
278: -- 'N' summary_flag
279: -- FROM fnd_flex_values GL_FV,
280: -- gl_cons_flex_hierarchies CFH,
281: -- gl_cons_segment_map GL_CSM
282: -- WHERE GL_CSM.coa_mapping_id = v_mapping_id
283: -- AND GL_CSM.to_application_column_name =
284: -- v_to_application_column_name
285: -- AND GL_CSM.segment_map_id = CFH.segment_map_id

Line 298: -- FROM gl_cons_segment_map GL_CSM

294: --
295: -- SELECT GL_CSM.parent_rollup_value source_flex_value,
296: -- GL_CSM.single_value target_flex_value,
297: -- 'Y' summary_flag
298: -- FROM gl_cons_segment_map GL_CSM
299: -- WHERE GL_CSM.coa_mapping_id = v_mapping_id
300: -- AND GL_CSM.to_application_column_name =
301: -- v_to_application_column_name
302: -- AND GL_CSM.segment_map_type = 'V'

Line 311: -- gl_cons_segment_map GL_CSM

307: -- GL_CSM.single_value target_flex_value,
308: -- 'Y' summary_flag
309: -- FROM fnd_flex_values GL_FV,
310: -- gl_cons_flex_hierarchies CFH,
311: -- gl_cons_segment_map GL_CSM
312: -- WHERE GL_CSM.coa_mapping_id = v_mapping_id
313: -- AND GL_CSM.to_application_column_name =
314: -- v_to_application_column_name
315: -- AND GL_CSM.segment_map_id = CFH.segment_map_id

Line 333: -- gl_cons_segment_map GL_CSM

329: -- GL_CSM.single_value target_flex_value,
330: -- 'N' summary_flag
331: -- FROM :val_tab_name GL_FV,
332: -- fnd_flex_value_hierarchies FVH,
333: -- gl_cons_segment_map GL_CSM
334: -- WHERE GL_CSM.coa_mapping_id = v_mapping_id
335: -- AND GL_CSM.to_application_column_name =
336: -- v_to_application_column_name
337: -- AND GL_CSM.parent_rollup_value = FVH.parent_flex_value

Line 351: -- gl_cons_segment_map GL_CSM

347: -- GL_CSM.single_value target_flex_value,
348: -- 'N' summary_flag
349: -- FROM :val_tab_name GL_FV,
350: -- gl_cons_flex_hierarchies CFH,
351: -- gl_cons_segment_map GL_CSM
352: -- WHERE GL_CSM.coa_mapping_id = v_mapping_id
353: -- AND GL_CSM.to_application_column_name =
354: -- v_to_application_column_name
355: -- AND GL_CSM.segment_map_id = CFH.segment_map_id

Line 367: -- FROM gl_cons_segment_map GL_CSM

363: --
364: -- SELECT GL_CSM.parent_rollup_value source_flex_value,
365: -- GL_CSM.single_value target_flex_value,
366: -- 'Y' summary_flag
367: -- FROM gl_cons_segment_map GL_CSM
368: -- WHERE GL_CSM.coa_mapping_id = v_mapping_id
369: -- AND GL_CSM.to_application_column_name =
370: -- v_to_application_column_name
371: -- AND GL_CSM.segment_map_type = 'V'

Line 380: -- gl_cons_segment_map GL_CSM

376: -- GL_CSM.single_value target_flex_value,
377: -- 'Y' summary_flag
378: -- FROM fnd_flex_values GL_FV,
379: -- gl_cons_flex_hierarchies CFH,
380: -- gl_cons_segment_map GL_CSM
381: -- WHERE GL_CSM.coa_mapping_id = v_mapping_id
382: -- AND GL_CSM.to_application_column_name =
383: -- v_to_application_column_name
384: -- AND GL_CSM.segment_map_id = CFH.segment_map_id

Line 458: FROM GL_CONS_SEGMENT_MAP map

454: INTO detail_parent_flag,
455: detail_ranges_flag,
456: summary_ranges_flag,
457: summary_parent_flag
458: FROM GL_CONS_SEGMENT_MAP map
459: WHERE map.coa_mapping_id = mapping_id
460: AND map.to_application_column_name =
461: interim_rollup_map.to_application_column_name;
462:

Line 496: 'fnd_flex_value_hierarchies FVH, gl_cons_segment_map GL_CSM ' ||

492: insert_1 := insert_1 || insert_1_select_type || ' GL_FV.' || insert_1_col ||
493: ' source_flex_value, ' ||
494: 'GL_CSM.single_value target_flex_value, ''N'' summary_flag ' ||
495: 'FROM '|| insert_1_table || ' GL_FV, ' ||
496: 'fnd_flex_value_hierarchies FVH, gl_cons_segment_map GL_CSM ' ||
497: 'WHERE GL_CSM.coa_mapping_id = ' || TO_CHAR(mapping_id) ||
498: ' AND GL_CSM.to_application_column_name = ''' ||
499: to_application_column_name || ''' ' ||
500: 'AND GL_CSM.parent_rollup_value = FVH.parent_flex_value ' ||

Line 516: 'gl_cons_flex_hierarchies CFH, gl_cons_segment_map GL_CSM ' ||

512: insert_1 := insert_1 || insert_1_select_type || ' GL_FV.' || insert_1_col ||
513: ' source_flex_value, ' ||
514: 'GL_CSM.single_value target_flex_value, ''N'' summary_flag ' ||
515: 'FROM ' || insert_1_table || ' GL_FV, ' ||
516: 'gl_cons_flex_hierarchies CFH, gl_cons_segment_map GL_CSM ' ||
517: 'WHERE GL_CSM.coa_mapping_id = ' || TO_CHAR(mapping_id) ||
518: ' AND GL_CSM.to_application_column_name = ''' ||
519: to_application_column_name || ''' ' ||
520: 'AND GL_CSM.segment_map_id = CFH.segment_map_id ' ||

Line 538: 'FROM gl_cons_segment_map GL_CSM ' ||

534: END IF;
535: insert_1 := insert_1 ||
536: 'SELECT GL_CSM.parent_rollup_value source_flex_value, ' ||
537: 'GL_CSM.single_value target_flex_value, ''Y'' summary_flag ' ||
538: 'FROM gl_cons_segment_map GL_CSM ' ||
539: 'WHERE GL_CSM.coa_mapping_id = ' || TO_CHAR(mapping_id) ||
540: ' AND GL_CSM.to_application_column_name = ''' ||
541: to_application_column_name || ''' ' ||
542: 'AND GL_CSM.segment_map_type = ''V''';

Line 555: 'gl_cons_segment_map GL_CSM ' ||

551: END IF;
552: insert_1 := insert_1 || 'SELECT GL_FV.flex_value source_flex_value, ' ||
553: 'GL_CSM.single_value target_flex_value, ''Y'' summary_flag ' ||
554: 'FROM fnd_flex_values GL_FV, gl_cons_flex_hierarchies CFH, ' ||
555: 'gl_cons_segment_map GL_CSM ' ||
556: 'WHERE GL_CSM.coa_mapping_id = ' || TO_CHAR(mapping_id) ||
557: ' AND GL_CSM.to_application_column_name = ''' ||
558: to_application_column_name || ''' ' ||
559: 'AND GL_CSM.segment_map_id = CFH.segment_map_id ' ||

Line 683: FROM gl_cons_segment_map

679: -- this query will return a single row with 'Y' in it if there is segment
680: -- mapping that involves summary accounts
681: CURSOR rule_exist IS
682: SELECT 'Y'
683: FROM gl_cons_segment_map
684: WHERE coa_mapping_id = mapping_id
685: AND segment_map_type IN ('V','U');
686:
687: -- this query returns information concerning the segment rules, including

Line 711: GL_CONS_SEGMENT_MAP map,

707: NULL)
708: SINGLE_VALUE
709:
710: FROM FND_ID_FLEX_SEGMENTS ffs2,
711: GL_CONS_SEGMENT_MAP map,
712: FND_ID_FLEX_SEGMENTS ffs1
713:
714: WHERE ffs1.application_id = g_application_id
715: AND ffs1.id_flex_code = g_id_flex_code

Line 748: FROM GL_CONS_SEGMENT_MAP map

744: AND ffs.enabled_flag = 'Y'
745: AND ffs.id_flex_num = from_coa_id
746: AND ffs.application_column_name NOT IN (
747: SELECT map.from_application_column_name
748: FROM GL_CONS_SEGMENT_MAP map
749: WHERE map.coa_mapping_id = mapping_id
750: AND map.from_application_column_name IS NOT NULL
751: );
752:

Line 1473: FROM gl_cons_segment_map csm

1469: c_to_segment VARCHAR2) IS
1470: SELECT csm.segment_map_type,
1471: csm.from_application_column_name,
1472: csm.single_value
1473: FROM gl_cons_segment_map csm
1474: WHERE csm.coa_mapping_id = c_mapping_id
1475: AND csm.to_application_column_name = c_to_segment;
1476:
1477: BEGIN