VIEW: APPS.BEN_EXT_FLD_VL

Source

View Text - Preformatted

SELECT a.rowid row_id, a.EXT_FLD_ID, a.DECD_FLAG, a.SHORT_NAME, nvl(t.NAME,a.name) Name , a.FRMT_MASK_TYP_CD, a.CSR_CD, a.LVL_CD, a.ALWD_IN_RCD_CD, a.BUSINESS_GROUP_ID, a.LAST_UPDATE_DATE, a.LAST_UPDATED_BY, a.LAST_UPDATE_LOGIN, a.CREATED_BY, a.CREATION_DATE, a.OBJECT_VERSION_NUMBER, a.LEGISLATION_CODE, a.GROUP_LVL_CD from ben_Ext_fld a,ben_ext_fld_tl t WHERE a.ext_fld_id = t.ext_fld_id (+) AND t.LANGUAGE (+) = userenv('LANG')

View Text - HTML Formatted

SELECT A.ROWID ROW_ID
, A.EXT_FLD_ID
, A.DECD_FLAG
, A.SHORT_NAME
, NVL(T.NAME
, A.NAME) NAME
, A.FRMT_MASK_TYP_CD
, A.CSR_CD
, A.LVL_CD
, A.ALWD_IN_RCD_CD
, A.BUSINESS_GROUP_ID
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
, A.CREATED_BY
, A.CREATION_DATE
, A.OBJECT_VERSION_NUMBER
, A.LEGISLATION_CODE
, A.GROUP_LVL_CD
FROM BEN_EXT_FLD A
, BEN_EXT_FLD_TL T
WHERE A.EXT_FLD_ID = T.EXT_FLD_ID (+)
AND T.LANGUAGE (+) = USERENV('LANG')