VIEW: APPS.OE_DEF_AK_UKEY_COLS_V

Source

View Text - Preformatted

SELECT a.attribute_code, b.column_name, b.data_type, b.database_object_name, a.unique_key_name, a.unique_key_sequence, a.attribute_application_id from ak_object_attributes_Vl b,ak_unique_key_columns a WHERE b.attribute_code = a.attribute_code and b.attribute_application_id = a.attribute_application_id

View Text - HTML Formatted

SELECT A.ATTRIBUTE_CODE
, B.COLUMN_NAME
, B.DATA_TYPE
, B.DATABASE_OBJECT_NAME
, A.UNIQUE_KEY_NAME
, A.UNIQUE_KEY_SEQUENCE
, A.ATTRIBUTE_APPLICATION_ID
FROM AK_OBJECT_ATTRIBUTES_VL B
, AK_UNIQUE_KEY_COLUMNS A
WHERE B.ATTRIBUTE_CODE = A.ATTRIBUTE_CODE
AND B.ATTRIBUTE_APPLICATION_ID = A.ATTRIBUTE_APPLICATION_ID