select /*+ ALL_ROWS */ ITEM_P2P3_QUERY.ID,ITEM_P2P3_QUERY.CLASS,ITEM_P2P3_QUERY.SUBCLASS,ITEM_P2P3_QUERY.FLAGS,ITEM_P2P3_QUERY.REV_FLAGS,NULL,NULL,ITEM_P2P3_QUERY.ITEM_NUMBER,ITEM_P2P3_QUERY.ITEM_NUMBER,BOM.ITEM_NUMBER,BOM.COMPONENT,MANU_PARTS_P2.PART_NUMBER,BOM.ITEM_NUMBER,BOM.COMPONENT,MANUFACTURERS_P2.NAME,MANU_PARTS_P2.PART_NUMBER,ITEM_P2P3_QUERY.PRODUCT_LINES,ITEM_P2P3_QUERY.MULTILIST02,ITEM_P2P3_QUERY.CATEGORY,ITEM_P2P3_QUERY.MULTILIST01,ITEM_P2P3_QUERY.DESCRIPTION,ITEM_P2P3_QUERY.DESC_REV,ITEM_P2P3_QUERY.LATEST_FLAG,ITEM_P2P3_QUERY.MULTILIST04,ITEM_P2P3_QUERY.ITEM_NUMBER,MANUFACTURERS_P2.NAME,ITEM_P2P3_QUERY.MULTILIST03,ITEM_P2P3_QUERY.RELEASE_TYPE,ITEM_P2P3_QUERY.LIST12,ITEM_P2P3_QUERY.LIST08,ITEM_P2P3_QUERY.CREATE_USER,ITEM_P2P3_QUERY.CREATE_USER,NULL,NULL,ITEM_P2P3_QUERY.ITEM_NUMBER from ITEM_P2P3_QUERY,BOM,MANU_PARTS_P2,MANUFACTURERS_P2,MANU_BY where (( ITEM_P2P3_QUERY.RELEASE_DATE IS NOT NULL) AND ITEM_P2P3_QUERY.ITEM_NUMBER LIKE ‘%XXXXXX%’ ESCAPE ‘\’) AND ITEM_P2P3_QUERY.CLASS = 10000 AND (NVL(ITEM_P2P3_QUERY.DELETE_FLAG,0) = 0) AND ITEM_P2P3_QUERY.ID = MANU_BY.AGILE_PART(+) AND 1 = MANU_BY.ACTIVE AND MANU_BY.MANU_PART = MANU_PARTS_P2.ID(+) AND ITEM_P2P3_QUERY.ID = MANU_BY.AGILE_PART(+) AND 1 = MANU_BY.ACTIVE AND MANU_BY.MANU_PART = MANU_PARTS_P2.ID(+) AND MANU_PARTS_P2.MANU_ID = MANUFACTURERS_P2.ID(+) AND BOM.ITEM(+) = ITEM_P2P3_QUERY.ID AND BOM.CHANGE_OUT(+) = 0 AND BOM.FLAGS(+) LIKE ‘00011%’ ORDER BY 35;