APPS.WSH_SHIP_CONFIRM_ACTIONS2 dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 187: wsh_delivery_assignments_v da ,

183: ,shipped_quantity2 -- OPM KYH 12/SEP/00
184: , dd.source_line_id
185: , dl.status_code
186: FROM wsh_delivery_Details dd,
187: wsh_delivery_assignments_v da ,
188: wsh_delivery_legs dg,
189: wsh_new_deliveries dl,
190: wsh_trip_stops st
191: WHERE st.stop_id = dg.pick_up_stop_id AND

Line 409: FROM wsh_delivery_assignments_v

405:
406: /* CURSOR c_assigned(c_delivery_detail_id number) is
407: SELECT decode ( delivery_id , null , 'N' , 'Y' ),
408: decode( delivery_id,null,-9999999,delivery_id)
409: FROM wsh_delivery_assignments_v
410: WHERE delivery_Detail_id = c_delivery_detail_id ; */
411:
412: -- bug# 6908504 (replenishment project), Changed the cursor definition. Now it returns planned_flag value from WND table.
413: -- muom

Line 421: wsh_delivery_assignments_v wda

417: wdd.source_code,
418: wdd.source_line_id
419: FROM wsh_new_deliveries wnd,
420: wsh_delivery_details wdd,
421: wsh_delivery_assignments_v wda
422: WHERE wdd.delivery_detail_id = c_delivery_detail_id
423: AND wda.delivery_id = wnd.delivery_id (+)
424: AND wda.delivery_detail_id = wdd.delivery_detail_id ;
425: