View: OE_DEF_AK_FKEYS_V

Product:	ONT - Order Management
Description:
Implementation/DBA Data:	APPS.OE_DEF_AK_FKEYS_V

View Text

SELECT A.UNIQUE_KEY_NAME
, A.DATABASE_OBJECT_NAME
, A.APPLICATION_ID
, B.FOREIGN_KEY_NAME
, B.DATABASE_OBJECT_NAME
, D.ENTITY_CODE
, E.ENTITY_CODE
FROM AK_UNIQUE_KEYS A
, AK_FOREIGN_KEYS B
, OE_AK_OBJECTS_EXT D
, OE_AK_OBJECTS_EXT E
WHERE A.APPLICATION_ID=B.APPLICATION_ID
AND A.UNIQUE_KEY_NAME=B.UNIQUE_KEY_NAME
AND A.DATABASE_OBJECT_NAME=D.DATABASE_OBJECT_NAME
AND A.DATABASE_OBJECT_NAME=E.DATABASE_OBJECT_NAME
AND D.ENTITY_CODE IS NOT NULL

Columns