VIEW: APPS.EDW_SEC_DIM_ACCESS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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