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: IGC.IGC_ARC_PUR_CANDIDATES

Object Details

Object Name:	IGC_ARC_PUR_CANDIDATES
Object Type:	TABLE
Owner:	IGC
FND Design Data:	IGC.IGC_ARC_PUR_CANDIDATES
Subobject Name:
Status:	VALID

IGC_ARC_PUR_CANDIDATES temporarily stores contract commitment information for rows about to be archived or purged from the system.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGC_ARC_PUR_CANDIDATES_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	CC_HEADER_ID

Columns

Name	Datatype	Length	Comments
CC_HEADER_ID	NUMBER		Contract commitment defining column
CC_NUM	VARCHAR2	(20)	Contract commitment number
CC_ACCT_LINE_ID	NUMBER		Account line defining column
CC_DET_PF_LINE_ID	NUMBER		Detail payment forecast line defining column
LAST_ACTIVITY_DATE	DATE		Date activity last occurred on this contract

Query Text

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


SELECT CC_HEADER_ID
,      CC_NUM
,      CC_ACCT_LINE_ID
,      CC_DET_PF_LINE_ID
,      LAST_ACTIVITY_DATE
FROM IGC.IGC_ARC_PUR_CANDIDATES;

Dependencies

[top of page]

IGC.IGC_ARC_PUR_CANDIDATES does not reference any database object

IGC.IGC_ARC_PUR_CANDIDATES is referenced by following:

IGC: IGC_ARC_PUR_CANDIDATES#