[Home] [Help]
144: source_header_id,
145: source_line_set_id,
146: source_code,
147: source_line_id
148: FROM wsh_delivery_details
149: WHERE move_order_line_id = p_mo_line_id;
150:
151: l_detail_info c_detail_info%ROWTYPE;
152: l_minmaxinrectype WSH_DETAILS_VALIDATIONS.MinMaxInRecType;
151: l_detail_info c_detail_info%ROWTYPE;
152: l_minmaxinrectype WSH_DETAILS_VALIDATIONS.MinMaxInRecType;
153: l_minmaxinoutrectype WSH_DETAILS_VALIDATIONS.MinMaxInOutRecType;
154: l_minmaxoutrectype WSH_DETAILS_VALIDATIONS.MinMaxOutRecType;
155: l_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
156: l_min_quantity NUMBER;
157: l_max_quantity NUMBER;
158: l_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
159: l_min_quantity2 NUMBER;
154: l_minmaxoutrectype WSH_DETAILS_VALIDATIONS.MinMaxOutRecType;
155: l_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
156: l_min_quantity NUMBER;
157: l_max_quantity NUMBER;
158: l_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
159: l_min_quantity2 NUMBER;
160: l_max_quantity2 NUMBER;
161: l_req_quantity NUMBER;
162: l_move_order_type NUMBER;
2127: AND move_order_line_id IS NOT NULL
2128: AND released_status = 'S';
2129: */
2130: /* Bug 5570553 added the index hint with the suggestion of apps performance team */
2131: SELECT /*+index (WDD WSH_DELIVERY_DETAILS_N7)*/
2132: wdd.source_header_id oe_header_id,
2133: wts.stop_id trip_stop_id,
2134: wdd.source_line_id oe_line_id,
2135: wda.delivery_id shipping_delivery_id,
2143: wdd.move_order_line_id move_order_line_id,
2144: wdd.released_status,
2145: wdd.delivery_detail_id
2146: INTO l_demand_info
2147: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
2148: wsh_new_deliveries wnd, wsh_delivery_legs wlg, wsh_trip_stops wts
2149: WHERE wnd.delivery_id(+) = wda.delivery_id
2150: AND wlg.delivery_id(+) = wnd.delivery_id
2151: AND wts.stop_id(+) = wlg.pick_up_stop_id