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

TABLE: APPLSYS.WF_DIRECTORY_PARTITIONS

Object Details
Object Name: WF_DIRECTORY_PARTITIONS
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.WF_DIRECTORY_PARTITIONS
Subobject Name:
Status: VALID


Lookup table for orig system in partitioned tables.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WF_DIRECTORY_PARTITIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORIG_SYSTEM
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
PARTITION_ID NUMBER (15)
partition identifier
ORIG_SYSTEM VARCHAR2 (30) Yes Original System
SECURITY_GROUP_ID VARCHAR2 (32)
ID used in VPD for hosting
ROLE_VIEW VARCHAR2 (30)
BUlkSynch View for Workflow Roles
USER_ROLE_VIEW VARCHAR2 (30)
BulkSynch View for Workflow User Roles
ROLE_TL_VIEW VARCHAR2 (30)
ROLE_TL_VIEW
BULKSYNC_DATE DATE

SUMMARY_DATE DATE

LAST_UPDATE_DATE DATE

ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT PARTITION_ID
,      ORIG_SYSTEM
,      SECURITY_GROUP_ID
,      ROLE_VIEW
,      USER_ROLE_VIEW
,      ROLE_TL_VIEW
,      BULKSYNC_DATE
,      SUMMARY_DATE
,      LAST_UPDATE_DATE
,      ZD_EDITION_NAME
FROM APPLSYS.WF_DIRECTORY_PARTITIONS;

Dependencies

[top of page]

APPLSYS.WF_DIRECTORY_PARTITIONS does not reference any database object

APPLSYS.WF_DIRECTORY_PARTITIONS is referenced by following:

SchemaAPPLSYS
ViewWF_DIRECTORY_PARTITIONS#