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
;
--------------------------------------------------------------------------------------------------------
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
;
--------------------------------------------------------------------------------------------------------
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