Oracle EBS 自动发运SRS请求

select  wdd.BATCH_ID,wts.BATCH_ID,wdd.SOURCE_LINE_ID
  from wsh_delivery_details     wdd,
       wsh_delivery_assignments wda,
       wsh_trip_stops           wts,
       wsh_delivery_legs        wdl
 where wdd.source_header_id = 75508
   and wdd.delivery_detail_id = wda.delivery_detail_id
   AND wdd.source_code = 'OE'
   AND wdl.delivery_id = wda.delivery_id
   AND nvl(wts.shipments_type_flag, 'O') IN ('O', 'M')
   AND wts.stop_id = wdl.drop_off_stop_id; -- 2018/4/7 15:36:39
连接行程停靠站
-- 1173677
951844  2018-04-07 18:32:09   2018-04-07 18:42:22  XIAONAN.GAO
CUX_CENTER_GETITEM_V3
select * from wsh_trip_stops a where a.REQUEST_ID = 954011;
WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp
select * from oe_order_headers_all h where h.order_number =  100045048; -- 75508
WSH_BATCH_PROCESS.CONFIRM_DELIVERY_SRS;

select * from oe_order_lines_all l where l.header_id = 75508

select *
  from wsh_new_deliveries a where a.SOURCE_HEADER_ID = 75508;

select * from WSH_PICKING_BATCHES a where a.order_header_id = 75508; -- 2018/4/7 14:17:12

select mmt.TRX_SOURCE_LINE_ID, mmt.*
  from mtl_material_transactions mmt
 where mmt.TRX_SOURCE_LINE_ID in
       (602089, 602095, 602096, 602098, 602100, 602099)
 order by mmt.TRX_SOURCE_LINE_ID;

select *
  from wsh_trip_stops a
 where trunc(a.CREATION_DATE) = to_date('2018-04-08', 'yyyy-mm-dd')
   and trunc(a.actual_departure_date) = to_date('2018-03-31', 'yyyy-mm-dd')