Hotfix CM_8.5.0.6663 has fixed the logic of the EDA_SYSTEM_GETBLUEPRINT_ORG_ITEM store procedure so as the published statuses of the items are returned correctly.
As a side note, depending on where you run this statement, you might run into a syntax error around line 70. The problem is that this line ITM.FILE_NAME, needs to be ITM.[FILE_NAME], it is because FILE_NAME is a SQL function in some version of SQL Server Management Studio. |