VIEW: APPS.EGO_DATA_LEVEL_VL

Source

View Text - Preformatted

SELECT B.DATA_LEVEL_ID AS DATA_LEVEL_ID ,B.APPLICATION_ID AS APPLICATION_ID ,B.ATTR_GROUP_TYPE AS ATTR_GROUP_TYPE ,B.DATA_LEVEL_NAME AS DATA_LEVEL_NAME ,TL.USER_DATA_LEVEL_NAME AS USER_DATA_LEVEL_NAME ,B.PK1_COLUMN_NAME AS PK1_COLUMN_NAME ,B.PK2_COLUMN_NAME AS PK2_COLUMN_NAME ,B.PK3_COLUMN_NAME AS PK3_COLUMN_NAME ,B.PK4_COLUMN_NAME AS PK4_COLUMN_NAME ,B.PK5_COLUMN_NAME AS PK5_COLUMN_NAME ,B.PK1_COLUMN_TYPE AS PK1_COLUMN_TYPE ,B.PK2_COLUMN_TYPE AS PK2_COLUMN_TYPE ,B.PK3_COLUMN_TYPE AS PK3_COLUMN_TYPE ,B.PK4_COLUMN_TYPE AS PK4_COLUMN_TYPE ,B.PK5_COLUMN_TYPE AS PK5_COLUMN_TYPE ,B.ENABLE_DEFAULTING AS ENABLE_DEFAULTING ,B.ENABLE_VIEW_PRIV AS ENABLE_VIEW_PRIV ,B.ENABLE_EDIT_PRIV AS ENABLE_EDIT_PRIV ,B.ENABLE_PRE_EVENT AS ENABLE_PRE_EVENT ,B.ENABLE_POST_EVENT AS ENABLE_POST_EVENT FROM EGO_DATA_LEVEL_B B, EGO_DATA_LEVEL_TL TL WHERE B.DATA_LEVEL_ID = TL.DATA_LEVEL_ID AND TL.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT B.DATA_LEVEL_ID AS DATA_LEVEL_ID
, B.APPLICATION_ID AS APPLICATION_ID
, B.ATTR_GROUP_TYPE AS ATTR_GROUP_TYPE
, B.DATA_LEVEL_NAME AS DATA_LEVEL_NAME
, TL.USER_DATA_LEVEL_NAME AS USER_DATA_LEVEL_NAME
, B.PK1_COLUMN_NAME AS PK1_COLUMN_NAME
, B.PK2_COLUMN_NAME AS PK2_COLUMN_NAME
, B.PK3_COLUMN_NAME AS PK3_COLUMN_NAME
, B.PK4_COLUMN_NAME AS PK4_COLUMN_NAME
, B.PK5_COLUMN_NAME AS PK5_COLUMN_NAME
, B.PK1_COLUMN_TYPE AS PK1_COLUMN_TYPE
, B.PK2_COLUMN_TYPE AS PK2_COLUMN_TYPE
, B.PK3_COLUMN_TYPE AS PK3_COLUMN_TYPE
, B.PK4_COLUMN_TYPE AS PK4_COLUMN_TYPE
, B.PK5_COLUMN_TYPE AS PK5_COLUMN_TYPE
, B.ENABLE_DEFAULTING AS ENABLE_DEFAULTING
, B.ENABLE_VIEW_PRIV AS ENABLE_VIEW_PRIV
, B.ENABLE_EDIT_PRIV AS ENABLE_EDIT_PRIV
, B.ENABLE_PRE_EVENT AS ENABLE_PRE_EVENT
, B.ENABLE_POST_EVENT AS ENABLE_POST_EVENT
FROM EGO_DATA_LEVEL_B B
, EGO_DATA_LEVEL_TL TL
WHERE B.DATA_LEVEL_ID = TL.DATA_LEVEL_ID
AND TL.LANGUAGE = USERENV('LANG')