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 401: FROM wsh_delivery_assignments_v

397:
398: /* CURSOR c_assigned(c_delivery_detail_id number) is
399: SELECT decode ( delivery_id , null , 'N' , 'Y' ),
400: decode( delivery_id,null,-9999999,delivery_id)
401: FROM wsh_delivery_assignments_v
402: WHERE delivery_Detail_id = c_delivery_detail_id ; */
403:
404: -- bug# 6908504 (replenishment project), Changed the cursor definition. Now it returns planned_flag value from WND table.
405: CURSOR c_assigned(c_delivery_detail_id number) is

Line 410: wsh_delivery_assignments_v wda

406: SELECT wnd.delivery_id,
407: wnd.planned_flag
408: FROM wsh_new_deliveries wnd,
409: wsh_delivery_details wdd,
410: wsh_delivery_assignments_v wda
411: WHERE wdd.delivery_detail_id = c_delivery_detail_id
412: AND wda.delivery_id = wnd.delivery_id
413: AND wda.delivery_detail_id = wdd.delivery_detail_id ;
414: