FND Design Data [Home] [Help]

View: OE_DEF_AK_UKEY_COLS_V

Product: ONT - Order Management
Description:
Implementation/DBA Data: ViewAPPS.OE_DEF_AK_UKEY_COLS_V
View Text

SELECT A.ATTRIBUTE_CODE
, B.COLUMN_NAME
, B.DATA_TYPE
, B.DATABASE_OBJECT_NAME
, A.UNIQUE_KEY_NAME
, A.UNIQUE_KEY_SEQUENCE
, A.ATTRIBUTE_APPLICATION_ID
FROM AK_OBJECT_ATTRIBUTES_VL B
, AK_UNIQUE_KEY_COLUMNS A
WHERE B.ATTRIBUTE_CODE = A.ATTRIBUTE_CODE
AND B.ATTRIBUTE_APPLICATION_ID = A.ATTRIBUTE_APPLICATION_ID

Columns

Name
ATTRIBUTE_CODE
COLUMN_NAME
DATA_TYPE
DATABASE_OBJECT_NAME
UNIQUE_KEY_NAME
UNIQUE_KEY_SEQUENCE
ATTRIBUTE_APPLICATION_ID