[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
71: dd.net_weight,
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
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
2088: dl.delivery_id = nd.delivery_id and
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
2164: dl.delivery_id = nd.delivery_id and
2393: h.conversion_rate_date,
2394: h.conversion_rate,
2395: l.line_id,
2396: l.header_id
2397: FROM oe_order_headers_all h, oe_order_lines_all l, wsh_delivery_details wdd
2398: WHERE wdd.delivery_detail_id = c_delivery_detail_id AND
2399: wdd.source_line_id = l.line_id AND
2400: wdd.source_code = 'OE' and
2401: l.header_id = h.header_id;
3046: wft.freight_cost_type_code,
3047: wfc.conversion_type_code,
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,
3081: wfc.currency_code,
3082: wft.freight_cost_type_code
3083: , wfc.conversion_type_code, wfc.conversion_rate
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,
3679:
3680: CURSOR C_Details_Assigned(p_source_line_id NUMBER)
3681: IS
3682: SELECT delivery_detail_id
3683: FROM wsh_delivery_details
3684: WHERE source_line_id = p_source_line_id
3685: AND source_code = 'OE'
3686: AND container_flag = 'N';
3687:
3731: END IF;
3732: --
3733: SELECT wsh.source_line_id
3734: INTO l_line_id
3735: FROM wsh_delivery_details wsh, oe_order_lines_all l
3736: WHERE wsh.delivery_detail_id = p_delivery_detail_id AND
3737: wsh.source_line_id = l.line_id and
3738: wsh.source_code = 'OE';
3739:
3748:
3749: -- first, get the number of delivery details associated with this source_line_id
3750: SELECT COUNT(*)
3751: INTO l_number_details_assigned
3752: FROM wsh_delivery_details
3753: WHERE source_line_id = l_line_id and
3754: source_code = 'OE';
3755:
3756: -- Fetch uom of the first detail as standard uom
3759: CLOSE C_Details_Assigned;
3760:
3761: SELECT requested_quantity_uom
3762: INTO l_standard_uom
3763: FROM wsh_delivery_details
3764: WHERE delivery_detail_id = l_detail_id;
3765:
3766: OPEN C_Details_Assigned(l_line_id);
3767: LOOP
3769: EXIT WHEN C_Details_Assigned%NOTFOUND;
3770:
3771: SELECT shipped_quantity, requested_quantity_uom, inventory_item_id
3772: INTO l_unit, l_uom , l_inventory_item_id
3773: FROM wsh_delivery_details
3774: WHERE delivery_detail_id = l_detail_id;
3775:
3776: --
3777: -- Debug Statements
3796: WHERE charge_id = p_charge_id;
3797:
3798: SELECT shipped_quantity, requested_quantity_uom , inventory_item_id
3799: INTO l_unit, l_uom , l_inventory_item_id
3800: FROM wsh_delivery_details
3801: WHERE delivery_detail_id = p_delivery_detail_id;
3802:
3803: --
3804: -- Debug Statements