DBA Data[Home] [Help]

VIEW: APPS.IEC_P_RES_GRP_TYPES_VL

Source

View Text - Preformatted

SELECT B.RES_GROUP_TYPE_ID, B.VDU_TYPE_ID, B.PORTS_PER_GROUP, T.RES_GROUP_TYPE_NAME, T.RES_GROUP_TYPE_DESCRIPTION FROM IEC_P_RES_GRP_TYPES_B B, IEC_P_RES_GRP_TYPES_TL T WHERE LANGUAGE = USERENV('LANG') AND B.RES_GROUP_TYPE_ID = T.RES_GROUP_TYPE_ID
View Text - HTML Formatted

SELECT B.RES_GROUP_TYPE_ID
, B.VDU_TYPE_ID
, B.PORTS_PER_GROUP
, T.RES_GROUP_TYPE_NAME
, T.RES_GROUP_TYPE_DESCRIPTION
FROM IEC_P_RES_GRP_TYPES_B B
, IEC_P_RES_GRP_TYPES_TL T
WHERE LANGUAGE = USERENV('LANG')
AND B.RES_GROUP_TYPE_ID = T.RES_GROUP_TYPE_ID