APPS.INV_RESERVATION_AVAIL_PVT dependencies on WSH_DELIVERY_DETAILS

Line 891: FROM wsh_delivery_details

887: -- get wdd requested quantity with line detail level
888: BEGIN
889: SELECT nvl(sum(requested_quantity), 0)
890: INTO l_wdd_primary_quantity
891: FROM wsh_delivery_details
892: WHERE source_line_id = p_demand_source_line_id
893: AND delivery_detail_id = p_demand_source_line_detail
894: AND nvl(project_id, -99) = nvl(p_project_id, -99)
895: AND nvl(task_id, -99) = nvl(p_task_id, -99);