eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_ASN_RECEIPT_PVT dependencies on WSH_TRIPS

Line 1534: wsh_trips t

1530: SELECT t.trip_id
1531: FROM wsh_new_deliveries dl,
1532: wsh_delivery_legs dg,
1533: wsh_trip_stops st,
1534: wsh_trips t
1535: WHERE dl.delivery_id = p_del_id_c1 AND
1536: dl.delivery_id = dg.delivery_id AND
1537: dg.drop_off_stop_id = st.stop_id AND
1538: st.stop_location_id = dl.ULTIMATE_DROPOFF_LOCATION_ID AND

Line 4576: -- Trip, the API WSH_TRIPS_ACTIONS.autocreate_trip_multi to create Trips.

4572: -- deliveries within the list and checks if the deliveries consist
4573: -- of any delivery detail not yet shipped. It unassigns all those
4574: -- delivery details.
4575: -- 3.For lines which have a delivery ID but not yet assigned to a
4576: -- Trip, the API WSH_TRIPS_ACTIONS.autocreate_trip_multi to create Trips.
4577: -- 4.It identifies the delivery details having null delivery_ids.
4578: -- Invokes WSH_TRIPS_ACTIONS.AUTOCREATE_DEL_TRIP for the entire list of Delivery details
4579: -- so that all the records in the dd_rec structure become uniform
4580: -- in all respect for further treatment.

Line 4578: -- Invokes WSH_TRIPS_ACTIONS.AUTOCREATE_DEL_TRIP for the entire list of Delivery details

4574: -- delivery details.
4575: -- 3.For lines which have a delivery ID but not yet assigned to a
4576: -- Trip, the API WSH_TRIPS_ACTIONS.autocreate_trip_multi to create Trips.
4577: -- 4.It identifies the delivery details having null delivery_ids.
4578: -- Invokes WSH_TRIPS_ACTIONS.AUTOCREATE_DEL_TRIP for the entire list of Delivery details
4579: -- so that all the records in the dd_rec structure become uniform
4580: -- in all respect for further treatment.
4581: -- Parameters :
4582: -- IN:

Line 4679: wsh_trips wt

4675: wt.trip_id
4676: FROM wsh_delivery_assignments_v wda,
4677: wsh_delivery_legs wdl,
4678: wsh_trip_stops wts,
4679: wsh_trips wt
4680: WHERE wda.delivery_detail_id = p_del_detail_id
4681: AND wda.delivery_id = wdl.delivery_id
4682: AND wdl.pick_up_stop_id = wts.stop_id
4683: AND wts.trip_id = wt.trip_id;

Line 4692: wsh_trips wt

4688: select wt.trip_id
4689: FROM wsh_delivery_assignments_v wda,
4690: wsh_delivery_legs wdl,
4691: wsh_trip_stops wts,
4692: wsh_trips wt
4693: WHERE wda.delivery_id = p_delivery_id
4694: AND wda.delivery_id = wdl.delivery_id
4695: AND wdl.pick_up_stop_id = wts.stop_id
4696: AND wts.trip_id = wt.trip_id;

Line 4787: -- Calls the API WSH_TRIPS_ACTIONS.AUTOCREATE_DEL_TRIP to create delivery and trip for those

4783: l_ind := p_index_dd_ids_ext_cache.NEXT(l_ind);
4784: END LOOP;
4785:
4786:
4787: -- Calls the API WSH_TRIPS_ACTIONS.AUTOCREATE_DEL_TRIP to create delivery and trip for those
4788: -- delivery detail ids not having both.
4789: IF l_dd_ids_tab.count > 0 THEN
4790:
4791: --

Line 4796: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.AUTOCREATE_DEL_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);

4792: -- Debug Statements
4793: --
4794: IF l_debug_on THEN
4795: WSH_DEBUG_SV.log(l_module_name,'l_dd_ids_tab.count',l_dd_ids_tab.count);
4796: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.AUTOCREATE_DEL_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);
4797: END IF;
4798: --
4799:
4800:

Line 4801: WSH_TRIPS_ACTIONS.AUTOCREATE_DEL_TRIP(

4797: END IF;
4798: --
4799:
4800:
4801: WSH_TRIPS_ACTIONS.AUTOCREATE_DEL_TRIP(
4802: p_line_rows => l_dd_ids_tab,
4803: p_org_rows => l_org_rows,
4804: p_max_detail_commit => 1000,
4805: x_del_rows => l_del_rows,

Line 4906: -- Calls the API WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP_MULTI to create trip for those

4902: END LOOP;
4903:
4904:
4905:
4906: -- Calls the API WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP_MULTI to create trip for those
4907: -- delivery ids which have not been assigned to any trip.
4908: IF l_del_rows.COUNT > 0 THEN
4909: --
4910: -- Debug Statements

Line 4913: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP_MULTI',WSH_DEBUG_SV.C_PROC_LEVEL);

4909: --
4910: -- Debug Statements
4911: --
4912: IF l_debug_on THEN
4913: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP_MULTI',WSH_DEBUG_SV.C_PROC_LEVEL);
4914: WSH_DEBUG_SV.log(l_module_name,'l_del_rows.count = ',l_del_rows.count);
4915: END IF;
4916: --
4917:

Line 4918: WSH_TRIPS_ACTIONS.autocreate_trip_multi(

4914: WSH_DEBUG_SV.log(l_module_name,'l_del_rows.count = ',l_del_rows.count);
4915: END IF;
4916: --
4917:
4918: WSH_TRIPS_ACTIONS.autocreate_trip_multi(
4919: p_del_rows => l_del_rows,
4920: x_trip_ids => l_trip_ids,
4921: x_trip_names => l_trip_names,
4922: x_return_status => l_return_status);

Line 4928: WSH_DEBUG_SV.log(l_module_name,'RET STS OF WSH_TRIPS_ACTIONS.autocreate_trip_multi IS :', l_return_status);

4924: --
4925: -- Debug Statements
4926: --
4927: IF l_debug_on THEN
4928: WSH_DEBUG_SV.log(l_module_name,'RET STS OF WSH_TRIPS_ACTIONS.autocreate_trip_multi IS :', l_return_status);
4929: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
4930: END IF;
4931: --
4932: wsh_util_core.api_post_call(

Line 5004: UPDATE WSH_TRIPS

5000:
5001: IF l_new_trip_id_count > 0
5002: THEN
5003: FORALL i in l_new_trip_ids.FIRST..l_new_trip_ids.LAST
5004: UPDATE WSH_TRIPS
5005: SET carrier_id = l_carrier_id,
5006: last_update_date = SYSDATE,
5007: last_updated_by = FND_GLOBAL.USER_ID,
5008: last_update_login = FND_GLOBAL.LOGIN_ID

Line 5610: UPDATE wsh_trips

5606: -- truck_flag : this flag is used to check whether
5607: -- the truck number remains the same within a trip.
5608: IF curr_trip_id <> prev_trip_id THEN
5609: IF (truck_flag = 0) AND ( prev_trip_id <> -1 ) THEN
5610: UPDATE wsh_trips
5611: SET vehicle_number = prev_truck_num
5612: WHERE trip_id = prev_trip_id;
5613: ELSE
5614:

Line 5642: UPDATE wsh_trips

5638: --etc..has to be done.So a call to CREATE_UPDATE_WAYBILL_PSNO_BOL is made.
5639:
5640: --
5641: IF (truck_flag = 0 ) AND ( curr_trip_id <> -1 ) THEN
5642: UPDATE wsh_trips
5643: SET vehicle_number = curr_truck_num
5644: WHERE trip_id = curr_trip_id;
5645: END IF;
5646: --

Line 7395: wsh_trips t

7391: SELECT dg.delivery_leg_id
7392: FROM wsh_new_deliveries dl,
7393: wsh_delivery_legs dg,
7394: wsh_trip_stops st,
7395: wsh_trips t
7396: WHERE dl.delivery_id = p_delivery_id AND
7397: dl.delivery_id = dg.delivery_id AND
7398: dg.pick_up_stop_id = st.stop_id AND
7399: st.trip_id = t.trip_id;

Line 7407: wsh_trips wt

7403: SELECT wdl.delivery_leg_id
7404: FROM wsh_new_deliveries wnd,
7405: wsh_delivery_legs wdl,
7406: wsh_trip_stops wts,
7407: wsh_trips wt
7408: WHERE wnd.delivery_id = p_delivery_id AND
7409: wnd.delivery_id = wdl.delivery_id AND
7410: wdl.drop_off_stop_id = wts.stop_id AND
7411: wnd.ultimate_dropoff_location_id = wts.stop_location_id AND

Line 7779: wsh_trips t

7775: t.name
7776: FROM wsh_new_deliveries dl,
7777: wsh_delivery_legs dg,
7778: wsh_trip_stops st,
7779: wsh_trips t
7780: WHERE dl.delivery_id = p_delivery_id AND
7781: dl.delivery_id = dg.delivery_id AND
7782: dg.drop_off_stop_id = st.stop_id AND
7783: st.stop_location_id = dl.ULTIMATE_DROPOFF_LOCATION_ID AND