[Home] [Help]
2968: c.freight_cost_type_code
2969: , a.conversion_type_code, a.conversion_rate
2970: FROM wsh_freight_costs a,
2971: wsh_trip_stops b,
2972: wsh_freight_cost_types c
2973: WHERE a.trip_id = b.trip_id and
2974: b.stop_id = p_stop_id and
2975: c.freight_cost_type_id = a.freight_cost_type_id and
2976: /* H projects: pricing integration csun
2990: SELECT a.stop_id, a.freight_cost_id, a.unit_amount, a.currency_code,
2991: b.freight_cost_type_code
2992: , a.conversion_type_code, a.conversion_rate
2993: FROM wsh_freight_costs a,
2994: wsh_freight_cost_types b
2995: WHERE a.stop_id = p_stop_id and
2996: a.freight_cost_type_id = b.freight_cost_type_id and
2997: /* H projects: pricing integration csun
2998: only line_type_code NULL, PRICE, CHARGE should be
3011: wfc.unit_amount, wfc.currency_code,
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
3048: wfc.conversion_rate
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
3084: FROM wsh_delivery_assignments_v wda,
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