DBA Data[Home] [Help]

APPS.WSH_USA_QUANTITY_PVT dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 126: wsh_delivery_assignments_v wda

122: wnd.tms_interface_flag, -- OTM R12 : update requested quantity change
123: wdd.replenishment_status --bug# 6689448 (replenishment project)
124: FROM wsh_delivery_details wdd,
125: wsh_new_deliveries wnd,
126: wsh_delivery_assignments_v wda
127: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
128: AND wda.delivery_id = wnd.delivery_id (+)
129: AND wdd.source_line_id = p_changed_attribute.source_line_id
130: AND wdd.source_code = p_source_code

Line 190: wsh_delivery_assignments_v wda,

186: wnd.tms_interface_flag, -- OTM R12 : update requested quantity change
187: wdd.replenishment_status --bug# 6689448 (replenishment project)
188: FROM wsh_delivery_details wdd,
189: wsh_new_deliveries wnd,
190: wsh_delivery_assignments_v wda,
191: mtl_serial_numbers_temp msnt
192: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
193: AND wda.delivery_id = wnd.delivery_id (+)
194: AND wdd.source_line_id = p_changed_attribute.source_line_id

Line 581: wsh_delivery_assignments wda,

577: where
578: wdd.source_line_id = p_changed_attribute.source_line_id
579: and wdd.source_code = p_source_code
580: and not exists (select 'x' from
581: wsh_delivery_assignments wda,
582: wsh_new_deliveries wnd
583: where wda.delivery_detail_id = wdd.delivery_detail_id
584: and wda.delivery_id = wnd.delivery_id
585: and wnd.status_code in ('CL', 'IT', 'CO'));

Line 2139: wsh_delivery_assignments_v wda

2135: ,wdd.source_header_id
2136: ,wdd.picked_quantity
2137: ,wdd.picked_quantity2
2138: FROM wsh_delivery_details wdd,
2139: wsh_delivery_assignments_v wda
2140: WHERE wdd.source_line_id = p_source_line_id
2141: AND wdd.source_code = p_source_code
2142: AND wdd.released_status IN ('S','Y')
2143: -- muom

Line 2706: FROM wsh_delivery_assignments_v wda,

2702: CURSOR c_check_del_assign(p_del_det IN NUMBER) is
2703: SELECT wda.delivery_id, wnd.planned_flag,
2704: wnd.ignore_for_planning, -- OTM R12 : cancel quantity
2705: wnd.tms_interface_flag -- OTM R12 : cancel quantity
2706: FROM wsh_delivery_assignments_v wda,
2707: wsh_new_deliveries wnd
2708: WHERE wda.delivery_id is not null
2709: AND wda.delivery_detail_id = p_del_det
2710: AND wda.delivery_id = wnd.delivery_id;