View: OE_PC_FKEY_COLS_V

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

View Text

SELECT FK.APPLICATION_ID
, FK.DATABASE_OBJECT_NAME DB_OBJECT_NAME
, 'VIEW' DB_OBJECT_TYPE
, FK.FOREIGN_KEY_NAME
, FKC.FOREIGN_KEY_SEQUENCE FK_COLUMN_SEQUENCE
, FAKOA.COLUMN_NAME FK_COLUMN_NAME
, FK.UNIQUE_KEY_NAME UNIQUE_KEY_NAME
, UK.APPLICATION_ID UK_APPLICATION_ID
, UK.DATABASE_OBJECT_NAME UK_DB_OBJECT_NAME
, UAKOA.COLUMN_NAME UK_COLUMN_NAME
FROM AK_FOREIGN_KEYS FK
, AK_FOREIGN_KEY_COLUMNS FKC
, AK_OBJECT_ATTRIBUTES FAKOA
, AK_UNIQUE_KEYS UK
, AK_UNIQUE_KEY_COLUMNS UKC
, AK_OBJECT_ATTRIBUTES UAKOA
WHERE FK.FOREIGN_KEY_NAME = FKC.FOREIGN_KEY_NAME
AND FKC.ATTRIBUTE_APPLICATION_ID = FAKOA.ATTRIBUTE_APPLICATION_ID
AND FKC.ATTRIBUTE_CODE = FAKOA.ATTRIBUTE_CODE
AND FK.DATABASE_OBJECT_NAME = FAKOA.DATABASE_OBJECT_NAME
AND FK.UNIQUE_KEY_NAME = UK.UNIQUE_KEY_NAME
AND UK.UNIQUE_KEY_NAME = UKC.UNIQUE_KEY_NAME
AND FKC.FOREIGN_KEY_SEQUENCE = UKC.UNIQUE_KEY_SEQUENCE
AND UKC.ATTRIBUTE_APPLICATION_ID = UAKOA.ATTRIBUTE_APPLICATION_ID
AND UKC.ATTRIBUTE_CODE = UAKOA.ATTRIBUTE_CODE
AND UK.DATABASE_OBJECT_NAME = UAKOA.DATABASE_OBJECT_NAME

Columns