APPS.POR_VIEW_REQS_PKG dependencies on WSH_DELIVERY_DETAILS

Line 543: FROM wsh_delivery_details

539: get value from shipping table */
540: ELSE
541: SELECT sum(decode(released_status, 'Y', 1, 0)), sum(1)
542: INTO l_released_count, l_total_count
543: FROM wsh_delivery_details
544: WHERE source_line_id = p_line_id
545: AND source_code = 'OE'
546: AND released_status <> 'D';
547: