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_PROGRESS_REPORT_VERS

Object Details

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

This table keeps track of all the versions of page type of Status Report attached to a project.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PROGRESS_REPORT_VERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	VERSION_ID
PA_PROGRESS_REPORT_VERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_ID OBJECT_TYPE REPORT_TYPE_ID REPORT_STATUS_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
VERSION_ID	NUMBER		Yes	System generated unique identifier of the page version
OBJECT_ID	NUMBER		Yes	Identifier of the object. For example,PROJECT_ID is the object associated with the object_type PA_PROJECTS
OBJECT_TYPE	VARCHAR2	(30)	Yes	Identifier of the object type,such as PA_PROJECTS
PAGE_ID	NUMBER		Yes	Unique identifier of the page layout
PAGE_TYPE_CODE	VARCHAR2	(30)	Yes	Identifier of the page type, such as PPR or PH
REPORT_STATUS_CODE	VARCHAR2	(30)	Yes	Status of the page
REPORT_START_DATE	DATE		Yes	Start date of the report
REPORT_END_DATE	DATE		Yes	End date of the report
REPORTED_BY	NUMBER			Identifier of the person who ran the report
PROGRESS_STATUS_CODE	VARCHAR2	(30)		Progress status of the object
OVERVIEW	VARCHAR2	(240)		Brief summary of the report
CURRENT_FLAG	VARCHAR2	(1)		Flag indicating if the report is the current published report
PUBLISHED_DATE	DATE			The date and time the report was published
COMMENTS	VARCHAR2	(240)		Comments
CANCELED_DATE	DATE			The date and time the report was canceled
RECORD_VERSION_NUMBER	NUMBER			Number used for record locking in self service applications
SUMMARY_VERSION_NUMBER	NUMBER			Number used for summary locking in self service applications
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
REPORT_TYPE_ID	NUMBER	(15)	Yes	Identifier of the report type

Query Text

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


SELECT VERSION_ID
,      OBJECT_ID
,      OBJECT_TYPE
,      PAGE_ID
,      PAGE_TYPE_CODE
,      REPORT_STATUS_CODE
,      REPORT_START_DATE
,      REPORT_END_DATE
,      REPORTED_BY
,      PROGRESS_STATUS_CODE
,      OVERVIEW
,      CURRENT_FLAG
,      PUBLISHED_DATE
,      COMMENTS
,      CANCELED_DATE
,      RECORD_VERSION_NUMBER
,      SUMMARY_VERSION_NUMBER
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REPORT_TYPE_ID
FROM PA.PA_PROGRESS_REPORT_VERS;

Dependencies

[top of page]

PA.PA_PROGRESS_REPORT_VERS does not reference any database object

PA.PA_PROGRESS_REPORT_VERS is referenced by following:

APPS: PA_PROGRESS_REPORT_VERS