DBA Data[Home] [Help]

VIEW: APPS.IBY_VALIDATION_SETS_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.VALIDATION_SET_CODE, B.VALIDATION_LEVEL_CODE, B.VALIDATION_CODE_PACKAGE, B.VALIDATION_CODE_ENTRY_POINT, B.VALIDATION_CODE_LANGUAGE, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, T.VALIDATION_SET_DISPLAY_NAME from IBY_VALIDATION_SETS_TL T, IBY_VALIDATION_SETS_B B where B.VALIDATION_SET_CODE = T.VALIDATION_SET_CODE and T.LANGUAGE = userenv('LANG')
View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.VALIDATION_SET_CODE
, B.VALIDATION_LEVEL_CODE
, B.VALIDATION_CODE_PACKAGE
, B.VALIDATION_CODE_ENTRY_POINT
, B.VALIDATION_CODE_LANGUAGE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
, T.VALIDATION_SET_DISPLAY_NAME
FROM IBY_VALIDATION_SETS_TL T
, IBY_VALIDATION_SETS_B B
WHERE B.VALIDATION_SET_CODE = T.VALIDATION_SET_CODE
AND T.LANGUAGE = USERENV('LANG')