View: EDW_PVT_COLUMNS_MD_V

Product:	BIS - Applications BIS
Description:	EDW_PVT_COLUMNS_MD_V
Implementation/DBA Data:	APPS.EDW_PVT_COLUMNS_MD_V

View Text

SELECT ITEM.ELEMENTID COLUMN_ID
, ITEM.NAME COLUMN_NAME
, ITEM.OWNINGRELATION PARENT_OBJECT_ID
, DATA.NAME DATA_TYPE
, ITEM.LENGTH LENGTH
, ITEM.LONGNAME LOGICAL_NAME
, ITEM.DESCRIPTION DESCRIPTION
FROM CMPITEM_V ITEM
, CMPDATATYPE_V DATA
WHERE DATA.ELEMENTID=ITEM.DOMAIN

Columns