[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
3012: wft.freight_cost_type_code
3013: , wfc.conversion_type_code, wfc.conversion_rate
3014: FROM wsh_freight_costs wfc,
3015: wsh_freight_cost_types wft,
3016: wsh_delivery_legs wdl,
3017: wsh_new_deliveries wnd,
3018: wsh_trip_stops wts
3019: WHERE wts.stop_id = p_stop_id and
3020: wts.stop_id = wdl.pick_up_stop_id and
3049: FROM wsh_delivery_assignments_v wda,
3050: wsh_delivery_details wdd,
3051: wsh_freight_costs wfc,
3052: wsh_freight_cost_types wft,
3053: wsh_delivery_legs wdl,
3054: wsh_new_deliveries wnd,
3055: wsh_trip_stops wts
3056: WHERE wts.stop_id = wdl.pick_up_stop_id and
3057: wts.stop_id = p_stop_id and
3085: wsh_delivery_details wdd,
3086: oe_order_lines_all ol,
3087: wsh_freight_costs wfc,
3088: wsh_freight_cost_types wft,
3089: wsh_delivery_legs wdl,
3090: wsh_new_deliveries wnd,
3091: wsh_trip_stops wts
3092: WHERE wts.stop_id = wdl.pick_up_stop_id and
3093: wts.stop_id = p_stop_id and