VIEW: APPS.OE_PC_UKEY_COLS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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