[Home] [Help] [Dependency Information]
Object Name: | PSB_REENTRANT_PROCESS_STATUS |
---|---|
Object Type: | TABLE |
Owner: | PSB |
FND Design Data: | PSB.PSB_REENTRANT_PROCESS_STATUS |
Subobject Name: | |
Status: | VALID |
PSB_REENTREANT_PROCESS_STATUS stores the status for each step of a
process. This is used to implement reentrant algorithms in worksheet
creation or Human Resource Management Systems data extracts. This
table has been configured with a flexible layout to make it
extensible.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PSB_REENTRANT_PROCESS_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE |
PROCESS_UID
PROCESS_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROCESS_TYPE | VARCHAR2 | (20) | Yes | Process type is WORKSHEET_CREATION or HR DATA EXTRACT |
PROCESS_UID | NUMBER | (15) | Yes | Process unique identifier |
SP1_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP2_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP3_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP4_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP5_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP6_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP7_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP8_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP9_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP10_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP11_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP12_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP13_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP14_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP15_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP16_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP17_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP18_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP19_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP20_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP21_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP22_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP23_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP24_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP25_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP26_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP27_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP28_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP29_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
SP30_STATUS | VARCHAR2 | (1) | Reentrant process status is C (Complete) or I (Incomplete) | |
ATTRIBUTE1 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE2 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE3 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE4 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE5 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE6 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE7 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE8 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE9 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE10 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE11 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE12 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE13 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE14 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE15 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE16 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE17 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE18 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE19 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE20 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE21 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE22 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE23 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE24 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE25 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE26 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE27 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE28 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE29 | VARCHAR2 | (25) | Process attribute column | |
ATTRIBUTE30 | VARCHAR2 | (25) | Process attribute column |
Cut, paste (and edit) the following text to query this object:
SELECT PROCESS_TYPE
, PROCESS_UID
, SP1_STATUS
, SP2_STATUS
, SP3_STATUS
, SP4_STATUS
, SP5_STATUS
, SP6_STATUS
, SP7_STATUS
, SP8_STATUS
, SP9_STATUS
, SP10_STATUS
, SP11_STATUS
, SP12_STATUS
, SP13_STATUS
, SP14_STATUS
, SP15_STATUS
, SP16_STATUS
, SP17_STATUS
, SP18_STATUS
, SP19_STATUS
, SP20_STATUS
, SP21_STATUS
, SP22_STATUS
, SP23_STATUS
, SP24_STATUS
, SP25_STATUS
, SP26_STATUS
, SP27_STATUS
, SP28_STATUS
, SP29_STATUS
, SP30_STATUS
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
FROM PSB.PSB_REENTRANT_PROCESS_STATUS;
PSB.PSB_REENTRANT_PROCESS_STATUS does not reference any database object
PSB.PSB_REENTRANT_PROCESS_STATUS is referenced by following:
|
|
|