DBA Data[Home] [Help]

APPS.MSD_PULL_FACT_DATA dependencies on MSD_ANALYZE_TABLES

Line 148: MSD_ANALYZE_TABLES.analyze_table('MSD_SHIPMENT_DATA',null);

144:
145: commit;
146:
147: /* Added by esubrama */
148: MSD_ANALYZE_TABLES.analyze_table('MSD_SHIPMENT_DATA',null);
149: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_SHIPMENT_DATA',null);
150: exception
151:
152: when others then

Line 149: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_SHIPMENT_DATA',null);

145: commit;
146:
147: /* Added by esubrama */
148: MSD_ANALYZE_TABLES.analyze_table('MSD_SHIPMENT_DATA',null);
149: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_SHIPMENT_DATA',null);
150: exception
151:
152: when others then
153:

Line 224: MSD_ANALYZE_TABLES.analyze_table('MSD_BOOKING_DATA',null);

220:
221: commit;
222:
223: /* Added by esubrama */
224: MSD_ANALYZE_TABLES.analyze_table('MSD_BOOKING_DATA',null);
225: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_BOOKING_DATA',null);
226:
227: EXCEPTION
228:

Line 225: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_BOOKING_DATA',null);

221: commit;
222:
223: /* Added by esubrama */
224: MSD_ANALYZE_TABLES.analyze_table('MSD_BOOKING_DATA',null);
225: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_BOOKING_DATA',null);
226:
227: EXCEPTION
228:
229: when others then

Line 298: MSD_ANALYZE_TABLES.analyze_table('MSD_UOM_CONVERSIONS',null);

294:
295: commit;
296:
297: /* Added by esubrama */
298: MSD_ANALYZE_TABLES.analyze_table('MSD_UOM_CONVERSIONS',null);
299: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_UOM_CONVERSIONS',null);
300: exception
301:
302: when others then

Line 299: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_UOM_CONVERSIONS',null);

295: commit;
296:
297: /* Added by esubrama */
298: MSD_ANALYZE_TABLES.analyze_table('MSD_UOM_CONVERSIONS',null);
299: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_UOM_CONVERSIONS',null);
300: exception
301:
302: when others then
303:

Line 365: MSD_ANALYZE_TABLES.analyze_table('MSD_CURRENCY_CONVERSIONS',null);

361:
362: commit;
363:
364: /* Added by esubrama */
365: MSD_ANALYZE_TABLES.analyze_table('MSD_CURRENCY_CONVERSIONS',null);
366: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_CURRENCY_CONVERSIONS',null);
367:
368: exception
369:

Line 366: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_CURRENCY_CONVERSIONS',null);

362: commit;
363:
364: /* Added by esubrama */
365: MSD_ANALYZE_TABLES.analyze_table('MSD_CURRENCY_CONVERSIONS',null);
366: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_CURRENCY_CONVERSIONS',null);
367:
368: exception
369:
370: when others then

Line 427: MSD_ANALYZE_TABLES.analyze_table('MSD_SALES_OPPORTUNITY_DATA',null);

423:
424: commit;
425:
426: -- Added by esubrama
427: MSD_ANALYZE_TABLES.analyze_table('MSD_SALES_OPPORTUNITY_DATA',null);
428: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_SALES_OPPORTUNITY_DATA',null);
429:
430: exception
431:

Line 428: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_SALES_OPPORTUNITY_DATA',null);

424: commit;
425:
426: -- Added by esubrama
427: MSD_ANALYZE_TABLES.analyze_table('MSD_SALES_OPPORTUNITY_DATA',null);
428: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_SALES_OPPORTUNITY_DATA',null);
429:
430: exception
431:
432: when others then

Line 494: MSD_ANALYZE_TABLES.analyze_table('MSD_SALES_FORECAST',null);

490:
491: End Loop ;
492:
493: -- Added by esubrama
494: MSD_ANALYZE_TABLES.analyze_table('MSD_SALES_FORECAST',null);
495: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_SALES_FORECAST',null);
496:
497: exception
498:

Line 495: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_SALES_FORECAST',null);

491: End Loop ;
492:
493: -- Added by esubrama
494: MSD_ANALYZE_TABLES.analyze_table('MSD_SALES_FORECAST',null);
495: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_SALES_FORECAST',null);
496:
497: exception
498:
499: when others then

Line 641: MSD_ANALYZE_TABLES.analyze_table('MSD_MFG_FORECAST',null);

637:
638: COMMIT;
639:
640: /* Added by esubrama */
641: MSD_ANALYZE_TABLES.analyze_table('MSD_MFG_FORECAST',null);
642: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_MFG_FORECAST',null);
643:
644: EXCEPTION
645: when others then

Line 642: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_MFG_FORECAST',null);

638: COMMIT;
639:
640: /* Added by esubrama */
641: MSD_ANALYZE_TABLES.analyze_table('MSD_MFG_FORECAST',null);
642: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_MFG_FORECAST',null);
643:
644: EXCEPTION
645: when others then
646: errbuf := substr(SQLERRM,1,150);

Line 707: MSD_ANALYZE_TABLES.analyze_table('MSD_PRICE_LIST',null);

703:
704: commit;
705:
706: /* Added by esubrama */
707: MSD_ANALYZE_TABLES.analyze_table('MSD_PRICE_LIST',null);
708: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_PRICE_LIST',null);
709:
710: exception
711: when others then

Line 708: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_PRICE_LIST',null);

704: commit;
705:
706: /* Added by esubrama */
707: MSD_ANALYZE_TABLES.analyze_table('MSD_PRICE_LIST',null);
708: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_PRICE_LIST',null);
709:
710: exception
711: when others then
712: