Public Interface Export Function › Planning Objects › Planning Tasks › CURRENT_INFO_SYS (Current Information System) › Task

Task

Select the current information systems along the X axis of the matrix BUS_FUNCTION/CUR_INFO_SYSTEM. Order by current information system as specified in the toolset.

SELECT MT.NAME, X.NAME. UX.SEQ
  FROM
  MODEL M,
  MATRIX MT,
  MATRIX_USAGE_X UX,
  CURRENT_INFO_SYS X
  WHERE
  M.NAME = 'my model name'
  AND UX.MODEL_ID = M.ID
  AND UX.MATRIX_ID = MT.ID
  AND MT.NAME = 'BUS_FUNCTION/CUR._INFO_SYSTEM'
  AND UX.OBJECT_ID = X.ID
ORDER BY MT.NAME, UX.SEQ;