DBA Data[Home] [Help]

APPS.WSH_TRIPS_GRP dependencies on WSH_DELIVERY_LEGS

Line 502: wsh_Delivery_legs wdl,

498: CURSOR dlvy_csr(p_trip_id NUMBER)
499: IS
500: SELECT wdl.delivery_id, wt.name
501: FROM wsh_trip_stops wts,
502: wsh_Delivery_legs wdl,
503: wsh_new_deliveries wnd,
504: wsh_trips wt
505: WHERE wt.trip_id = p_trip_id
506: AND wts.trip_id = p_trip_id

Line 2422: FROM wsh_new_deliveries wnd, wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_trips wt

2418:
2419: --Compatibility Changes
2420: CURSOR c_getorgcarriersmc (p_tripid NUMBER) IS
2421: SELECT wnd.organization_id, wnd.name, wt.ship_method_code, wt.carrier_id
2422: FROM wsh_new_deliveries wnd, wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_trips wt
2423: WHERE wnd.delivery_id=wdl.delivery_id
2424: and wdl.pick_up_stop_id=wts.stop_id
2425: and wt.trip_id = p_tripid
2426: and wt.trip_id=wts.trip_id