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

TABLE: PSP.PSP_ENC_PROCESSES

Object Details
Object Name: PSP_ENC_PROCESSES
Object Type: TABLE
Owner: PSP
Subobject Name:
Status: VALID


Contains details about the completed/in progress/errored out encumbrance processes


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PSP_ENC_PROCESSES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYROLL_ACTION_ID
ColumnPROCESS_CODE
PSP_ENC_PROCESSES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
PSP_ENC_PROCESSES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
ColumnSET_OF_BOOKS_ID
ColumnPROCESS_CODE
ColumnPROCESS_PHASE
Columns
Name Datatype Length Mandatory Comments
PAYROLL_ACTION_ID NUMBER (15)
Payroll Action Id
REQUEST_ID NUMBER (15)
Concurrent Request Id
PROCESS_CODE VARCHAR2 (10)
Encumbrance Process Code
PROCESS_STATUS VARCHAR2 (10)
Encumbrance Process Status
PROCESS_PHASE VARCHAR2 (50)
Encumbrance Process Phase
BUSINESS_GROUP_ID NUMBER (15)
Business Group
SET_OF_BOOKS_ID NUMBER (15)
GL Set of Books Id
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard WHO Column
CREATED_BY NUMBER (15) Yes Standard WHO Column
CREATION_DATE DATE
Yes Standard WHO Column
Query Text

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


SELECT PAYROLL_ACTION_ID
,      REQUEST_ID
,      PROCESS_CODE
,      PROCESS_STATUS
,      PROCESS_PHASE
,      BUSINESS_GROUP_ID
,      SET_OF_BOOKS_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM PSP.PSP_ENC_PROCESSES;

Dependencies

[top of page]

PSP.PSP_ENC_PROCESSES does not reference any database object

PSP.PSP_ENC_PROCESSES is referenced by following:

SchemaPSP
ViewPSP_ENC_PROCESSES#