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_FC_INTERFACE_PKG dependencies on WSH_NEW_DELIVERIES

Line 77: wsh_new_deliveries nd,

73: dd.volume,
74: dd.volume_uom_code
75: FROM wsh_delivery_details dd,
76: wsh_delivery_assignments_v da,
77: wsh_new_deliveries nd,
78: oe_order_lines_all ol
79: WHERE dd.delivery_detail_id = da.delivery_detail_id AND
80: da.delivery_id = nd.delivery_id AND
81: da.delivery_id IS NOT NULL AND

Line 94: wsh_new_deliveries dl,

90:
91: CURSOR c_pickup_deliveries (c_stop_id NUMBER) IS
92: SELECT dg.delivery_id
93: FROM wsh_delivery_legs dg,
94: wsh_new_deliveries dl,
95: wsh_trip_stops st
96: WHERE st.stop_id = dg.pick_up_stop_id AND
97: st.stop_id = c_stop_id AND
98: st.stop_location_id = dl.initial_pickup_location_id AND

Line 2081: wsh_new_deliveries nd,

2077:
2078: CURSOR C_Sharing_Stops IS
2079: SELECT distinct st.stop_id
2080: FROM wsh_trip_stops st,
2081: wsh_new_deliveries nd,
2082: wsh_delivery_legs dl,
2083: wsh_delivery_assignments_v da,
2084: wsh_delivery_details dd
2085: WHERE

Line 2157: wsh_new_deliveries nd,

2153: --
2154: /* get number of stops with pickup deliveries in this trip */
2155: select count(distinct st.stop_id) into l_number_of_stops
2156: from wsh_trip_stops st,
2157: wsh_new_deliveries nd,
2158: wsh_delivery_legs dl,
2159: wsh_delivery_assignments_v da,
2160: wsh_delivery_details dd
2161: where

Line 3010: wsh_new_deliveries wnd,

3006: , wfc.conversion_type_code, wfc.conversion_rate
3007: FROM wsh_freight_costs wfc,
3008: wsh_freight_cost_types wft,
3009: wsh_delivery_legs wdl,
3010: wsh_new_deliveries wnd,
3011: wsh_trip_stops wts
3012: WHERE wts.stop_id = p_stop_id and
3013: wts.stop_id = wdl.pick_up_stop_id and
3014: wts.stop_location_id = wnd.initial_pickup_location_id and

Line 3047: wsh_new_deliveries wnd,

3043: wsh_delivery_details wdd,
3044: wsh_freight_costs wfc,
3045: wsh_freight_cost_types wft,
3046: wsh_delivery_legs wdl,
3047: wsh_new_deliveries wnd,
3048: wsh_trip_stops wts
3049: WHERE wts.stop_id = wdl.pick_up_stop_id and
3050: wts.stop_id = p_stop_id and
3051: wts.stop_location_id = wnd.initial_pickup_location_id and

Line 3083: wsh_new_deliveries wnd,

3079: oe_order_lines_all ol,
3080: wsh_freight_costs wfc,
3081: wsh_freight_cost_types wft,
3082: wsh_delivery_legs wdl,
3083: wsh_new_deliveries wnd,
3084: wsh_trip_stops wts
3085: WHERE wts.stop_id = wdl.pick_up_stop_id and
3086: wts.stop_id = p_stop_id and
3087: wts.stop_location_id = wnd.initial_pickup_location_id and