Month End Speed Up - Unprocessed Shipping Transaction Analysis Part 3

Description
Columns: Order Number, Line Number, Ordered Item, Ordered Quantity, Shipped Quantity, Delivery Name, Warehouse, Inventory Interfaced, Ship Date ...
*Unprocessed Shipping Transactions Troubleshooting Techniques (Doc ID 262979.1)*
**Use the following to identify any sales orders that have not been Shipped or Inventory Interfaced***
Verify that there are NO records for this Sales Order in the Pending Transactions Form or the Transaction Open Interface Form. Address the errors if any. The records retrieved in these forms will list the Sales ... 
*Unprocessed Shipping Transactions Troubleshooting Techniques (Doc ID 262979.1)*
**Use the following to identify any sales orders that have not been Shipped or Inventory Interfaced***
Verify that there are NO records for this Sales Order in the Pending Transactions Form or the Transaction Open Interface Form. Address the errors if any. The records retrieved in these forms will list the Sales Order Number under the "Source" or "Transaction Source" columns for the Source TAB respectively.
Navigation> Inventory> Transactions> Pending Transactions
Navigation> Inventory> Transactions> Transaction Open Interface

   more
select 
ooh.order_number, 
ool.line_number, 
ool.ordered_item,
ool.ordered_quantity,
ool.shipped_quantity,
wnd.name "Delivery Name", 
mp.organization_code Warehouse,
decode(wdd.inv_interfaced_flag, 'N','Run I/F from Shipping', 'P', 'Run Inventory I/F') "Inventory Interfaced",
trunc(wts.actual_departure_date) ship_date
from 
wsh_delivery_details wdd, 
wsh_delivery_assignments wda,
wsh_new_deliveries wnd, 
wsh_delivery_legs wdl, 
wsh_trip_stops wts,
oe_order_headers_all ooh, 
oe_order_lines_all ool,
mtl_parameters mp
where 
1=1
and wdd.source_code = 'OE'
and wdd.released_status = 'C' --shipped
and mp.organization_id = wdd.organization_id
and wdd.inv_interfaced_flag in ('N' ,'P')  --not yet I/F or pending I/F
and wdd.organization_id = ool.ship_from_org_id
and wda.delivery_detail_id = wdd.delivery_detail_id
and wnd.delivery_id = wda.delivery_id
and wnd.status_code in ('CL','IT')
and wdl.delivery_id = wnd.delivery_id
--and trunc(wts.actual_departure_date) between 'period_start_date'and 'period_end_date'
and wdl.pick_up_stop_id = wts.stop_id
and wdd.source_header_id = ooh.header_id
and wdd.source_line_id = ool.line_id
order by 8
Parameter Name SQL text Validation
Order Number
order_number=:sales_order
LOV
Warehouse
organization_code=:warehouse
LOV Oracle