[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
2386: h.conversion_rate_date,
2387: h.conversion_rate,
2388: l.line_id,
2389: l.header_id
2390: FROM oe_order_headers_all h, oe_order_lines_all l, wsh_delivery_details wdd
2391: WHERE wdd.delivery_detail_id = c_delivery_detail_id AND
2392: wdd.source_line_id = l.line_id AND
2393: wdd.source_code = 'OE' and
2394: l.header_id = h.header_id;
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,
3047: wsh_new_deliveries wnd,
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,
3082: wsh_delivery_legs wdl,
3672:
3673: CURSOR C_Details_Assigned(p_source_line_id NUMBER)
3674: IS
3675: SELECT delivery_detail_id
3676: FROM wsh_delivery_details
3677: WHERE source_line_id = p_source_line_id
3678: AND source_code = 'OE'
3679: AND container_flag = 'N';
3680:
3724: END IF;
3725: --
3726: SELECT wsh.source_line_id
3727: INTO l_line_id
3728: FROM wsh_delivery_details wsh, oe_order_lines_all l
3729: WHERE wsh.delivery_detail_id = p_delivery_detail_id AND
3730: wsh.source_line_id = l.line_id and
3731: wsh.source_code = 'OE';
3732:
3741:
3742: -- first, get the number of delivery details associated with this source_line_id
3743: SELECT COUNT(*)
3744: INTO l_number_details_assigned
3745: FROM wsh_delivery_details
3746: WHERE source_line_id = l_line_id and
3747: source_code = 'OE';
3748:
3749: -- Fetch uom of the first detail as standard uom
3752: CLOSE C_Details_Assigned;
3753:
3754: SELECT requested_quantity_uom
3755: INTO l_standard_uom
3756: FROM wsh_delivery_details
3757: WHERE delivery_detail_id = l_detail_id;
3758:
3759: OPEN C_Details_Assigned(l_line_id);
3760: LOOP
3762: EXIT WHEN C_Details_Assigned%NOTFOUND;
3763:
3764: SELECT shipped_quantity, requested_quantity_uom, inventory_item_id
3765: INTO l_unit, l_uom , l_inventory_item_id
3766: FROM wsh_delivery_details
3767: WHERE delivery_detail_id = l_detail_id;
3768:
3769: --
3770: -- Debug Statements
3789: WHERE charge_id = p_charge_id;
3790:
3791: SELECT shipped_quantity, requested_quantity_uom , inventory_item_id
3792: INTO l_unit, l_uom , l_inventory_item_id
3793: FROM wsh_delivery_details
3794: WHERE delivery_detail_id = p_delivery_detail_id;
3795:
3796: --
3797: -- Debug Statements