DBA Data[Home] [Help]

APPS.WSH_CUSTOM_PUB dependencies on WSH_DELIVERY_DETAILS

Line 179: wsh_delivery_details wdd,

175: lpad(to_char(wnd.initial_pickup_date,'MM/DD/YYYY'),12),
176: wnd.waybill,
177: sum(nvl(wdd.shipped_quantity,0))
178: FROM
179: wsh_delivery_details wdd,
180: wsh_delivery_assignments wda,
181: wsh_new_deliveries wnd,
182: mtl_system_items msi
183: WHERE wdd.delivery_detail_id = wda.delivery_detail_id

Line 279: wsh_delivery_details wdd,

275: msi.segment1,
276: msi.description,
277: sum(nvl(wdd.requested_quantity,0))
278: FROM
279: wsh_delivery_details wdd,
280: wsh_delivery_assignments wda,
281: wsh_new_deliveries wnd,
282: mtl_system_items msi
283: WHERE wdd.delivery_detail_id = wda.delivery_detail_id

Line 2230: FROM wsh_delivery_details wdd

2226: )
2227: )
2228: )
2229: )
2230: FROM wsh_delivery_details wdd
2231: WHERE wdd.tracking_number= p_request_in.InquiryNumber;
2232:
2233:
2234: BEGIN