DBA Data[Home] [Help]

APPS.MSD_PULL_FACT_DATA dependencies on MSD_ST_PRICE_LIST

Line 665: from msd_st_price_list

661: ******************************************************/
662: /* DWK. Fix Bug 2220983. Do not include instance = '0' in the cursor */
663: Cursor Pricing is
664: select distinct instance, price_list_name
665: from msd_st_price_list
666: where nvl(instance, '888') <> '0' and price_list_name is not null;
667:
668:
669: l_new_refresh_num NUMBER;

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: