1. Tables and Views for SCM
  2. DOO_PC_UKEY_COLS_V

DOO_PC_UKEY_COLS_V

Details

  • Schema: FUSION

  • Object owner: DOO

  • Object type: VIEW

Columns

Name

MODULE_ID

DB_OBJECT_NAME

DB_OBJECT_TYPE

UNIQUE_KEY_NAME

UK_COLUMN_NAME

Query

SQL_Statement

SELECT

uk.MODULE_ID,

uk.DATABASE_OBJECT_NAME db_object_name,

'VIEW' AS DB_OBJECT_TYPE,

uk.UNIQUE_KEY_NAME,

doa.COLUMN_NAME uk_column_name

FROM

DOO_UNIQUE_KEYS uk,

DOO_UNIQUE_KEY_COLUMNS ukc,

DOO_OBJECTS_B do,

DOO_OBJECT_ATTRIBUTES_B doa

WHERE

uk.MODULE_ID = do.MODULE_ID AND uk.DATABASE_OBJECT_NAME = do.DATABASE_OBJECT_NAME AND uk.UNIQUE_KEY_NAME = ukc.UNIQUE_KEY_NAME AND ukc.ATTRIBUTE_CODE = doa.ATTRIBUTE_CODE AND ukc.ATTRIBUTE_MODULE_ID = doa.MODULE_ID AND doa.DATABASE_OBJECT_NAME = uk.DATABASE_OBJECT_NAME