SELECT dha.source_order_number,
dha.order_number,
dfla.status_code,
dfla.source_line_number
FROM fusion.doo_headers_all dha,
fusion.doo_fulfill_lines_all dfla,
fusion.wsh_delivery_assignments wda,
fusion.wsh_new_deliveries wnd,
fusion.wsh_delivery_details wdd,
fusion.inv_material_txns imt
WHERE dha.header_id=dfla.header_id
AND dfla.fulfill_line_id=wdd.source_shipment_id
AND wdd.delivery_detail_id=wda.delivery_detail_id
AND wda.delivery_id=wnd.delivery_id(+)
AND dha.submitted_flag=’Y’
ORDER BY dha.source_order_number,imt.transaction_id
Recent Posts
