APPS.WSH_USA_QUANTITY_PVT dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 115: wsh_delivery_assignments_v wda

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

Line 173: wsh_delivery_assignments_v wda,

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

Line 1878: wsh_delivery_assignments_v wda

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

Line 2427: FROM wsh_delivery_assignments_v wda,

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;