1. Tables and Views for SCM
  2. DOO_PC_ATTRIBUTES_V

DOO_PC_ATTRIBUTES_V

Details

  • Schema: FUSION

  • Object owner: DOO

  • Object type: VIEW

Columns

Name

MODULE_ID

ENTITY_ID

DATABASE_OBJECT_NAME

DB_OBJECT_TYPE

ATTRIBUTE_CODE

ATTRIBUTE_ID

COLUMN_NAME

ATTRIBUTE_LABEL_LONG

CONSTRAINTS_ENABLED_FLAG

CONSTRAINT_CONDN_REF_FLAG

STATE_ATTRIBUTE_FLAG

ATTRIBUTE_LABEL_LENGTH

DATA_TYPE

DATA_SOURCE_TYPE

DATA_STORAGE_TYPE

EFF_CONTEXT_CODE

Query

SQL_Statement

SELECT

doooat.MODULE_ID,

doooat.ENTITY_ID,

doooat.DATABASE_OBJECT_NAME,

'VIEW' DB_OBJECT_TYPE,

dooattr.ATTRIBUTE_CODE,

dooattr.ATTRIBUTE_ID,

doooat.COLUMN_NAME column_name,

dooattrtl.ATTRIBUTE_LABEL_LONG,

doooat.CONSTRAINTS_ENABLED_FLAG,

doooat.CONSTRAINT_CONDN_REF_FLAG,

doooat.STATE_ATTRIBUTE_FLAG,

doooat.ATTRIBUTE_LABEL_LENGTH,

dooattr.DATA_TYPE,

doooat.DATA_SOURCE_TYPE,

doooat.DATA_STORAGE_TYPE,

doooat.EFF_CONTEXT_CODE

FROM

DOO_OBJECT_ATTRIBUTES_B doooat,

DOO_ATTRIBUTES_B dooattr,

DOO_ATTRIBUTES_TL dooattrtl

WHERE

doooat.MODULE_ID = dooattr.MODULE_ID AND doooat.ATTRIBUTE_ID = dooattr.ATTRIBUTE_ID AND dooattrtl.ATTRIBUTE_ID = doooat.ATTRIBUTE_ID AND dooattrtl.LANGUAGE = USERENV('LANG')