DBA Data[Home] [Help] [Dependency Information]

TABLE: CSM.CSM_HA_ACTIVE_WF_COMPONENTS

Object Details
Object Name: CSM_HA_ACTIVE_WF_COMPONENTS
Object Type: TABLE
Owner: CSM
Subobject Name:
Status: VALID


This table lists the workflow item types, workflow events and subscriptions that need to be active on the high availability instance. The workflow white list table will also have columns to inform if these workflow components need to be activated during the HA Record phase or during the HA Apply phase


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSM_HA_ACTIVE_WF_ITEMS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnACTIVE_WF_COMPONENT_ID
Columns
Name Datatype Length Mandatory Comments
ACTIVE_WF_COMPONENT_ID NUMBER
Yes
WF_ITEM_TYPE VARCHAR2 (255)
WF_EVENT_NAME VARCHAR2 (240)
WF_EVENT_SUBSCRIPTION_GUID RAW (16)
AUTO_DISABLE_FLAG VARCHAR2 (1) Yes
ENABLED_ON_RECORD VARCHAR2 (1) Yes
ENABLED_ON_APPLY VARCHAR2 (1) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ACTIVE_WF_COMPONENT_ID
,      WF_ITEM_TYPE
,      WF_EVENT_NAME
,      WF_EVENT_SUBSCRIPTION_GUID
,      AUTO_DISABLE_FLAG
,      ENABLED_ON_RECORD
,      ENABLED_ON_APPLY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM CSM.CSM_HA_ACTIVE_WF_COMPONENTS;

Dependencies

[top of page]

CSM.CSM_HA_ACTIVE_WF_COMPONENTS does not reference any database object

CSM.CSM_HA_ACTIVE_WF_COMPONENTS is referenced by following:

SchemaCSM
ViewCSM_HA_ACTIVE_WF_COMPONENTS#