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_ATTRIBUTES_B

Line 46: select attribute_id from fem_dim_attributes_b

42: v_finelem_dim_id number;
43: v_lnitem_dim_id number;
44:
45: cursor c_ldgattr (p_dimid IN NUMBER) is
46: select attribute_id from fem_dim_attributes_b
47: where dimension_id = p_dimid
48: and attribute_varchar_label in ('LEDGER_CHANNEL_IS_POP_FLAG'
49: ,'LEDGER_CUSTOMER_IS_POP_FLAG'
50: ,'LEDGER_ENTITY_IS_POP_FLAG'

Line 71: select attribute_id from fem_dim_attributes_b

67: ,'LEDGER_USER_DIM9_IS_POP_FLAG'
68: ,'LEDGER_CCTR_IS_POP_FLAG' );
69:
70: cursor c_natattr (p_dimid IN NUMBER) is
71: select attribute_id from fem_dim_attributes_b
72: where dimension_id = p_dimid
73: and attribute_varchar_label in ('FINANCIAL_CATEGORY_FLAG');
74:
75: cursor c_cctrattr (p_dimid IN NUMBER) is

Line 76: select attribute_id from fem_dim_attributes_b

72: where dimension_id = p_dimid
73: and attribute_varchar_label in ('FINANCIAL_CATEGORY_FLAG');
74:
75: cursor c_cctrattr (p_dimid IN NUMBER) is
76: select attribute_id from fem_dim_attributes_b
77: where dimension_id = p_dimid
78: and attribute_varchar_label in ('HIDDEN_FLAG');
79:
80: cursor c_feattr (p_dimid IN NUMBER) is

Line 81: select attribute_id from fem_dim_attributes_b

77: where dimension_id = p_dimid
78: and attribute_varchar_label in ('HIDDEN_FLAG');
79:
80: cursor c_feattr (p_dimid IN NUMBER) is
81: select attribute_id from fem_dim_attributes_b
82: where dimension_id = p_dimid
83: and attribute_varchar_label in ('CONSOLIDATION_FLAG');
84:
85: cursor c_lnattr (p_dimid IN NUMBER) is

Line 86: select attribute_id from fem_dim_attributes_b

82: where dimension_id = p_dimid
83: and attribute_varchar_label in ('CONSOLIDATION_FLAG');
84:
85: cursor c_lnattr (p_dimid IN NUMBER) is
86: select attribute_id from fem_dim_attributes_b
87: where dimension_id = p_dimid
88: and attribute_varchar_label in ('HIDDEN_FLAG','BUDGET_ALLOWED_FLAG');
89: ------------------------------------------------------------------
90:

Line 162: from fem_dim_attributes_b A1, fem_dimensions_b D1

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'
165: and A1.attribute_varchar_label in ('DEFAULT_CAL_PERIOD'
166: )));

Line 171: from fem_dim_attributes_b A1, fem_dimensions_b D1

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'
174: and A1.attribute_varchar_label in ('DEFAULT_CAL_PERIOD'
175: )));

Line 179: from fem_dim_attributes_b A1, fem_dimensions_b D1

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'
182: and A1.attribute_varchar_label in ('DEFAULT_CAL_PERIOD'
183: ));

Line 187: from fem_dim_attributes_b A1, fem_dimensions_b D1

183: ));
184:
185: delete from fem_dim_attributes_tl
186: where attribute_id in (select attribute_id
187: from fem_dim_attributes_b A1, fem_dimensions_b D1
188: where A1.dimension_id = D1.dimension_id
189: and D1.dimension_varchar_label = 'CALENDAR'
190: and A1.attribute_varchar_label in ('DEFAULT_CAL_PERIOD'
191: ));

Line 195: from fem_dim_attributes_b A1, fem_dimensions_b D1

191: ));
192:
193: delete from fem_dim_attributes_priv
194: where attribute_id in (select attribute_id
195: from fem_dim_attributes_b A1, fem_dimensions_b D1
196: where A1.dimension_id = D1.dimension_id
197: and D1.dimension_varchar_label = 'CALENDAR'
198: and A1.attribute_varchar_label in ('DEFAULT_CAL_PERIOD'
199: ));

Line 201: delete from fem_dim_attributes_b

197: and D1.dimension_varchar_label = 'CALENDAR'
198: and A1.attribute_varchar_label in ('DEFAULT_CAL_PERIOD'
199: ));
200:
201: delete from fem_dim_attributes_b
202: where attribute_id in (select attribute_id
203: from fem_dim_attributes_b A1, fem_dimensions_b D1
204: where A1.dimension_id = D1.dimension_id
205: and D1.dimension_varchar_label = 'CALENDAR'

Line 203: from fem_dim_attributes_b A1, fem_dimensions_b D1

199: ));
200:
201: delete from fem_dim_attributes_b
202: where attribute_id in (select attribute_id
203: from fem_dim_attributes_b A1, fem_dimensions_b D1
204: where A1.dimension_id = D1.dimension_id
205: and D1.dimension_varchar_label = 'CALENDAR'
206: and A1.attribute_varchar_label in ('DEFAULT_CAL_PERIOD'
207: ,'DIVISIBLE_FLAG'));

Line 217: from fem_dim_attributes_b A1, fem_dimensions_b D1

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'
220: and A1.attribute_varchar_label in ('FE_DATA_GROUPING_CODE'
221: ,'DIVISIBLE_FLAG')));

Line 226: from fem_dim_attributes_b A1, fem_dimensions_b D1

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'
229: and A1.attribute_varchar_label in ('FE_DATA_GROUPING_CODE'
230: ,'DIVISIBLE_FLAG')));

Line 234: from fem_dim_attributes_b A1, fem_dimensions_b D1

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'
237: and A1.attribute_varchar_label in ('FE_DATA_GROUPING_CODE'
238: ,'DIVISIBLE_FLAG'));

Line 242: from fem_dim_attributes_b A1, fem_dimensions_b D1

238: ,'DIVISIBLE_FLAG'));
239:
240: delete from fem_dim_attributes_tl
241: where attribute_id in (select attribute_id
242: from fem_dim_attributes_b A1, fem_dimensions_b D1
243: where A1.dimension_id = D1.dimension_id
244: and D1.dimension_varchar_label = 'FINANCIAL_ELEMENT'
245: and A1.attribute_varchar_label in ('FE_DATA_GROUPING_CODE'
246: ,'DIVISIBLE_FLAG'));

Line 250: from fem_dim_attributes_b A1, fem_dimensions_b D1

246: ,'DIVISIBLE_FLAG'));
247:
248: delete from fem_dim_attributes_priv
249: where attribute_id in (select attribute_id
250: from fem_dim_attributes_b A1, fem_dimensions_b D1
251: where A1.dimension_id = D1.dimension_id
252: and D1.dimension_varchar_label = 'FINANCIAL_ELEMENT'
253: and A1.attribute_varchar_label in ('FE_DATA_GROUPING_CODE'
254: ,'DIVISIBLE_FLAG'));

Line 258: from fem_dim_attributes_b A1, fem_dimensions_b D1

254: ,'DIVISIBLE_FLAG'));
255:
256: delete from fem_dim_attr_grps
257: where attribute_id in (select attribute_id
258: from fem_dim_attributes_b A1, fem_dimensions_b D1
259: where A1.dimension_id = D1.dimension_id
260: and D1.dimension_varchar_label = 'FINANCIAL_ELEMENT'
261: and A1.attribute_varchar_label in ('FE_DATA_GROUPING_CODE'
262: ,'DIVISIBLE_FLAG'));

Line 264: delete from fem_dim_attributes_b

260: and D1.dimension_varchar_label = 'FINANCIAL_ELEMENT'
261: and A1.attribute_varchar_label in ('FE_DATA_GROUPING_CODE'
262: ,'DIVISIBLE_FLAG'));
263:
264: delete from fem_dim_attributes_b
265: where attribute_id in (select attribute_id
266: from fem_dim_attributes_b A1, fem_dimensions_b D1
267: where A1.dimension_id = D1.dimension_id
268: and D1.dimension_varchar_label = 'FINANCIAL_ELEMENT'

Line 266: from fem_dim_attributes_b A1, fem_dimensions_b D1

262: ,'DIVISIBLE_FLAG'));
263:
264: delete from fem_dim_attributes_b
265: where attribute_id in (select attribute_id
266: from fem_dim_attributes_b A1, fem_dimensions_b D1
267: where A1.dimension_id = D1.dimension_id
268: and D1.dimension_varchar_label = 'FINANCIAL_ELEMENT'
269: and A1.attribute_varchar_label in ('FE_DATA_GROUPING_CODE'
270: ,'DIVISIBLE_FLAG'));

Line 280: from fem_dim_attributes_b A1, fem_dimensions_b D1

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'
283: and A1.attribute_varchar_label in ('BAL_SHEET_MODEL_CODE'
284: ,'TP_METHOD_CODE'

Line 295: from fem_dim_attributes_b A1, fem_dimensions_b D1

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'
298: and A1.attribute_varchar_label in ('BAL_SHEET_MODEL_CODE'
299: ,'TP_METHOD_CODE'

Line 308: from fem_dim_attributes_b A1, fem_dimensions_b D1

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'
311: and A1.attribute_varchar_label in ('BAL_SHEET_MODEL_CODE'
312: ,'TP_METHOD_CODE'

Line 321: from fem_dim_attributes_b A1, fem_dimensions_b D1

317: ));
318:
319: delete from fem_dim_attributes_tl
320: where attribute_id in (select attribute_id
321: from fem_dim_attributes_b A1, fem_dimensions_b D1
322: where A1.dimension_id = D1.dimension_id
323: and D1.dimension_varchar_label = 'LINE_ITEM'
324: and A1.attribute_varchar_label in ('BAL_SHEET_MODEL_CODE'
325: ,'TP_METHOD_CODE'

Line 334: from fem_dim_attributes_b A1, fem_dimensions_b D1

330: ));
331:
332: delete from fem_dim_attributes_priv
333: where attribute_id in (select attribute_id
334: from fem_dim_attributes_b A1, fem_dimensions_b D1
335: where A1.dimension_id = D1.dimension_id
336: and D1.dimension_varchar_label = 'LINE_ITEM'
337: and A1.attribute_varchar_label in ('BAL_SHEET_MODEL_CODE'
338: ,'TP_METHOD_CODE'

Line 347: from fem_dim_attributes_b A1, fem_dimensions_b D1

343: ));
344:
345: delete from fem_dim_attr_grps
346: where attribute_id in (select attribute_id
347: from fem_dim_attributes_b A1, fem_dimensions_b D1
348: where A1.dimension_id = D1.dimension_id
349: and D1.dimension_varchar_label = 'LINE_ITEM'
350: and A1.attribute_varchar_label in ('BAL_SHEET_MODEL_CODE'
351: ,'TP_METHOD_CODE'

Line 358: delete from fem_dim_attributes_b

354: ,'ACTIVATION_FLAG'
355: ,'OFFSET_CCTR_ORG'
356: ));
357:
358: delete from fem_dim_attributes_b
359: where attribute_id in (select attribute_id
360: from fem_dim_attributes_b A1, fem_dimensions_b D1
361: where A1.dimension_id = D1.dimension_id
362: and D1.dimension_varchar_label = 'LINE_ITEM'

Line 360: from fem_dim_attributes_b A1, fem_dimensions_b D1

356: ));
357:
358: delete from fem_dim_attributes_b
359: where attribute_id in (select attribute_id
360: from fem_dim_attributes_b A1, fem_dimensions_b D1
361: where A1.dimension_id = D1.dimension_id
362: and D1.dimension_varchar_label = 'LINE_ITEM'
363: and A1.attribute_varchar_label in ('BAL_SHEET_MODEL_CODE'
364: ,'TP_METHOD_CODE'

Line 378: from fem_dim_attributes_b A1, fem_dimensions_b D1

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'
381: and A1.attribute_varchar_label in ('HIDDEN_FLAG')));
382:

Line 387: from fem_dim_attributes_b A1, fem_dimensions_b D1

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'
390: and A1.attribute_varchar_label in ('HIDDEN_FLAG')));
391:

Line 394: from fem_dim_attributes_b A1, fem_dimensions_b D1

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'
397: and A1.attribute_varchar_label in ('HIDDEN_FLAG'));
398:

Line 401: from fem_dim_attributes_b A1, fem_dimensions_b D1

397: and A1.attribute_varchar_label in ('HIDDEN_FLAG'));
398:
399: delete from fem_dim_attributes_tl
400: where attribute_id in (select attribute_id
401: from fem_dim_attributes_b A1, fem_dimensions_b D1
402: where A1.dimension_id = D1.dimension_id
403: and D1.dimension_varchar_label = 'PRODUCT'
404: and A1.attribute_varchar_label in ('HIDDEN_FLAG'));
405:

Line 408: from fem_dim_attributes_b A1, fem_dimensions_b D1

404: and A1.attribute_varchar_label in ('HIDDEN_FLAG'));
405:
406: delete from fem_dim_attributes_priv
407: where attribute_id in (select attribute_id
408: from fem_dim_attributes_b A1, fem_dimensions_b D1
409: where A1.dimension_id = D1.dimension_id
410: and D1.dimension_varchar_label = 'PRODUCT'
411: and A1.attribute_varchar_label in ('HIDDEN_FLAG'));
412:

Line 415: from fem_dim_attributes_b A1, fem_dimensions_b D1

411: and A1.attribute_varchar_label in ('HIDDEN_FLAG'));
412:
413: delete from fem_dim_attr_grps
414: where attribute_id in (select attribute_id
415: from fem_dim_attributes_b A1, fem_dimensions_b D1
416: where A1.dimension_id = D1.dimension_id
417: and D1.dimension_varchar_label = 'PRODUCT'
418: and A1.attribute_varchar_label in ('HIDDEN_FLAG'));
419:

Line 420: delete from fem_dim_attributes_b

416: where A1.dimension_id = D1.dimension_id
417: and D1.dimension_varchar_label = 'PRODUCT'
418: and A1.attribute_varchar_label in ('HIDDEN_FLAG'));
419:
420: delete from fem_dim_attributes_b
421: where attribute_id in (select attribute_id
422: from fem_dim_attributes_b A1, fem_dimensions_b D1
423: where A1.dimension_id = D1.dimension_id
424: and D1.dimension_varchar_label = 'PRODUCT'

Line 422: from fem_dim_attributes_b A1, fem_dimensions_b D1

418: and A1.attribute_varchar_label in ('HIDDEN_FLAG'));
419:
420: delete from fem_dim_attributes_b
421: where attribute_id in (select attribute_id
422: from fem_dim_attributes_b A1, fem_dimensions_b D1
423: where A1.dimension_id = D1.dimension_id
424: and D1.dimension_varchar_label = 'PRODUCT'
425: and A1.attribute_varchar_label in ('HIDDEN_FLAG'));
426:

Line 434: from fem_dim_attributes_b A1, fem_dimensions_b D1

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'
437: and A1.attribute_varchar_label in ('HIDDEN_FLAG','ACTIVATION_FLAG')));
438:

Line 443: from fem_dim_attributes_b A1, fem_dimensions_b D1

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'
446: and A1.attribute_varchar_label in ('HIDDEN_FLAG','ACTIVATION_FLAG')));
447:

Line 450: from fem_dim_attributes_b A1, fem_dimensions_b D1

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'
453: and A1.attribute_varchar_label in ('HIDDEN_FLAG','ACTIVATION_FLAG'));
454:

Line 457: from fem_dim_attributes_b A1, fem_dimensions_b D1

453: and A1.attribute_varchar_label in ('HIDDEN_FLAG','ACTIVATION_FLAG'));
454:
455: delete from fem_dim_attributes_tl
456: where attribute_id in (select attribute_id
457: from fem_dim_attributes_b A1, fem_dimensions_b D1
458: where A1.dimension_id = D1.dimension_id
459: and D1.dimension_varchar_label = 'NATURAL_ACCOUNT'
460: and A1.attribute_varchar_label in ('HIDDEN_FLAG','ACTIVATION_FLAG'));
461:

Line 464: from fem_dim_attributes_b A1, fem_dimensions_b D1

460: and A1.attribute_varchar_label in ('HIDDEN_FLAG','ACTIVATION_FLAG'));
461:
462: delete from fem_dim_attributes_priv
463: where attribute_id in (select attribute_id
464: from fem_dim_attributes_b A1, fem_dimensions_b D1
465: where A1.dimension_id = D1.dimension_id
466: and D1.dimension_varchar_label = 'NATURAL_ACCOUNT'
467: and A1.attribute_varchar_label in ('HIDDEN_FLAG','ACTIVATION_FLAG'));
468:

Line 471: from fem_dim_attributes_b A1, fem_dimensions_b D1

467: and A1.attribute_varchar_label in ('HIDDEN_FLAG','ACTIVATION_FLAG'));
468:
469: delete from fem_dim_attr_grps
470: where attribute_id in (select attribute_id
471: from fem_dim_attributes_b A1, fem_dimensions_b D1
472: where A1.dimension_id = D1.dimension_id
473: and D1.dimension_varchar_label = 'NATURAL_ACCOUNT'
474: and A1.attribute_varchar_label in ('HIDDEN_FLAG','ACTIVATION_FLAG'));
475:

Line 476: delete from fem_dim_attributes_b

472: where A1.dimension_id = D1.dimension_id
473: and D1.dimension_varchar_label = 'NATURAL_ACCOUNT'
474: and A1.attribute_varchar_label in ('HIDDEN_FLAG','ACTIVATION_FLAG'));
475:
476: delete from fem_dim_attributes_b
477: where attribute_id in (select attribute_id
478: from fem_dim_attributes_b A1, fem_dimensions_b D1
479: where A1.dimension_id = D1.dimension_id
480: and D1.dimension_varchar_label = 'NATURAL_ACCOUNT'

Line 478: from fem_dim_attributes_b A1, fem_dimensions_b D1

474: and A1.attribute_varchar_label in ('HIDDEN_FLAG','ACTIVATION_FLAG'));
475:
476: delete from fem_dim_attributes_b
477: where attribute_id in (select attribute_id
478: from fem_dim_attributes_b A1, fem_dimensions_b D1
479: where A1.dimension_id = D1.dimension_id
480: and D1.dimension_varchar_label = 'NATURAL_ACCOUNT'
481: and A1.attribute_varchar_label in ('HIDDEN_FLAG','ACTIVATION_FLAG'));
482:

Line 489: from fem_dim_attributes_b A1, fem_dimensions_b D1

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'
492: and A1.attribute_varchar_label in ('EPB_DEFAULT_LEDGER_FLAG')));
493:

Line 497: from fem_dim_attributes_b A1, fem_dimensions_b D1

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'
500: and A1.attribute_varchar_label in ('EPB_DEFAULT_LEDGER_FLAG')));
501:

Line 504: from fem_dim_attributes_b A1, fem_dimensions_b D1

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'
507: and A1.attribute_varchar_label in ('EPB_DEFAULT_LEDGER_FLAG'));
508:

Line 511: from fem_dim_attributes_b A1, fem_dimensions_b D1

507: and A1.attribute_varchar_label in ('EPB_DEFAULT_LEDGER_FLAG'));
508:
509: delete from fem_dim_attributes_tl
510: where attribute_id in (select attribute_id
511: from fem_dim_attributes_b A1, fem_dimensions_b D1
512: where A1.dimension_id = D1.dimension_id
513: and D1.dimension_varchar_label = 'LEDGER'
514: and A1.attribute_varchar_label in ('EPB_DEFAULT_LEDGER_FLAG'));
515:

Line 518: from fem_dim_attributes_b A1, fem_dimensions_b D1

514: and A1.attribute_varchar_label in ('EPB_DEFAULT_LEDGER_FLAG'));
515:
516: delete from fem_dim_attributes_priv
517: where attribute_id in (select attribute_id
518: from fem_dim_attributes_b A1, fem_dimensions_b D1
519: where A1.dimension_id = D1.dimension_id
520: and D1.dimension_varchar_label = 'LEDGER'
521: and A1.attribute_varchar_label in ('EPB_DEFAULT_LEDGER_FLAG'));
522:

Line 525: from fem_dim_attributes_b A1, fem_dimensions_b D1

521: and A1.attribute_varchar_label in ('EPB_DEFAULT_LEDGER_FLAG'));
522:
523: delete from fem_dim_attr_grps
524: where attribute_id in (select attribute_id
525: from fem_dim_attributes_b A1, fem_dimensions_b D1
526: where A1.dimension_id = D1.dimension_id
527: and D1.dimension_varchar_label = 'LEDGER'
528: and A1.attribute_varchar_label in ('EPB_DEFAULT_LEDGER_FLAG'));
529:

Line 530: delete from fem_dim_attributes_b

526: where A1.dimension_id = D1.dimension_id
527: and D1.dimension_varchar_label = 'LEDGER'
528: and A1.attribute_varchar_label in ('EPB_DEFAULT_LEDGER_FLAG'));
529:
530: delete from fem_dim_attributes_b
531: where attribute_id in (select attribute_id
532: from fem_dim_attributes_b A1, fem_dimensions_b D1
533: where A1.dimension_id = D1.dimension_id
534: and D1.dimension_varchar_label = 'LEDGER'

Line 532: from fem_dim_attributes_b A1, fem_dimensions_b D1

528: and A1.attribute_varchar_label in ('EPB_DEFAULT_LEDGER_FLAG'));
529:
530: delete from fem_dim_attributes_b
531: where attribute_id in (select attribute_id
532: from fem_dim_attributes_b A1, fem_dimensions_b D1
533: where A1.dimension_id = D1.dimension_id
534: and D1.dimension_varchar_label = 'LEDGER'
535: and A1.attribute_varchar_label in ('EPB_DEFAULT_LEDGER_FLAG'));
536:

Line 554: (select attribute_id from fem_dim_attributes_b

550:
551:
552: --fem_obs_seeddata.sql
553: delete from fem_ext_Acct_types_attr where attribute_id in
554: (select attribute_id from fem_dim_attributes_b
555: where attribute_varchar_label in ('DEBIT_SIGN','LOAD_SIGN'));
556:
557: delete from fem_dim_attr_Versions_vl
558: where attribute_id in (select attribute_id from fem_dim_attributes_b

Line 558: where attribute_id in (select attribute_id from fem_dim_attributes_b

554: (select attribute_id from fem_dim_attributes_b
555: where attribute_varchar_label in ('DEBIT_SIGN','LOAD_SIGN'));
556:
557: delete from fem_dim_attr_Versions_vl
558: where attribute_id in (select attribute_id from fem_dim_attributes_b
559: where attribute_Varchar_label in ('DEBIT_SIGN','LOAD_SIGN'));
560:
561: delete from fem_dim_attributes_vl where attribute_varchar_label in ('DEBIT_SIGN','LOAD_SIGN');
562:

Line 564: (select attribute_id from fem_dim_attributes_b

560:
561: delete from fem_dim_attributes_vl where attribute_varchar_label in ('DEBIT_SIGN','LOAD_SIGN');
562:
563: delete from fem_ln_items_attr where attribute_id in
564: (select attribute_id from fem_dim_attributes_b
565: where attribute_Varchar_label = 'STATISTICS_TYPE_FLAG');
566:
567: delete from fem_dim_attr_Versions_vl
568: where attribute_id in

Line 569: (select attribute_id from fem_dim_attributes_b

565: where attribute_Varchar_label = 'STATISTICS_TYPE_FLAG');
566:
567: delete from fem_dim_attr_Versions_vl
568: where attribute_id in
569: (select attribute_id from fem_dim_attributes_b
570: where attribute_Varchar_label = 'STATISTICS_TYPE_FLAG');
571: delete from fem_dim_attributes_vl
572: where attribute_varchar_label = 'STATISTICS_TYPE_FLAG';
573:

Line 626: delete from fem_dim_attributes_b

622:
623: delete from fem_dim_attributes_tl
624: where attribute_id = attr.attribute_id;
625:
626: delete from fem_dim_attributes_b
627: where attribute_id = attr.attribute_id;
628:
629: delete from fem_dim_attr_grps
630: where attribute_id=attr.attribute_id;

Line 658: delete from fem_dim_attributes_b

654:
655: delete from fem_dim_attributes_tl
656: where attribute_id = attr.attribute_id;
657:
658: delete from fem_dim_attributes_b
659: where attribute_id = attr.attribute_id;
660:
661: delete from fem_dim_attr_grps
662: where attribute_id=attr.attribute_id;

Line 690: delete from fem_dim_attributes_b

686:
687: delete from fem_dim_attributes_tl
688: where attribute_id = attr.attribute_id;
689:
690: delete from fem_dim_attributes_b
691: where attribute_id = attr.attribute_id;
692:
693: delete from fem_dim_attr_grps
694: where attribute_id=attr.attribute_id;

Line 722: delete from fem_dim_attributes_b

718:
719: delete from fem_dim_attributes_tl
720: where attribute_id = attr.attribute_id;
721:
722: delete from fem_dim_attributes_b
723: where attribute_id = attr.attribute_id;
724:
725: delete from fem_dim_attr_grps
726: where attribute_id=attr.attribute_id;

Line 754: delete from fem_dim_attributes_b

750:
751: delete from fem_dim_attributes_tl
752: where attribute_id = attr.attribute_id;
753:
754: delete from fem_dim_attributes_b
755: where attribute_id = attr.attribute_id;
756:
757: delete from fem_dim_attr_grps
758: where attribute_id=attr.attribute_id;