[Home] [Help]
89:
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
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
2086: st.trip_id = p_trip_id and
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
2162: st.trip_id = p_trip_id and
3005: wft.freight_cost_type_code
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
3042: FROM wsh_delivery_assignments_v wda,
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
3078: wsh_delivery_details wdd,
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