APPS.OE_LINE_STATUS_PUB dependencies on WSH_DELIVERY_DETAILS

Line 829: FROM wsh_delivery_details

825: --SELECT sum(decode(released_status, 'Y', 1, 0)), sum(1)
826: SELECT sum(decode(released_status, 'Y', 1, 'C', 1, 0)), sum(1)
827: -- fix for 3696124 ends
828: INTO released_count, total_count
829: FROM wsh_delivery_details
830: WHERE source_line_id = p_line_id
831: AND source_code = 'OE'
832: AND released_status <> 'D';
833: