DBA Data[Home] [Help]

VIEW: APPS.OKL_PARAMETERS_V

Source

View Text - Preformatted

SELECT PMRB.rowid ROW_ID, PMRB.ID ID, PMRB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PMRT.SFWT_FLAG SFWT_FLAG, PMRB.CUSTOMIZATION_LEVEL CUSTOMIZATION_LEVEL, PMRB.NAME NAME, PMRB.DATATYPE DATATYPE, PMRT.DESCRIPTION DESCRIPTION, PMRB.CREATED_BY CREATED_BY, PMRB.CREATION_DATE CREATION_DATE, PMRB.LAST_UPDATED_BY LAST_UPDATED_BY, PMRB.LAST_UPDATE_DATE LAST_UPDATE_DATE, PMRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM OKL_PARAMETERS_B PMRB,OKL_PARAMETERS_TL PMRT WHERE PMRB.ID = PMRT.ID and PMRT.LANGUAGE = USERENV('LANG')
View Text - HTML Formatted

SELECT PMRB.ROWID ROW_ID
, PMRB.ID ID
, PMRB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PMRT.SFWT_FLAG SFWT_FLAG
, PMRB.CUSTOMIZATION_LEVEL CUSTOMIZATION_LEVEL
, PMRB.NAME NAME
, PMRB.DATATYPE DATATYPE
, PMRT.DESCRIPTION DESCRIPTION
, PMRB.CREATED_BY CREATED_BY
, PMRB.CREATION_DATE CREATION_DATE
, PMRB.LAST_UPDATED_BY LAST_UPDATED_BY
, PMRB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PMRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_PARAMETERS_B PMRB
, OKL_PARAMETERS_TL PMRT
WHERE PMRB.ID = PMRT.ID
AND PMRT.LANGUAGE = USERENV('LANG')