DBA Data[Home] [Help]

APPS.WSH_TMS_RELEASE dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 3573: wsh_delivery_assignments wda, wsh_delivery_details wdd

3569: CURSOR c_lock_deliveries_and_details (c_drop_off_stop_id IN number) IS
3570: SELECT wnd.delivery_id, wdd.delivery_detail_id
3571: FROM wsh_new_deliveries wnd,
3572: wsh_delivery_legs wdl,
3573: wsh_delivery_assignments wda, wsh_delivery_details wdd
3574: WHERE wdl.drop_off_stop_id = c_drop_off_stop_id
3575: AND wdl.delivery_id = wnd.delivery_id
3576: AND WSH_UTIL_VALIDATE.CHECK_WMS_ORG(wnd.organization_id) = 'Y'
3577: AND wnd.delivery_id = wda.delivery_id