APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on WSH_DELIVERY_TRIPS_V

Line 3962: FROM wsh_delivery_trips_v wdt1,

3958: AND wscr.ship_confirm_rule_id = wsp.ship_confirm_rule_id;
3959:
3960: CURSOR Check_Last_Trip (l_delivery_id NUMBER) IS
3961: SELECT wdt1.trip_id
3962: FROM wsh_delivery_trips_v wdt1,
3963: wsh_new_deliveries wnd
3964: WHERE wdt1.delivery_id <> l_delivery_id
3965: AND wdt1.delivery_id = wnd.delivery_id
3966: AND wnd.status_code = 'OP'

Line 3968: FROM wsh_delivery_trips_v wdt2

3964: WHERE wdt1.delivery_id <> l_delivery_id
3965: AND wdt1.delivery_id = wnd.delivery_id
3966: AND wnd.status_code = 'OP'
3967: AND wdt1.trip_id IN (SELECT wdt2.trip_id
3968: FROM wsh_delivery_trips_v wdt2
3969: WHERE wdt2.delivery_id = l_delivery_id)
3970: AND rownum = 1;
3971:
3972: l_delivery_id NUMBER;