APPS.GL_ACCOUNTS_MAP_GRP dependencies on GL_CONS_FLEXFIELD_MAP

Line 174: FROM gl_cons_flexfield_map

170:
171: -- Get the number of account rules
172: SELECT COUNT(*)
173: INTO g_num_account_rules
174: FROM gl_cons_flexfield_map
175: WHERE coa_mapping_id = mapping_id;
176:
177: -- Get the number of segments taken care of in all the segment rules
178: SELECT COUNT(DISTINCT to_application_column_name)

Line 907: -- FROM gl_cons_flexfield_map f,

903: -- (SELECT from_cc.summary_flag, to_cc.code_combination_id,
904: -- to_cc.SEGMENT1, to_cc.SEGMENT2, to_cc.SEGMENT3, to_cc.SEGMENT4,
905: -- to_cc.SEGMENT5, to_cc.SEGMENT6, to_cc.SEGMENT7, to_cc.SEGMENT8,
906: -- to_cc.SEGMENT9, to_cc.SEGMENT10
907: -- FROM gl_cons_flexfield_map f,
908: -- gl_code_combinations from_cc,
909: -- gl_code_combinations to_cc
910: -- WHERE map.from_ccid = from_cc.code_combination_id
911: -- and f.coa_mapping_id = v_mapping_id

Line 923: -- FROM gl_cons_flexfield_map cons_flex, gl_code_combinations cc1

919: -- and from_cc.template_id IS NULL
920: -- and to_cc.chart_of_accounts_id = v_to_coa_id)
921: -- WHERE map.coa_mapping_id = v_mapping_id
922: -- AND EXISTS (SELECT 'X'
923: -- FROM gl_cons_flexfield_map cons_flex, gl_code_combinations cc1
924: -- WHERE cc1.SEGMENT1 between cons_flex.SEGMENT1_low and cons_flex.SEGMENT1_high
925: -- AND cc1.SEGMENT2 between cons_flex.SEGMENT2_low and cons_flex.SEGMENT2_high
926: -- AND cc1.SEGMENT3 between cons_flex.SEGMENT3_low and cons_flex.SEGMENT3_high
927: -- AND cc1.SEGMENT4 between cons_flex.SEGMENT4_low and cons_flex.SEGMENT4_high

Line 1009: 'FROM gl_cons_flexfield_map cons_flex, ' ||

1005: 'AND f.coa_mapping_id = ' || TO_CHAR(mapping_id);
1006:
1007: where_2 := 'WHERE map.coa_mapping_id = ' || TO_CHAR(mapping_id) ||
1008: ' AND EXISTS (SELECT ''X'' ' ||
1009: 'FROM gl_cons_flexfield_map cons_flex, ' ||
1010: 'gl_code_combinations cc1 WHERE ';
1011:
1012: -- Loop through each of the target segments to populate the update and
1013: -- select clauses

Line 1034: select_1 := select_1 || ' FROM gl_cons_flexfield_map f, ' ||

1030:
1031:
1032: update_1 := update_1 || ') = ';
1033:
1034: select_1 := select_1 || ' FROM gl_cons_flexfield_map f, ' ||
1035: 'gl_code_combinations from_cc, ' ||
1036: 'gl_code_combinations to_cc ';
1037:
1038: where_1 := where_1 || ' AND f.to_code_combination_id = ' ||