FND Design Data [Home] [Help]

View: OE_DEF_AK_FKEY_COLS_V

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

SELECT A.ATTRIBUTE_CODE
, B.COLUMN_NAME
, B.DATABASE_OBJECT_NAME
, A.FOREIGN_KEY_NAME
, A.FOREIGN_KEY_SEQUENCE
, A.ATTRIBUTE_APPLICATION_ID
FROM AK_OBJECT_ATTRIBUTES B
, AK_FOREIGN_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
DATABASE_OBJECT_NAME
FOREIGN_KEY_NAME
FOREIGN_KEY_SEQUENCE
ATTRIBUTE_APPLICATION_ID