SELECT DISTINCT PARA.ORGANIZATION_CODE , ORG.NAME , MRPBOM.COMPILE_DESIGNATOR , MRPBOM.ALTERNATE_BOM_DESIGNATOR , '_KF:INV:MSTK:SYSITEM' , MRPBOM.ORGANIZATION_ID , MRPBOM.USING_ASSEMBLY_ID , COMP.BILL_SEQUENCE_ID FROM HR_ALL_ORGANIZATION_UNITS ORG , MTL_PARAMETERS PARA , BOM_INVENTORY_COMPONENTS COMP , MTL_SYSTEM_ITEMS SYSITEM , MRP_SYSTEM_ITEMS MRPITEM , MRP_BOM_COMPONENTS MRPBOM WHERE MRPBOM.ORGANIZATION_ID = MRPITEM.ORGANIZATION_ID AND MRPBOM.COMPILE_DESIGNATOR = MRPITEM.COMPILE_DESIGNATOR AND MRPBOM.USING_ASSEMBLY_ID = MRPITEM.INVENTORY_ITEM_ID AND MRPBOM.ORGANIZATION_ID = SYSITEM.ORGANIZATION_ID AND MRPBOM.USING_ASSEMBLY_ID = SYSITEM.INVENTORY_ITEM_ID AND MRPBOM.COMPONENT_SEQUENCE_ID = COMP.COMPONENT_SEQUENCE_ID AND MRPBOM.ORGANIZATION_ID = PARA.ORGANIZATION_ID AND MRPBOM.ORGANIZATION_ID = ORG.ORGANIZATION_ID AND '_SEC:MRPBOM.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY