eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: PSB.PSB_REENTRANT_PROCESS_STATUS

Object Details

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.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSB_REENTRANT_PROCESS_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	PROCESS_UID PROCESS_TYPE

Columns

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

Query Text

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;

Dependencies

[top of page]

PSB.PSB_REENTRANT_PROCESS_STATUS does not reference any database object

PSB.PSB_REENTRANT_PROCESS_STATUS is referenced by following:

APPS: PSB_REENTRANT_PROCESS_STATUS