DBA Data[Home] [Help]

APPS.WSH_TRIP_STOPS_VALIDATIONS dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 922: wsh_delivery_assignments_v wda,

918: cursor stop_to_det_cur( p_stop_id IN NUMBER ) is
919: select distinct 'X'
920: from wsh_delivery_details wdd,
921: wsh_new_deliveries wnd,
922: wsh_delivery_assignments_v wda,
923: wsh_delivery_legs wdl
924: where (wdl.pick_up_stop_id = p_stop_id OR wdl.drop_off_stop_id = p_stop_id)
925: and wnd.delivery_id = wdl.delivery_id
926: and wda.delivery_id = wnd.delivery_id