SELECT DISTINCT PARA.ORGANIZATION_CODE , ORG.NAME , ROUTING.COMPILE_DESIGNATOR , '_KF:INV:MSTK:ITEM' , ROUTING.ALTERNATE_ROUTING_DESIGNATOR , LINE.LINE_CODE , ROUTING.ORGANIZATION_ID , ROUTING.USING_ASSEMBLY_ITEM_ID , ROUTING.LINE_ID FROM MTL_PARAMETERS PARA , HR_ALL_ORGANIZATION_UNITS ORG , MTL_SYSTEM_ITEMS ITEM , MRP_PLANNED_RESOURCE_REQS ROUTING , WIP_LINES LINE , MRP_SYSTEM_ITEMS MRPITEM WHERE PARA.ORGANIZATION_ID = ROUTING.ORGANIZATION_ID AND ORG.ORGANIZATION_ID = ROUTING.ORGANIZATION_ID AND LINE.LINE_ID(+) = ROUTING.LINE_ID AND ROUTING.ORGANIZATION_ID = MRPITEM.ORGANIZATION_ID AND ROUTING.COMPILE_DESIGNATOR = MRPITEM.COMPILE_DESIGNATOR AND ROUTING.USING_ASSEMBLY_ITEM_ID = MRPITEM.INVENTORY_ITEM_ID AND ITEM.ORGANIZATION_ID = ROUTING.ORGANIZATION_ID AND ITEM.INVENTORY_ITEM_ID = ROUTING.USING_ASSEMBLY_ITEM_ID AND '_SEC:ROUTING.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY