Find Departments And Associated Locations

Products

• Clarity PPM On Premise

Issue/Introduction

Are there any queries to review an entity's department and location associations?

Resolution

Here are the queries to be used to review entity departments and locations

SELECT 
b.id, b.entity, a.LOCN_ID, a.LOCATIONID, a.DEPT_ID, departcode
FROM 
LOCATIONDEPT a,
ENTITY b
WHERE a.dept_id = b.id
ORDER BY a.LOCN_ID