FND Design Data [Home] [Help]

View: OE_PC_FKEYS_V

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

SELECT FK.APPLICATION_ID
, FK.DATABASE_OBJECT_NAME DB_OBJECT_NAME
, 'VIEW' DB_OBJECT_TYPE
, FK.FOREIGN_KEY_NAME
, FK.UNIQUE_KEY_NAME UNIQUE_KEY_NAME
, UK.APPLICATION_ID UK_APPLICATION_ID
, UK.DATABASE_OBJECT_NAME UK_DB_OBJECT_NAME
FROM AK_FOREIGN_KEYS FK
, AK_UNIQUE_KEYS UK
WHERE FK.UNIQUE_KEY_NAME = UK.UNIQUE_KEY_NAME

Columns

Name
APPLICATION_ID
DB_OBJECT_NAME
DB_OBJECT_TYPE
FOREIGN_KEY_NAME
UNIQUE_KEY_NAME
UK_APPLICATION_ID
UK_DB_OBJECT_NAME