DBA Data[Home] [Help]

VIEW: APPS.IEC_P_RES_GRP_PARAMS_VL

Source

View Text - Preformatted

SELECT B.RES_GROUP_PARAM_ID, B.VDU_TYPE_ID, B.PARAM_CODE, B.LOOKUP_TYPE, T.PARAM_NAME, T.PARAM_DESCRIPTION, B.VALUE_TYPE, B.VALUE_LENGTH, B.REQUIRED, B.DEFAULT_VALUE FROM IEC_P_RES_GRP_PARAMS_B B, IEC_P_RES_GRP_PARAMS_TL T WHERE LANGUAGE = USERENV('LANG') AND B.RES_GROUP_PARAM_ID = T.RES_GROUP_PARAM_ID
View Text - HTML Formatted

SELECT B.RES_GROUP_PARAM_ID
, B.VDU_TYPE_ID
, B.PARAM_CODE
, B.LOOKUP_TYPE
, T.PARAM_NAME
, T.PARAM_DESCRIPTION
, B.VALUE_TYPE
, B.VALUE_LENGTH
, B.REQUIRED
, B.DEFAULT_VALUE
FROM IEC_P_RES_GRP_PARAMS_B B
, IEC_P_RES_GRP_PARAMS_TL T
WHERE LANGUAGE = USERENV('LANG')
AND B.RES_GROUP_PARAM_ID = T.RES_GROUP_PARAM_ID