Monday, 16 May 2016

Query to find delivery details along with Ship method in Oracle Apps

It will find the list of all delivery details for specified SO orders if any


  SELECT wdd.source_header_type_name ORDER_TYPE,
         wdd.source_header_number ORDER_NUMBER,
         wdd.source_line_number ORDER_LINE_NUMBER,
         wdd.CUST_PO_NUMBER, 
         wnd.delivery_id,
         wnd.ship_method_code,
         wnd.waybill,
         wdd.ORG_ID OPERATING_UNIT_ID,
         wdd.SUBINVENTORY,
         wdd.SHIPPED_QUANTITY
    FROM APPS.wsh_new_deliveries wnd,
         APPS.wsh_delivery_assignments wda,
         APPS.wsh_delivery_details wdd
   WHERE     wnd.delivery_id = wda.delivery_id
         AND wda.delivery_detail_id = wdd.delivery_detail_id
         AND wdd.ORG_ID IN (27, 121, 36, 201) -- US OU, US DEVICES OU, Germany OU, EUR DEVICES OU
         AND wnd.confirm_date > '31-AUG-2007'
         AND wdd.source_header_number = :P_Order_Number
ORDER BY wdd.SOURCE_HEADER_NUMBER, wdd.SOURCE_LINE_NUMBER
;
--------------------------------------------------------------------------------------------------------

1 comment:

  1. I would highly recommend Mr, Benjamin services to any person in need financial help and they will keep you on top of high directories for any further needs. Once again I commend yourself and your staff for extraordinary service and customer service, as this is a great asset to your company and a pleasant experience to customers such as myself. Wishing you all the best for the future.Mr, Benjamin is best way to get an easy loan,here is there email..  247officedept@gmail.com     Or talk to Mr Benjamin On WhatsApp Via_+1-989-394-3740 Thank You for helping me with loan once again in my sincerely heart I'm forever grateful.

    ReplyDelete