DBA Data[Home] [Help]

APPS.WSH_TMS_RELEASE dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 3581: wsh_delivery_assignments wda, wsh_delivery_details wdd

3577: CURSOR c_lock_deliveries_and_details (c_drop_off_stop_id IN number) IS
3578: SELECT wnd.delivery_id, wdd.delivery_detail_id
3579: FROM wsh_new_deliveries wnd,
3580: wsh_delivery_legs wdl,
3581: wsh_delivery_assignments wda, wsh_delivery_details wdd
3582: WHERE wdl.drop_off_stop_id = c_drop_off_stop_id
3583: AND wdl.delivery_id = wnd.delivery_id
3584: AND WSH_UTIL_VALIDATE.CHECK_WMS_ORG(wnd.organization_id) = 'Y'
3585: AND wnd.delivery_id = wda.delivery_id