[Home] [Help]
164: and D1.dimension_varchar_label = 'CALENDAR'
165: and A1.attribute_varchar_label in ('DEFAULT_CAL_PERIOD'
166: )));
167:
168: delete from fem_dim_attr_versions_tl where version_id in
169: (select version_id from fem_dim_attr_Versions_b
170: where attribute_id in (select attribute_id
171: from fem_dim_attributes_b A1, fem_dimensions_b D1
172: where A1.dimension_id = D1.dimension_id
219: and D1.dimension_varchar_label = 'FINANCIAL_ELEMENT'
220: and A1.attribute_varchar_label in ('FE_DATA_GROUPING_CODE'
221: ,'DIVISIBLE_FLAG')));
222:
223: delete from fem_dim_attr_versions_tl where version_id in
224: (select version_id from fem_dim_attr_Versions_b
225: where attribute_id in (select attribute_id
226: from fem_dim_attributes_b A1, fem_dimensions_b D1
227: where A1.dimension_id = D1.dimension_id
288: ,'OFFSET_CCTR_ORG'
289: )));
290:
291:
292: delete from fem_dim_attr_versions_tl where version_id in
293: (select version_id from fem_dim_attr_Versions_b
294: where attribute_id in (select attribute_id
295: from fem_dim_attributes_b A1, fem_dimensions_b D1
296: where A1.dimension_id = D1.dimension_id
380: and D1.dimension_varchar_label = 'PRODUCT'
381: and A1.attribute_varchar_label in ('HIDDEN_FLAG')));
382:
383:
384: delete from fem_dim_attr_versions_tl where version_id in
385: (select version_id from fem_dim_attr_Versions_b
386: where attribute_id in (select attribute_id
387: from fem_dim_attributes_b A1, fem_dimensions_b D1
388: where A1.dimension_id = D1.dimension_id
436: and D1.dimension_varchar_label = 'NATURAL_ACCOUNT'
437: and A1.attribute_varchar_label in ('HIDDEN_FLAG','ACTIVATION_FLAG')));
438:
439:
440: delete from fem_dim_attr_versions_tl where version_id in
441: (select version_id from fem_dim_attr_Versions_b
442: where attribute_id in (select attribute_id
443: from fem_dim_attributes_b A1, fem_dimensions_b D1
444: where A1.dimension_id = D1.dimension_id
490: where A1.dimension_id = D1.dimension_id
491: and D1.dimension_varchar_label = 'LEDGER'
492: and A1.attribute_varchar_label in ('EPB_DEFAULT_LEDGER_FLAG')));
493:
494: delete from fem_dim_attr_versions_tl where version_id in
495: (select version_id from fem_dim_attr_Versions_b
496: where attribute_id in (select attribute_id
497: from fem_dim_attributes_b A1, fem_dimensions_b D1
498: where A1.dimension_id = D1.dimension_id
611:
612: delete from fem_ledgers_attr
613: where attribute_id = attr.attribute_id;
614:
615: delete from fem_dim_attr_versions_tl
616: where version_id in (select version_id
617: from fem_dim_attr_Versions_b
618: where attribute_id = attr.attribute_id);
619:
643:
644: delete from fem_ledgers_attr
645: where attribute_id = attr.attribute_id;
646:
647: delete from fem_dim_attr_versions_tl
648: where version_id in (select version_id
649: from fem_dim_attr_Versions_b
650: where attribute_id = attr.attribute_id);
651:
675:
676: delete from fem_ledgers_attr
677: where attribute_id = attr.attribute_id;
678:
679: delete from fem_dim_attr_versions_tl
680: where version_id in (select version_id
681: from fem_dim_attr_Versions_b
682: where attribute_id = attr.attribute_id);
683:
707:
708: delete from fem_ledgers_attr
709: where attribute_id = attr.attribute_id;
710:
711: delete from fem_dim_attr_versions_tl
712: where version_id in (select version_id
713: from fem_dim_attr_Versions_b
714: where attribute_id = attr.attribute_id);
715:
739:
740: delete from fem_ledgers_attr
741: where attribute_id = attr.attribute_id;
742:
743: delete from fem_dim_attr_versions_tl
744: where version_id in (select version_id
745: from fem_dim_attr_Versions_b
746: where attribute_id = attr.attribute_id);
747: