DBA Data[Home] [Help]

APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on WSH_TRIPS_OB_GRP_V

Line 560: from wsh_trips_ob_grp_v trip,

556: l_trip_id NUMBER;
557: BEGIN
558: select trip.name, trip.trip_id
559: into l_trip_name, l_trip_id
560: from wsh_trips_ob_grp_v trip,
561: wsh_trip_stops_ob_grp_v pickup_stop,
562: wsh_trip_stops_ob_grp_v dropoff_stop,
563: wsh_delivery_legs_ob_grp_v wdl,
564: wsh_new_deliveries_ob_grp_v wnd

Line 582: from wsh_trips_ob_grp_v

578: p_trip_name IN VARCHAR2) IS
579: BEGIN
580: open x_trip_lov for
581: select name, trip_id, ship_method_code, carrier_id
582: from wsh_trips_ob_grp_v
583: where name like p_trip_name
584: and status_code = 'OP';
585: end GET_TRIP_LOV;
586: