1. Tables and Views for SCM
  2. DOO_PC_ENTITIES_V

DOO_PC_ENTITIES_V

Details

  • Schema: FUSION

  • Object owner: DOO

  • Object type: VIEW

Columns

Name

DATABASE_OBJECT_NAME

OBJECT_VERSION_NUMBER

DATABASE_OBJECT_TYPE

ENTITY_ID

PROCESS_NAME

TASK_ID

SERVICE_ID

ENTITY_CODE

CONSTRAINTS_ENABLED_FLAG

DATABASE_OBJECT_CODE

MODULE_ID

SOURCE_LANG

LANGUAGE

DESCRIPTION

SYSTEM_FLAG

Query

SQL_Statement

SELECT

dooobjb.DATABASE_OBJECT_NAME,

dooobjb.OBJECT_VERSION_NUMBER,

dooobjb.DATABASE_OBJECT_TYPE,

dooobjb.ENTITY_ID,

dooobjb.PROCESS_NAME,

dooobjb.TASK_ID,

dooobjb.SERVICE_ID,

dooobjb.ENTITY_CODE,

dooobjb.CONSTRAINTS_ENABLED_FLAG,

dooobjb.DATABASE_OBJECT_CODE,

dooobjb.MODULE_ID,

dooobjt.SOURCE_LANG,

dooobjt.LANGUAGE,

dooobjt.DESCRIPTION,

dooobjb.SYSTEM_FLAG SYSTEM_FLAG

FROM

DOO_OBJECTS_B dooobjb,

DOO_OBJECTS_TL dooobjt

WHERE

dooobjb.ENTITY_ID = dooobjt.ENTITY_ID AND dooobjb.CONSTRAINTS_ENABLED_FLAG = 'Y'