eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: EDW_ALL_COLUMNS_MD_V

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

View Text

SELECT REL.ELEMENTID
, REL.CLASSNAME
, REL.NAME
, ITEM.ELEMENTID
, ITEM.NAME
, ITEM.LONGNAME
, ITEM.DESCRIPTION
, ITEM.POSITION
, DATA.NAME
, ITEM.LENGTH
FROM CMPITEM_V ITEM
, CMPRELATION_V REL
, CMPDATATYPE_V DATA
WHERE ITEM.OWNINGRELATION = REL.ELEMENTID
AND ITEM.DOMAIN = DATA.ELEMENTID WITH READ ONLY

Columns

Name
ENTITY_ID
ENTITY_TYPE
ENTITY_NAME
COLUMN_ID
COLUMN_NAME
BUSINESS_NAME
DESCRIPTION
POSITION
DATA_TYPE
LENGTH