[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PSP_ENC_PROCESSES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PAYROLL_ACTION_ID
PROCESS_CODE |
PSP_ENC_PROCESSES_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | REQUEST_ID |
PSP_ENC_PROCESSES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BUSINESS_GROUP_ID
SET_OF_BOOKS_ID PROCESS_CODE PROCESS_PHASE |
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 |
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;
PSP.PSP_ENC_PROCESSES does not reference any database object
PSP.PSP_ENC_PROCESSES is referenced by following:
|
|
|