View: EGO_DATA_LEVEL_VL

Product:	EGO - Advanced Product Catalog
Description:	This view gives the complete information of the data level metadata.
Implementation/DBA Data:	APPS.EGO_DATA_LEVEL_VL

View Text

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')

Columns