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

TABLE: PSB.PSB_WORKFLOW_PROCESSES

Object Details
Object Name: PSB_WORKFLOW_PROCESSES
Object Type: TABLE
Owner: PSB
FND Design Data: TablePSB.PSB_WORKFLOW_PROCESSES
Subobject Name:
Status: VALID


PSB_WORKFLOW_PROCESSES stores the ITEM_KEY information for a
worksheet. A worksheet can flow through the workflow engine multiple
times for the various processes such as distribution, submission,
or freeze. Each instance of this process generates a unique ITEM_KEY.
The ITEM_KEY and PROCESS_TYPE identify the workflow process a
worksheet is undergoing.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PSB_WORKFLOW_PROCESSES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnWORKSHEET_ID
PSB_WORKFLOW_PROCESSES_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnITEM_KEY
Columns
Name Datatype Length Mandatory Comments
ITEM_KEY VARCHAR2 (240) Yes Unique identifier for an instance of an item entering the workflow process
WORKSHEET_ID NUMBER (20) Yes Unique identifier for the worksheet or budget revision for which the workflow process exists
DOCUMENT_TYPE VARCHAR2 (2)
Indicates the document type for which the workflow process is initiated. Valid values are BP (Budget Preparation) and BR (Budget Revision).
PROCESS_TYPE VARCHAR2 (20) Yes Process type for workflow process is S (Submit Process) or D (Distribute Process).
PROCESS_DATE DATE
Yes Date of creation of the workflow process
Query Text

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


SELECT ITEM_KEY
,      WORKSHEET_ID
,      DOCUMENT_TYPE
,      PROCESS_TYPE
,      PROCESS_DATE
FROM PSB.PSB_WORKFLOW_PROCESSES;

Dependencies

[top of page]

PSB.PSB_WORKFLOW_PROCESSES does not reference any database object

PSB.PSB_WORKFLOW_PROCESSES is referenced by following:

SchemaAPPS
SynonymPSB_WORKFLOW_PROCESSES