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: PA.PA_STREAMLINE_REQUESTS

Object Details

Object Name:	PA_STREAMLINE_REQUESTS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_STREAMLINE_REQUESTS
Subobject Name:
Status:	VALID

PA_STREAMLINE_REQUESTS stores information about the
submitted streamline process requests and the child
processes that they submit and monitor. Oracle
Projects uses this table when running
streamline processes.
.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_STREAMLINE_REQUESTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_ID	NUMBER	(15)	Yes	Standard Who Column
STREAMLINE_OPTION	VARCHAR2	(30)	Yes	The streamline option executed by the streamline request
STATUS	VARCHAR2	(30)	Yes	The status of the streamline request
NUM_SUB_PROCESSES_SUBMITTED	NUMBER	(15)	Yes	The number of child processes submitted for the streamline request
SUB_PROCESS_REQUEST_ID_STR	VARCHAR2	(240)	Yes	The concatenation of the request ids of the child processes submitted
PROGRAM_ID	NUMBER	(15)	Yes	Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER	(15)	Yes	Standard Who Column
PROGRAM_UPDATE_DATE	DATE		Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
GROUP_ID	NUMBER	(15)		Identifier of the GL Journal Import group which identifies a set of interface journal entry lines to process together in the same run of Oracle General Ledger's Journal Import program. Used by interfacing to GL

Query Text

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


SELECT REQUEST_ID
,      STREAMLINE_OPTION
,      STATUS
,      NUM_SUB_PROCESSES_SUBMITTED
,      SUB_PROCESS_REQUEST_ID_STR
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      GROUP_ID
FROM PA.PA_STREAMLINE_REQUESTS;

Dependencies

[top of page]

PA.PA_STREAMLINE_REQUESTS does not reference any database object

PA.PA_STREAMLINE_REQUESTS is referenced by following:

PA: PA_STREAMLINE_REQUESTS#