[Home] [Help]
88: delete from fii_dim_norm_hierarchy
89: where child_flex_value_set_id <> parent_flex_value_set_id
90: and parent_flex_value_set_id not in
91: ( select master_value_set_id
92: from fii_financial_dimensions_v );
93: */
94: DELETE /*+ index_ffs(fii_dim_norm_hierarchy) */
95: FROM fii_dim_norm_hierarchy
96: WHERE child_flex_value_set_id <> parent_flex_value_set_id
235: null application_column_name2,
236: null flex_value_set_id2,
237: null application_column_name3,
238: null flex_value_set_id3
239: from fii_financial_dimensions_v ffd,
240: fii_dim_mapping_rules fdmr
241: where ffd.dimension_short_name = fdmr.dimension_short_name(+)
242: and fdmr.chart_of_accounts_id(+) = p_chart_of_accounts_id;
243: