211: x.sales_channel,
212: x.user_defined1,
213: x.user_defined2,
214: null -- dcs level value
215: FROM msd_shipment_data_v x;
216:
217: lv_stream_id NUMBER;
218:
219: BEGIN
279: AND a.collect_flag='Y'
280: AND b.strict_flag='Y'
281: AND b.valid_flag='Y'
282: AND b.enable_flag='Y'
283: AND EXISTS (select 1 from msd_shipment_data where rownum=1);
284:
285: --MSD_SHIPMENT_ORIG_HISTORY ??
286:
287: