SELECT UNIQUE ENG.REVISED_ITEM_ID , ENG.ORGANIZATION_ID , SOL.HEADER_ID FROM ENG_WEB_SCHEDULE_V ENG, SO_LINES SOL WHERE ENG.REVISED_ITEM_ID = SOL.INVENTORY_ITEM_ID AND sol.open_flag = 'Y'
View Text - HTML Formatted
SELECT UNIQUE ENG.REVISED_ITEM_ID , ENG.ORGANIZATION_ID , SOL.HEADER_ID FROM ENG_WEB_SCHEDULE_V ENG , SO_LINES SOL WHERE ENG.REVISED_ITEM_ID = SOL.INVENTORY_ITEM_ID AND SOL.OPEN_FLAG = 'Y'