DBA Data[Home] [Help]

APPS.MSD_PULL_FACT_DATA dependencies on MSD_ST_SHIPMENT_DATA

Line 100: from msd_st_shipment_data

96: Cursor Shipment is
97: select instance,
98: min(shipped_date) min_ship_date,
99: max(shipped_date) max_ship_date
100: from msd_st_shipment_data
101: where instance <> '0'
102: group by instance ;
103:
104: l_new_refresh_num NUMBER;

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: