SELECT PARA.ORGANIZATION_CODE , ORG.NAME , BILL.BILL_OF_RESOURCES , '_KF:INV:MSTK:ITEM' , '_DF:CRP:CRP_BILL_OF_RESOURCE_ITEMS:BILL' , BILL.ORGANIZATION_ID , BILL.INVENTORY_ITEM_ID , BILL.LAST_UPDATE_DATE , BILL.LAST_UPDATED_BY , BILL.CREATION_DATE , BILL.CREATED_BY FROM MTL_PARAMETERS PARA , HR_ALL_ORGANIZATION_UNITS ORG , MTL_SYSTEM_ITEMS ITEM , CRP_BILLS_OF_RESOURCES BILLRES , CRP_BILL_OF_RESOURCE_ITEMS BILL WHERE PARA.ORGANIZATION_ID = BILL.ORGANIZATION_ID AND ORG.ORGANIZATION_ID = BILL.ORGANIZATION_ID AND ITEM.ORGANIZATION_ID = BILL.ORGANIZATION_ID AND ITEM.INVENTORY_ITEM_ID = BILL.INVENTORY_ITEM_ID AND BILLRES.ORGANIZATION_ID = BILL.ORGANIZATION_ID AND BILLRES.BILL_OF_RESOURCES = BILL.BILL_OF_RESOURCES AND '_SEC:BILL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY