Safety Stock Pegging

select *


from apps.ecx_doclogs dl

,ecx.ecx_outbound_logs ol

,apps.ecx_oxta_logmsg lm

where trunc(ol.time_stamp) between trunc(sysdate-1) and trunc(sysdate)

and dl.direction = 'OUT'

and lm.sender_message_id = dl.msgid

and ol.document_number in(select distinct wda.delivery_id from wsh_delivery_details wdd,

wsh_delivery_assignments wda

where wdd.organization_id=392

and wdd.subinventory='Stage'

and wdd.released_status='Y'

and trunc(wdd.last_update_date)=trunc(sysdate)

and wdd.delivery_detail_id=wda.delivery_detail_id)-- po_header_id

and ol.out_msgid = dl.msgid

and dl.transaction_subtype = 'OE_PICK_O'

--and lm.exception_text not like 'Response: HTTP/1.1 200 OK%'

order by dl.time_stamp desc