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_MSP_PRC_STATUS

Object Details

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

This table stores the data from the asynchronous upload from Microsoft Project.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000512540C00005$$	LOB	UNIQUE	APPS_TS_TX_DATA

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_ID	NUMBER	(15)	Yes	This column stores the concurrent request ID.
SUBMITTED_DATE	DATE		Yes	This column stores the concurrent request submission date.
SUBMITTED_BY	NUMBER	(15)	Yes	This column stores the ID of the user who submitted the concurrent request.
STATUS	VARCHAR2	(15)		This column stores the status of the concurrent request.
RESPONSE	CLOB	(4000)		This column stores the response of the asynchronous upload request.

Query Text

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


SELECT REQUEST_ID
,      SUBMITTED_DATE
,      SUBMITTED_BY
,      STATUS
,      RESPONSE
FROM PA.PA_MSP_PRC_STATUS;

Dependencies

[top of page]

PA.PA_MSP_PRC_STATUS does not reference any database object

PA.PA_MSP_PRC_STATUS is referenced by following:

PA: PA_MSP_PRC_STATUS#