Mover order VS Sales Order Query

select mhl.request_number
,l.line_number
,h.order_number
,mrl.line_number
,mrl.line_id
,mrl.from_subinventory_code
,mrl.lot_number
,mrl.serial_number_start
,mrl.serial_number_end
,mrl.uom_code
,mrl.quantity
,mrl.quantity_delivered
,mrl.quantity_detailed
,wdd.source_header_number
,wdd.source_header_id
,wdd.source_line_id
,wdd.shipping_instructions
,wdd.inventory_item_id
,wdd.requested_quantity_uom
,wdd.ship_method_code
,wdd.subinventory
,wdd.shipment_priority_code
,wdd.organization_id
,wdd.released_status
,wdd.source_code
,wnd.delivery_id
,wnd.name
,wnd.initial_pickup_location_id
,wnd.creation_date
,msib.segment1
,msib.description
,msib.revision_qty_control_code
from mtl_txn_request_lines mrl,
mtl_txn_request_headers mhl,
wsh_delivery_details wdd,
wsh_new_deliveries wnd,
wsh_delivery_assignments wda,
oe_ordeR_lines_all l,
oe_order_headers_all h,
mtl_system_items_b msib
where mhl.header_id=mrl.header_id
and mrl.line_id=wdd.move_order_line_id
and wda.delivery_id=wnd.delivery_id(+)
and wdd.delivery_detail_id = wda.delivery_detail_id
and wdd.source_header_id=l.header_id
and wdd.source_line_id=l.line_id
and h.header_id=l.header_id
and wdd.organization_id=msib.organization_id(+)
and wdd.inventory_item_id=msib.inventory_item_id(+)
--and mhl.request_number='57316'
--order by wdd.creation_date desc
--and wnd.delivery_id=113896 

No comments:

Post a Comment

Query to find submitted Concurrent requests

  Query to find Concurrent Requests SELECT      user_concurrent_program_name,      responsibility_name,      request_date,      argument_tex...