APPS.POR_VIEW_REQS_PKG dependencies on WSH_DELIVERY_DETAILS
Line 466: FROM wsh_delivery_details
462: get value from shipping table */
463: ELSE
464: SELECT sum(decode(released_status, 'Y', 1, 0)), sum(1)
465: INTO l_released_count, l_total_count 466: FROM wsh_delivery_details 467: WHERE source_line_id = p_line_id
468: AND source_code = 'OE'
469: AND released_status <> 'D';
470: