eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: EDW_SEC_DIM_ACCESS_V

Product:	BIS - Applications BIS
Description:	EDW_SEC_DIM_ACCESS_V
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT DISTINCT /* ADDED DUE TO PROBLEM WITH QUERY LIKE '%' */ EDW.RESP_ID RESP_ID
, EDW.ROWID
, EDW.DIM_ID DIM_ID
, EDW.LEVEL_ID LEVEL_ID
, RESP.RESPONSIBILITY_NAME RESPONSIBILITY
, APPN.APPLICATION_NAME APPLICATION
, DIM.DIM_LONG_NAME DIMENSION
, LVL.LEVEL_LONG_NAME LEVEL_NAME
, EDW.ACCESS_VALUE ACCESS_VALUE
, EDW.CREATION_DATE CREATION_DATE
, EDW.CREATED_BY CREATED_BY
, EDW.LAST_UPDATE_DATE LAST_UPDATE_DATE
, EDW.LAST_UPDATED_BY LAST_UPDATED_BY
, EDW.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, EDW.DIM_SHORT_NAME DIM_SHORT_NAME
, EDW.LEVEL_SHORT_NAME LEVEL_SHORT_NAME
FROM EDW_SEC_DIM_ACCESS EDW
, FND_RESPONSIBILITY_VL RESP
, FND_APPLICATION_VL APPN
, EDW_SEC_DIM_INFO_V DIM
, EDW_SEC_LVL_INFO_V LVL
WHERE EDW.RESP_ID = RESP.RESPONSIBILITY_ID
AND RESP.APPLICATION_ID = APPN.APPLICATION_ID
AND EDW.LEVEL_ID = LVL.LEVEL_ID
AND EDW.DIM_ID = DIM.DIM_ID
AND DIM.DIM_ID = LVL.DIM_ID

Columns

Name
RESP_ID
ROW_ID
DIM_ID
LEVEL_ID
RESPONSIBILITY
APPLICATION
DIMENSION
LEVEL_NAME
ACCESS_VALUE
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
DIM_SHORT_NAME
LEVEL_SHORT_NAME