Siebel SQLs/Error Messages >  Get all screens and views for a Responsibility in Siebel

Get all screens and views for a Responsibility in Siebel

You need to change the words 'Responsibility Name' to an actual Responsibility e.g. 'Siebel Administrator'

 

SELECT
  scr.NAME,
  NVL(scritemloc.MENU_TEXT, scritemlocref.STRING_VALUE),
  scrv.SCRN_VW_TYPE_CD,
  scrv.PAR_CATEGORY,
  v.NAME,
  NVL(scrvloc.MENU_TEXT, scrvlocref.STRING_VALUE)
  FROM
  (
  SELECT
  v.NAME
  FROM
  siebel.S_RESP resp
  JOIN siebel.S_APP_VIEW_RESP respv ON respv.RESP_ID = resp.ROW_ID
  JOIN siebel.S_APP_VIEW v ON v.ROW_ID = respv.VIEW_ID
  WHERE
  resp.NAME IN ('Responsibility Name')
  GROUP BY v.NAME
  ) v
  JOIN siebel.S_SCREEN_VIEW scrv ON scrv.NAME = v.NAME AND scrv.INACTIVE_FLG = 'N'
  LEFT JOIN S_SCR_VIEW_INTL scrvloc ON scrvloc.SCREEN_VIEW_ID = scrv.ROW_ID AND scrvloc.LANG_CD = 'RUS'
  LEFT JOIN S_SYM_STR_INTL scrvlocref ON scrvlocref.SYM_STR_KEY = scrv.MENU_TEXT_REF AND scrvlocref.REPOSITORY_ID = scrv.REPOSITORY_ID AND scrvlocref.LANG_CD = 'RUS'
   
  JOIN siebel.S_REPOSITORY rep ON rep.ROW_ID = scrv.REPOSITORY_ID
  JOIN siebel.S_SCREEN scr ON scr.ROW_ID = scrv.SCREEN_ID AND scr.INACTIVE_FLG = 'N'
  JOIN siebel.S_SCR_MENU_ITEM scritem ON scritem.SCREEN_NAME = scr.NAME AND scritem.REPOSITORY_ID = scrv.REPOSITORY_ID AND scritem.INACTIVE_FLG = 'N'
  JOIN siebel.S_APPLICATION appl ON appl.ROW_ID = scritem.APPLICATION_ID
  LEFT JOIN S_SCR_MITM_INTL scritemloc ON scritemloc.SCREEN_MENU_IT_ID = scritem.ROW_ID AND scritemloc.LANG_CD = 'RUS'
  LEFT JOIN S_SYM_STR_INTL scritemlocref ON scritemlocref.SYM_STR_KEY = TEXT_REF AND scritemlocref.REPOSITORY_ID = scrv.REPOSITORY_ID AND scritemlocref.LANG_CD = 'RUS'
  WHERE
  rep.NAME = 'Siebel Repository'
  AND
  appl.NAME = 'Siebel Financial Services'
  AND
  scr.NAME = 'Accounts Screen'
  --GROUP BY scr.NAME, scritemloc.MENU_TEXT, scritemlocref.STRING_VALUE
  ORDER BY scr.NAME, scrv.SCRN_VW_TYPE_CD, scrv.PAR_CATEGORY, v.NAME

   

Impressum und Datenschutz    Copyright ©2020 eir.me