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: IGI.IGI_MHC_MCPP_RUN

Object Details

Object Name:	IGI_MHC_MCPP_RUN
Object Type:	TABLE
Owner:	IGI
FND Design Data:	IGI.IGI_MHC_MCPP_RUN
Subobject Name:
Status:	VALID

IGI_MHC_MCPP_RUN holds the run details of the Mass Copy Post Processor concurrent Program.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
MCPP_RUN_ID	NUMBER	(15)	Yes	Unique Identifier to indentify each Mass Copy Post Processor run.
MCPP_RUN_DATE	DATE		Yes	Date the Mass Copy Post Processor was run
MCPP_RUN_STATUS	VARCHAR2	(15)		Status of the Mass Copy Post Processor. The value is COMPLETE if it has completed successfully.
CONCURRENT_REQUEST_ID	NUMBER	(15)		Concurrent Request Id of the process.
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes	Name of the Book
MASS_REVAL_ID	NUMBER	(15)	Yes	The Mass Revaluation Id from the IGI_MHC_IDX_Revaluations table. This field will be populated if the Revaluation process had been submitted to calculate the Catchup Revaluation
CURRENT_MHC_PERIOD_COUNTER	NUMBER	(15)	Yes	Current Modified Historic Cost Accounting Period Counter
PERIOD_COUNTER	NUMBER	(15)	Yes	Current Depreciation Period

Query Text

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


SELECT MCPP_RUN_ID
,      MCPP_RUN_DATE
,      MCPP_RUN_STATUS
,      CONCURRENT_REQUEST_ID
,      BOOK_TYPE_CODE
,      MASS_REVAL_ID
,      CURRENT_MHC_PERIOD_COUNTER
,      PERIOD_COUNTER
FROM IGI.IGI_MHC_MCPP_RUN;

Dependencies

[top of page]

IGI.IGI_MHC_MCPP_RUN does not reference any database object

IGI.IGI_MHC_MCPP_RUN is referenced by following:

APPS: IGI_MHC_MCPP_RUN