DBA Data[Home] [Help]

VIEW: APPS.BNE_PERF_SETS_VL

Source

View Text - Preformatted

SELECT P.ROWID ROW_ID, P.SET_CODE, P.OBJECT_VERSION_NUMBER, P.ENABLED_FLAG, T.USER_NAME, P.CREATED_BY, P.CREATION_DATE, P.LAST_UPDATED_BY, P.LAST_UPDATE_LOGIN, P.LAST_UPDATE_DATE FROM BNE_PERF_SETS_B P, BNE_PERF_SETS_TL T WHERE P.SET_CODE = T.SET_CODE AND T.LANGUAGE = USERENV('LANG')
View Text - HTML Formatted

SELECT P.ROWID ROW_ID
, P.SET_CODE
, P.OBJECT_VERSION_NUMBER
, P.ENABLED_FLAG
, T.USER_NAME
, P.CREATED_BY
, P.CREATION_DATE
, P.LAST_UPDATED_BY
, P.LAST_UPDATE_LOGIN
, P.LAST_UPDATE_DATE
FROM BNE_PERF_SETS_B P
, BNE_PERF_SETS_TL T
WHERE P.SET_CODE = T.SET_CODE
AND T.LANGUAGE = USERENV('LANG')