APPS.OE_LINE_STATUS_PUB dependencies on WSH_DELIVERY_DETAILS

Line 832: FROM wsh_delivery_details

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