SELECT distinct cycle_id, 'OEOH' from so_headers_all WHERE nvl(open_flag,'-') = 'Y' union select distinct cycle_id, 'OEOL' from so_lines_all where nvl(open_flag,'-') = 'Y'
View Text - HTML Formatted
SELECT DISTINCT CYCLE_ID , 'OEOH' FROM SO_HEADERS_ALL WHERE NVL(OPEN_FLAG , '-') = 'Y' UNION SELECT DISTINCT CYCLE_ID , 'OEOL' FROM SO_LINES_ALL WHERE NVL(OPEN_FLAG , '-') = 'Y'