APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on WSH_DELIVERY_TRIPS_V

Line 4122: FROM wsh_delivery_trips_v wdt1,

4118: AND wscr.ship_confirm_rule_id = wsp.ship_confirm_rule_id;
4119:
4120: CURSOR Check_Last_Trip (l_delivery_id NUMBER) IS
4121: SELECT wdt1.trip_id
4122: FROM wsh_delivery_trips_v wdt1,
4123: wsh_new_deliveries wnd
4124: WHERE wdt1.delivery_id <> l_delivery_id
4125: AND wdt1.delivery_id = wnd.delivery_id
4126: AND wnd.status_code = 'OP'

Line 4128: FROM wsh_delivery_trips_v wdt2

4124: WHERE wdt1.delivery_id <> l_delivery_id
4125: AND wdt1.delivery_id = wnd.delivery_id
4126: AND wnd.status_code = 'OP'
4127: AND wdt1.trip_id IN (SELECT wdt2.trip_id
4128: FROM wsh_delivery_trips_v wdt2
4129: WHERE wdt2.delivery_id = l_delivery_id)
4130: AND rownum = 1;
4131:
4132: l_delivery_id NUMBER;