[Home] [Help]
111: wnd.tms_interface_flag, -- OTM R12 : update requested quantity change
112: wdd.replenishment_status --bug# 6689448 (replenishment project)
113: FROM wsh_delivery_details wdd,
114: wsh_new_deliveries wnd,
115: wsh_delivery_assignments_v wda
116: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
117: AND wda.delivery_id = wnd.delivery_id (+)
118: AND wdd.source_line_id = p_changed_attribute.source_line_id
119: AND wdd.source_code = p_source_code
169: wnd.tms_interface_flag, -- OTM R12 : update requested quantity change
170: wdd.replenishment_status --bug# 6689448 (replenishment project)
171: FROM wsh_delivery_details wdd,
172: wsh_new_deliveries wnd,
173: wsh_delivery_assignments_v wda,
174: mtl_serial_numbers_temp msnt
175: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
176: AND wda.delivery_id = wnd.delivery_id (+)
177: AND wdd.source_line_id = p_changed_attribute.source_line_id
517: where
518: wdd.source_line_id = p_changed_attribute.source_line_id
519: and wdd.source_code = p_source_code
520: and not exists (select 'x' from
521: wsh_delivery_assignments wda,
522: wsh_new_deliveries wnd
523: where wda.delivery_detail_id = wdd.delivery_detail_id
524: and wda.delivery_id = wnd.delivery_id
525: and wnd.status_code in ('CL', 'IT', 'CO'));
1874: ,wdd.source_header_id
1875: ,wdd.picked_quantity
1876: ,wdd.picked_quantity2
1877: FROM wsh_delivery_details wdd,
1878: wsh_delivery_assignments_v wda
1879: WHERE wdd.source_line_id = p_source_line_id
1880: AND wdd.source_code = p_source_code
1881: AND wdd.released_status IN ('S','Y')
1882: AND wdd.requested_quantity = 0
2423: CURSOR c_check_del_assign(p_del_det IN NUMBER) is
2424: SELECT wda.delivery_id, wnd.planned_flag,
2425: wnd.ignore_for_planning, -- OTM R12 : cancel quantity
2426: wnd.tms_interface_flag -- OTM R12 : cancel quantity
2427: FROM wsh_delivery_assignments_v wda,
2428: wsh_new_deliveries wnd
2429: WHERE wda.delivery_id is not null
2430: AND wda.delivery_detail_id = p_del_det
2431: AND wda.delivery_id = wnd.delivery_id;