eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FEM_REFRESH_UTIL_PKG dependencies on FEM_DIM_ATTR_VERSIONS_B

Line 160: (select version_id from fem_dim_attr_Versions_b

156: Calendar
157: ***************************/
158: delete from fem_calendars_attr
159: where version_id in
160: (select version_id from fem_dim_attr_Versions_b
161: where attribute_id in (select attribute_id
162: from fem_dim_attributes_b A1, fem_dimensions_b D1
163: where A1.dimension_id = D1.dimension_id
164: and D1.dimension_varchar_label = 'CALENDAR'

Line 169: (select version_id from fem_dim_attr_Versions_b

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
173: and D1.dimension_varchar_label = 'CALENDAR'

Line 177: delete from fem_dim_attr_versions_b

173: and D1.dimension_varchar_label = 'CALENDAR'
174: and A1.attribute_varchar_label in ('DEFAULT_CAL_PERIOD'
175: )));
176:
177: delete from fem_dim_attr_versions_b
178: where attribute_id in (select attribute_id
179: from fem_dim_attributes_b A1, fem_dimensions_b D1
180: where A1.dimension_id = D1.dimension_id
181: and D1.dimension_varchar_label = 'CALENDAR'

Line 215: (select version_id from fem_dim_attr_Versions_b

211: Financial Element
212: ***************************/
213: delete from fem_fin_elems_attr
214: where version_id in
215: (select version_id from fem_dim_attr_Versions_b
216: where attribute_id in (select attribute_id
217: from fem_dim_attributes_b A1, fem_dimensions_b D1
218: where A1.dimension_id = D1.dimension_id
219: and D1.dimension_varchar_label = 'FINANCIAL_ELEMENT'

Line 224: (select version_id from fem_dim_attr_Versions_b

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
228: and D1.dimension_varchar_label = 'FINANCIAL_ELEMENT'

Line 232: delete from fem_dim_attr_versions_b

228: and D1.dimension_varchar_label = 'FINANCIAL_ELEMENT'
229: and A1.attribute_varchar_label in ('FE_DATA_GROUPING_CODE'
230: ,'DIVISIBLE_FLAG')));
231:
232: delete from fem_dim_attr_versions_b
233: where attribute_id in (select attribute_id
234: from fem_dim_attributes_b A1, fem_dimensions_b D1
235: where A1.dimension_id = D1.dimension_id
236: and D1.dimension_varchar_label = 'FINANCIAL_ELEMENT'

Line 278: (select version_id from fem_dim_attr_Versions_b

274: Line Item
275: ***************************/
276: delete from fem_ln_items_attr
277: where version_id in
278: (select version_id from fem_dim_attr_Versions_b
279: where attribute_id in (select attribute_id
280: from fem_dim_attributes_b A1, fem_dimensions_b D1
281: where A1.dimension_id = D1.dimension_id
282: and D1.dimension_varchar_label = 'LINE_ITEM'

Line 293: (select version_id from fem_dim_attr_Versions_b

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
297: and D1.dimension_varchar_label = 'LINE_ITEM'

Line 306: delete from fem_dim_attr_versions_b

302: ,'ACTIVATION_FLAG'
303: ,'OFFSET_CCTR_ORG'
304: )));
305:
306: delete from fem_dim_attr_versions_b
307: where attribute_id in (select attribute_id
308: from fem_dim_attributes_b A1, fem_dimensions_b D1
309: where A1.dimension_id = D1.dimension_id
310: and D1.dimension_varchar_label = 'LINE_ITEM'

Line 376: (select version_id from fem_dim_attr_Versions_b

372: /****************************
373: Product
374: ***************************/
375: delete from fem_products_attr where version_id in
376: (select version_id from fem_dim_attr_Versions_b
377: where attribute_id in (select attribute_id
378: from fem_dim_attributes_b A1, fem_dimensions_b D1
379: where A1.dimension_id = D1.dimension_id
380: and D1.dimension_varchar_label = 'PRODUCT'

Line 385: (select version_id from fem_dim_attr_Versions_b

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
389: and D1.dimension_varchar_label = 'PRODUCT'

Line 392: delete from fem_dim_attr_versions_b

388: where A1.dimension_id = D1.dimension_id
389: and D1.dimension_varchar_label = 'PRODUCT'
390: and A1.attribute_varchar_label in ('HIDDEN_FLAG')));
391:
392: delete from fem_dim_attr_versions_b
393: where attribute_id in (select attribute_id
394: from fem_dim_attributes_b A1, fem_dimensions_b D1
395: where A1.dimension_id = D1.dimension_id
396: and D1.dimension_varchar_label = 'PRODUCT'

Line 432: (select version_id from fem_dim_attr_Versions_b

428: /****************************
429: Natural Account
430: ***************************/
431: delete from fem_nat_accts_attr where version_id in
432: (select version_id from fem_dim_attr_Versions_b
433: where attribute_id in (select attribute_id
434: from fem_dim_attributes_b A1, fem_dimensions_b D1
435: where A1.dimension_id = D1.dimension_id
436: and D1.dimension_varchar_label = 'NATURAL_ACCOUNT'

Line 441: (select version_id from fem_dim_attr_Versions_b

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
445: and D1.dimension_varchar_label = 'NATURAL_ACCOUNT'

Line 448: delete from fem_dim_attr_versions_b

444: where A1.dimension_id = D1.dimension_id
445: and D1.dimension_varchar_label = 'NATURAL_ACCOUNT'
446: and A1.attribute_varchar_label in ('HIDDEN_FLAG','ACTIVATION_FLAG')));
447:
448: delete from fem_dim_attr_versions_b
449: where attribute_id in (select attribute_id
450: from fem_dim_attributes_b A1, fem_dimensions_b D1
451: where A1.dimension_id = D1.dimension_id
452: and D1.dimension_varchar_label = 'NATURAL_ACCOUNT'

Line 487: (select version_id from fem_dim_attr_Versions_b

483: /****************************
484: Ledger
485: ***************************/
486: delete from fem_ledgers_attr where version_id in
487: (select version_id from fem_dim_attr_Versions_b
488: where attribute_id in (select attribute_id
489: from fem_dim_attributes_b A1, fem_dimensions_b D1
490: where A1.dimension_id = D1.dimension_id
491: and D1.dimension_varchar_label = 'LEDGER'

Line 495: (select version_id from fem_dim_attr_Versions_b

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
499: and D1.dimension_varchar_label = 'LEDGER'

Line 502: delete from fem_dim_attr_versions_b

498: where A1.dimension_id = D1.dimension_id
499: and D1.dimension_varchar_label = 'LEDGER'
500: and A1.attribute_varchar_label in ('EPB_DEFAULT_LEDGER_FLAG')));
501:
502: delete from fem_dim_attr_versions_b
503: where attribute_id in (select attribute_id
504: from fem_dim_attributes_b A1, fem_dimensions_b D1
505: where A1.dimension_id = D1.dimension_id
506: and D1.dimension_varchar_label = 'LEDGER'

Line 617: from fem_dim_attr_Versions_b

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:
620: delete from fem_dim_attr_versions_b
621: where attribute_id = attr.attribute_id;

Line 620: delete from fem_dim_attr_versions_b

616: where version_id in (select version_id
617: from fem_dim_attr_Versions_b
618: where attribute_id = attr.attribute_id);
619:
620: delete from fem_dim_attr_versions_b
621: where attribute_id = attr.attribute_id;
622:
623: delete from fem_dim_attributes_tl
624: where attribute_id = attr.attribute_id;

Line 649: from fem_dim_attr_Versions_b

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:
652: delete from fem_dim_attr_versions_b
653: where attribute_id = attr.attribute_id;

Line 652: delete from fem_dim_attr_versions_b

648: where version_id in (select version_id
649: from fem_dim_attr_Versions_b
650: where attribute_id = attr.attribute_id);
651:
652: delete from fem_dim_attr_versions_b
653: where attribute_id = attr.attribute_id;
654:
655: delete from fem_dim_attributes_tl
656: where attribute_id = attr.attribute_id;

Line 681: from fem_dim_attr_Versions_b

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:
684: delete from fem_dim_attr_versions_b
685: where attribute_id = attr.attribute_id;

Line 684: delete from fem_dim_attr_versions_b

680: where version_id in (select version_id
681: from fem_dim_attr_Versions_b
682: where attribute_id = attr.attribute_id);
683:
684: delete from fem_dim_attr_versions_b
685: where attribute_id = attr.attribute_id;
686:
687: delete from fem_dim_attributes_tl
688: where attribute_id = attr.attribute_id;

Line 713: from fem_dim_attr_Versions_b

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:
716: delete from fem_dim_attr_versions_b
717: where attribute_id = attr.attribute_id;

Line 716: delete from fem_dim_attr_versions_b

712: where version_id in (select version_id
713: from fem_dim_attr_Versions_b
714: where attribute_id = attr.attribute_id);
715:
716: delete from fem_dim_attr_versions_b
717: where attribute_id = attr.attribute_id;
718:
719: delete from fem_dim_attributes_tl
720: where attribute_id = attr.attribute_id;

Line 745: from fem_dim_attr_Versions_b

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:
748: delete from fem_dim_attr_versions_b
749: where attribute_id = attr.attribute_id;

Line 748: delete from fem_dim_attr_versions_b

744: where version_id in (select version_id
745: from fem_dim_attr_Versions_b
746: where attribute_id = attr.attribute_id);
747:
748: delete from fem_dim_attr_versions_b
749: where attribute_id = attr.attribute_id;
750:
751: delete from fem_dim_attributes_tl
752: where attribute_id = attr.attribute_id;