DBA Data[Home] [Help]

APPS.FTE_LANE_SEARCH dependencies on WSH_NEW_DELIVERIES

Line 1863: FROM wsh_new_deliveries

1859: (p_search_criteria.delivery_id is not null OR
1860: p_search_criteria.delivery_leg_id is not null)) THEN
1861:
1862: SELECT shipping_control INTO l_shipping_control
1863: FROM wsh_new_deliveries
1864: WHERE delivery_id = p_search_criteria.delivery_id;
1865:
1866: -- only perform constraints checking if supplier does not manage freight for delivery
1867: IF (l_shipping_control is null OR l_shipping_control <> 'SUPPLIER') THEN