DBA Data[Home] [Help]

APPS.GMI_SHIPPING_UTIL dependencies on WSH_NEW_DELIVERIES

Line 2339: wsh_new_deliveries d

2335: , d.waybill
2336: , d.ultimate_dropoff_date
2337: from wsh_delivery_assignments a,
2338: wsh_delivery_details dd,
2339: wsh_new_deliveries d
2340: where a.delivery_detail_id = dd.delivery_detail_id
2341: and d.delivery_id = a.delivery_id
2342: and dd.delivery_detail_id = p_shipping_line.delivery_detail_id
2343: and NVL(dd.container_flag, 'N') = 'N';

Line 2824: wsh_new_deliveries dl,

2820:
2821: CURSOR pickup_deliveries IS
2822: SELECT dg.delivery_id , st.transaction_header_id
2823: FROM wsh_delivery_legs dg,
2824: wsh_new_deliveries dl,
2825: wsh_trip_stops st
2826: WHERE st.stop_id = dg.pick_up_stop_id AND
2827: st.stop_id = p_stop_id AND
2828: st.stop_location_id = dl.initial_pickup_location_id AND