FND Design Data [Home] [Help]

View: EDW_UNIQUE_KEY_COLUMNS_MD_V

Product: BIS - Applications BIS
Description: EDW_UNIQUE_KEY_COLUMNS_MD_V
Implementation/DBA Data: ViewAPPS.EDW_UNIQUE_KEY_COLUMNS_MD_V
View Text

SELECT PK.ELEMENTID
, PK.NAME
, FK_ITEM.ELEMENTID
, FK_ITEM.NAME
FROM CMPWBITEMSETUSAGE_V FKISU
, CMPITEM_V FK_ITEM
, CMPUNIQUEKEY_V PK
WHERE FKISU.ITEMSET=PK.ELEMENTID
AND FK_ITEM.ELEMENTID=FKISU.ATTRIBUTE WITH READ ONLY

Columns

Name
KEY_ID
KEY_NAME
COLUMN_ID
COLUMN_NAME