View: OE_PC_UKEY_COLS_V

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

View Text

SELECT UK.APPLICATION_ID
, UK.DATABASE_OBJECT_NAME DB_OBJECT_NAME
, 'VIEW' DB_OBJECT_TYPE
, UK.UNIQUE_KEY_NAME
, DECODE (AKO.PRIMARY_KEY_NAME
, UK.UNIQUE_KEY_NAME
, 'Y'
, 'N') PRIMARY_KEY_FLAG
, UKC.UNIQUE_KEY_SEQUENCE UK_COLUMN_SEQUENCE
, AKOA.COLUMN_NAME UK_COLUMN_NAME
FROM AK_UNIQUE_KEYS UK
, AK_UNIQUE_KEY_COLUMNS UKC
, AK_OBJECTS AKO
, AK_OBJECT_ATTRIBUTES AKOA
WHERE UK.APPLICATION_ID = AKO.APPLICATION_ID
AND UK.DATABASE_OBJECT_NAME = AKO.DATABASE_OBJECT_NAME
AND UK.UNIQUE_KEY_NAME = UKC.UNIQUE_KEY_NAME
AND UKC.ATTRIBUTE_CODE = AKOA.ATTRIBUTE_CODE
AND UKC.ATTRIBUTE_APPLICATION_ID = AKOA.ATTRIBUTE_APPLICATION_ID
AND AKOA.DATABASE_OBJECT_NAME = UK.DATABASE_OBJECT_NAME

Columns