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.MSD_PURGE dependencies on MSD_ANALYZE_TABLES

Line 92: MSD_ANALYZE_TABLES.analyze_table(null, 5);

88:
89: close get_cs_data;
90:
91: /* Analyze Custom Stream Tables */
92: MSD_ANALYZE_TABLES.analyze_table(null, 5);
93: /* End Analyze */
94:
95: end delete_cs_data;
96:

Line 441: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.SHIPMENT_FACT_TABLE,null);

437: l_final_str := l_delete_from || l_where;
438: EXECUTE IMMEDIATE l_final_str;
439:
440: /* Analyze Shipment Fact Tables */
441: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.SHIPMENT_FACT_TABLE,null);
442: /* End Analyze Shipment Fact Tables */
443:
444: end if;
445:

Line 457: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.BOOKING_FACT_TABLE,null);

453: l_final_str := l_delete_from || l_where;
454: EXECUTE IMMEDIATE l_final_str;
455:
456: /* Analyze Booking Fact Tables */
457: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.BOOKING_FACT_TABLE,null);
458: /* End Analyze Booking Fact Tables */
459:
460: end if;
461:

Line 489: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE, null);

485:
486: /* End Remove headers */
487:
488: /* Analyze Manufacturing Forecast Fact Tables */
489: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE, null);
490: /* End Analyze Manufacturing Forecast Fact Tables */
491:
492:
493: end if;

Line 619: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.CURRENCY_FACT_TABLE, null);

615: l_final_str := l_delete_from;
616: EXECUTE IMMEDIATE l_final_str;
617:
618: /* Analyze Currency Code Fact Tables */
619: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.CURRENCY_FACT_TABLE, null);
620: /* End Analyze Currency Code Fact Tables */
621:
622: end if;
623:

Line 632: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.UOM_FACT_TABLE, null);

628: l_final_str := l_delete_from || l_where;
629: EXECUTE IMMEDIATE l_final_str;
630:
631: /* Analyze Uom Conversion Fact Tables */
632: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.UOM_FACT_TABLE, null);
633: /* End Analyze Uom Conversion Fact Tables */
634:
635: end if;
636:

Line 664: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.TIME_FACT_TABLE, null);

660:
661: end if;
662:
663: /* Analyze Time Fact Tables */
664: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.TIME_FACT_TABLE, null);
665: /* End Analyze Time Fact Tables */
666:
667: end if;
668:

Line 679: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.PRICING_FACT_TABLE, null);

675: l_final_str := l_delete_from || l_where;
676: EXECUTE IMMEDIATE l_final_str using p_price_list;
677:
678: /* Analyze Pricing Fact Tables */
679: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.PRICING_FACT_TABLE, null);
680: /* End Analyze Pricing Fact Tables */
681:
682: end if;
683:

Line 745: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.SCENARIO_ENTRIES_TABLE, null);

741:
742: END IF;
743:
744: /* Analyze Scenario Entry Fact Tables */
745: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.SCENARIO_ENTRIES_TABLE, null);
746: /* End Analyze Scenario Entry Fact Tables */
747:
748:
749: end if;

Line 800: MSD_ANALYZE_TABLES.analyze_table(null,2);

796:
797: /* End Deleting Stripes Data */
798:
799: /* Analyze Level Value Fact Tables */
800: MSD_ANALYZE_TABLES.analyze_table(null,2);
801: /* End Analyze Level Value Fact Tables */
802:
803: end if;
804: