SELECT UNIQUE ENG.REVISED_ITEM_ID , ENG.ORGANIZATION_ID , POL.PO_HEADER_ID FROM ENG_WEB_SCHEDULE_V ENG, PO_LINES POL WHERE ENG.REVISED_ITEM_ID = POL.ITEM_ID AND pol.closed_code = 'OPEN' AND pol.cancel_flag = 'N'
View Text - HTML Formatted
SELECT UNIQUE ENG.REVISED_ITEM_ID , ENG.ORGANIZATION_ID , POL.PO_HEADER_ID FROM ENG_WEB_SCHEDULE_V ENG , PO_LINES POL WHERE ENG.REVISED_ITEM_ID = POL.ITEM_ID AND POL.CLOSED_CODE = 'OPEN' AND POL.CANCEL_FLAG = 'N'