APPS.WSH_INTEGRATION dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 212: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda,

208:
209: BEGIN
210: select count(*)
211: into l_untrxd_rec_count
212: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
213: wsh_new_deliveries wnd, wsh_delivery_legs wdl, wsh_trip_stops wts
214: where
215: wdd.source_code = 'OE'
216: and wdd.released_status = 'C'

Line 246: from wsh_delivery_details wdd, wsh_delivery_assignments wda,

242: BEGIN
243: -- Check for Expense Destination Type Code Receiving Transactions
244: select count(*)
245: into l_rec_exp_count
246: from wsh_delivery_details wdd, wsh_delivery_assignments wda,
247: wsh_new_deliveries wnd, wsh_delivery_legs wdl, wsh_trip_stops wts,
248: oe_order_lines_all oel, po_requisition_lines_all pl
249: where
250: wdd.source_code = 'OE'

Line 285: from wsh_delivery_details wdd, wsh_delivery_assignments wda,

281: BEGIN
282: -- Check for Direct Shipment which are not Expense Destination Type Code Related
283: select count(*)
284: into l_rec_direct_count
285: from wsh_delivery_details wdd, wsh_delivery_assignments wda,
286: wsh_new_deliveries wnd, wsh_delivery_legs wdl, wsh_trip_stops wts,
287: oe_order_lines_all oel, po_requisition_lines_all pl,
288: mtl_interorg_parameters mip
289: where

Line 1690: wsh_delivery_assignments wda,

1686: where
1687: wdd.source_line_id = p_source_line_id
1688: and wdd.source_code = p_source_code
1689: and not exists (select 'x' from
1690: wsh_delivery_assignments wda,
1691: wsh_new_deliveries wnd
1692: where
1693: wda.delivery_detail_id = wdd.delivery_detail_id
1694: and wda.delivery_id = wnd.delivery_id

Line 1807: FROM wsh_delivery_assignments wda,wsh_delivery_details wdd

1803:
1804: --Get the delivery details and associated container delivery details records for the order line id passed
1805: CURSOR c_wdd_lpn_for_line (l_line_id NUMBER ) IS
1806: SELECT wdd.*
1807: FROM wsh_delivery_assignments wda,wsh_delivery_details wdd
1808: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
1809: START WITH wda.delivery_detail_id in
1810: ( SELECT delivery_detail_id
1811: FROM wsh_delivery_details

Line 1828: FROM wsh_delivery_assignments

1824:
1825: --Get the parent_delivery_detail_id for delivery detail
1826: CURSOR c_assignment(l_delivery_detail_id NUMBER ) IS
1827: SELECT parent_delivery_detail_id
1828: FROM wsh_delivery_assignments
1829: WHERE delivery_detail_id =l_delivery_detail_id ;
1830:
1831: ----Get the actual departure date
1832: CURSOR c_actual_ship_date(l_line_id NUMBER ) IS

Line 1835: wsh_delivery_assignments wda ,

1831: ----Get the actual departure date
1832: CURSOR c_actual_ship_date(l_line_id NUMBER ) IS
1833: SELECT wts.actual_departure_date,wcs.ship_method_meaning,hp.party_name
1834: FROM wsh_delivery_details wdd ,
1835: wsh_delivery_assignments wda ,
1836: wsh_new_deliveries wnd ,
1837: wsh_delivery_legs wdl ,
1838: wsh_trip_stops wts,
1839: wsh_trips wt,