SELECT B.ROWID ROW_ID, B.VIEW_ID, B.PARENT_VIEW_ID, B.VIEW_KEY, B.VIEW_TYPE, B.APPLICATION_MODULE, B.AM_IMPL_CLASS, B.AM_IMPL_METHOD, B.VO_IMPL_CLASS,
B.VO_IMPL_METHOD, B.VO_INSTANCE, B.PLSQL_API, B.SQL_TEXT, B.CUSTOMIZATION_LEVEL, B.SEQUENCE, B.STATUS, T.TITLE,
T.DESCRIPTION, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.SECURITY_GROUP_ID
FROM WF_WL_VIEWS B, WF_WL_VIEWS_TL T
WHERE B.VIEW_ID = T.VIEW_ID AND T.LANGUAGE = USERENV('LANG')
SELECT B.ROWID ROW_ID
, B.VIEW_ID
, B.PARENT_VIEW_ID
, B.VIEW_KEY
, B.VIEW_TYPE
, B.APPLICATION_MODULE
, B.AM_IMPL_CLASS
, B.AM_IMPL_METHOD
, B.VO_IMPL_CLASS
,
B.VO_IMPL_METHOD
, B.VO_INSTANCE
, B.PLSQL_API
, B.SQL_TEXT
, B.CUSTOMIZATION_LEVEL
, B.SEQUENCE
, B.STATUS
, T.TITLE
,
T.DESCRIPTION
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.SECURITY_GROUP_ID
FROM WF_WL_VIEWS B
, WF_WL_VIEWS_TL T
WHERE B.VIEW_ID = T.VIEW_ID
AND T.LANGUAGE = USERENV('LANG')
|
|
|