[Home] [Help]
53: wdd.weight_uom_code,
54: wdd.volume,
55: wdd.volume_uom_code,
56: wdd.container_flag
57: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda
58: WHERE wda.parent_delivery_detail_id = c_container_id and
59: wda.delivery_detail_id = wdd.delivery_detail_id and
60: wdd.oe_interfaced_flag = 'N' and
61: wdd.released_status = 'C' and
72: dd.weight_uom_code,
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
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
2087: st.stop_id = dl.pick_up_stop_id and
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
2163: st.stop_id = dl.pick_up_stop_id and
3038: wfc.currency_code,
3039: wft.freight_cost_type_code,
3040: wfc.conversion_type_code,
3041: wfc.conversion_rate
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,
3073: wfc.unit_amount,
3074: wfc.currency_code,
3075: wft.freight_cost_type_code
3076: , wfc.conversion_type_code, wfc.conversion_rate
3077: FROM wsh_delivery_assignments_v wda,
3078: wsh_delivery_details wdd,
3079: oe_order_lines_all ol,
3080: wsh_freight_costs wfc,
3081: wsh_freight_cost_types wft,