[Home] [Help]
2961: c.freight_cost_type_code
2962: , a.conversion_type_code, a.conversion_rate
2963: FROM wsh_freight_costs a,
2964: wsh_trip_stops b,
2965: wsh_freight_cost_types c
2966: WHERE a.trip_id = b.trip_id and
2967: b.stop_id = p_stop_id and
2968: c.freight_cost_type_id = a.freight_cost_type_id and
2969: /* H projects: pricing integration csun
2983: SELECT a.stop_id, a.freight_cost_id, a.unit_amount, a.currency_code,
2984: b.freight_cost_type_code
2985: , a.conversion_type_code, a.conversion_rate
2986: FROM wsh_freight_costs a,
2987: wsh_freight_cost_types b
2988: WHERE a.stop_id = p_stop_id and
2989: a.freight_cost_type_id = b.freight_cost_type_id and
2990: /* H projects: pricing integration csun
2991: only line_type_code NULL, PRICE, CHARGE should be
3004: wfc.unit_amount, wfc.currency_code,
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
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,
3047: wsh_new_deliveries wnd,
3048: wsh_trip_stops wts
3049: WHERE wts.stop_id = wdl.pick_up_stop_id and
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,
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