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_MRC_UPG_HISTORY

Object Details

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

PA_MRC_UPG_HISTORY stores the information about the projects for which the data has been converted to the reporting set of books assigned to the primary set of books.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_MRC_UPG_HISTORY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PRIMARY_SET_OF_BOOKS_ID REPORTING_SET_OF_BOOKS_ID TABLE_NAME PROJECT_ID ORG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PRIMARY_SET_OF_BOOKS_ID	NUMBER	(15)	Yes	The unique identifier for the primary set of books
REPORTING_SET_OF_BOOKS_ID	NUMBER	(15)	Yes	The unique identifier for the reporting set of books
TABLE_NAME	VARCHAR2	(30)	Yes	The table which contains the relevant data which is converted
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project for which the data has been converted
CONVERSION_STATUS	VARCHAR2	(1)	Yes	The flag to indicate whether the data has been converted
ROUNDING_STATUS	VARCHAR2	(1)		The flag to indicate whether the adjustment data has been converted
UPGRADE_RUN_ID	NUMBER	(15)	Yes	The identifier of the process which has converted the data
UPGRADE_RUN_ID2	NUMBER	(15)		The identifier of the process which has converted the adjustment data
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column
LAST_UPDATE_DATE	DATE			Standard Who Column
ORG_ID	NUMBER			Operating unit identifier for Multi organization installation.
SOB_PROJECT_FLAG	VARCHAR2	(1)		The flag indicates whether the project belongs to the primary set of books or not. When 'Y' it means project belongs to the primary set of books and 'N' means the project does not belong to the primary set of books.

Query Text

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


SELECT PRIMARY_SET_OF_BOOKS_ID
,      REPORTING_SET_OF_BOOKS_ID
,      TABLE_NAME
,      PROJECT_ID
,      CONVERSION_STATUS
,      ROUNDING_STATUS
,      UPGRADE_RUN_ID
,      UPGRADE_RUN_ID2
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      ORG_ID
,      SOB_PROJECT_FLAG
FROM PA.PA_MRC_UPG_HISTORY;

Dependencies

[top of page]

PA.PA_MRC_UPG_HISTORY does not reference any database object

PA.PA_MRC_UPG_HISTORY is referenced by following:

APPS: PA_MRC_UPG_HISTORY