Public Interface Export Function › Planning Objects › Planning Tasks › ORGANIZAT_UNIT (Organizational Unit) › Task

Task

Select the organizational units along the X axis of the matrix BUSINESS_FUNCTION/ORG_UNIT. Order by organizational unit as specified in the toolset.

SELECT MT.NAME, X.NAME. UX.SEQ
FROM
MODEL M,
MATRIX MT,
MATRIX_USAGE_X UX,
ORGANIZAT_UNIT X
WHERE
M.NAME = ‘my model name’
AND UX.MODEL_ID = M.ID
AND UX.MATRIX_ID = MT.ID
AND MT.NAME = ‘BUSINESS_FUNCTION/ORG_UNIT’
AND UX.OBJECT_ID = X.ID
ORDER BY MT.NAME, UX.SEQ;