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_CC_ARCHIVE_HISTORY_ALL

Object Details

Object Name:	IGC_CC_ARCHIVE_HISTORY_ALL
Object Type:	TABLE
Owner:	IGC
Subobject Name:
Status:	VALID

IGC_CC_ARCHIVE_HISTORY stores the history of purged or archived contract commitment records that were approved and canceled or completed.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGC_CC_AH_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CC_HEADER_ID SET_OF_BOOKS_ID
IGC_CC_AH_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_ID
IGC_CC_AH_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CC_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
CC_HEADER_ID	NUMBER		Yes	Contract commitment defining column
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Accounting books defining column
ORG_ID	NUMBER	(15)	Yes	Organization identifier
CC_TYPE	VARCHAR2	(1)	Yes	Type of contract commitment
CC_NUM	VARCHAR2	(20)	Yes	Contract commitment number
PARENT_HEADER_ID	NUMBER			Contract commitment defining column for the parent contract
ARCHIVE_DATE	DATE			Date archive was completed
ARCHIVED_BY	NUMBER	(15)		User identifier of the initiator of the archive process
ARCHIVE_DONE_FLAG	VARCHAR2	(1)		Flag to indicate if the archive is complete
PURGE_DATE	DATE			Date purge was completed
PURGED_BY	NUMBER	(15)		User identifier of the initiator of the purge process
PURGE_DONE_FLAG	VARCHAR2	(1)		Flag to indicate if the purge is complete
NUM_ACCT_LINES_ARC	NUMBER			Total number of accounting lines archived in this batch
NUM_DET_PF_LINES_ARC	NUMBER			Total number of detail payment forecast lines archived in this batch
NUM_MC_ACCT_LINES_ARC	NUMBER			Total number of Multiple Reporting Currency account lines archived in this batch
NUM_MC_DET_PF_LINES_ARC	NUMBER			Total number of Multiple Reporting Currency detail payment forecast lines archived in this batch
LAST_CC_ACTIVITY_DATE	DATE			Date of last activity against this contract
USER_REQ_LAST_ACTIVITY_DATE	DATE			Date a user requested activity against this contract
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).

Query Text

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


SELECT CC_HEADER_ID
,      SET_OF_BOOKS_ID
,      ORG_ID
,      CC_TYPE
,      CC_NUM
,      PARENT_HEADER_ID
,      ARCHIVE_DATE
,      ARCHIVED_BY
,      ARCHIVE_DONE_FLAG
,      PURGE_DATE
,      PURGED_BY
,      PURGE_DONE_FLAG
,      NUM_ACCT_LINES_ARC
,      NUM_DET_PF_LINES_ARC
,      NUM_MC_ACCT_LINES_ARC
,      NUM_MC_DET_PF_LINES_ARC
,      LAST_CC_ACTIVITY_DATE
,      USER_REQ_LAST_ACTIVITY_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
FROM IGC.IGC_CC_ARCHIVE_HISTORY_ALL;

Dependencies

[top of page]

IGC.IGC_CC_ARCHIVE_HISTORY_ALL does not reference any database object

IGC.IGC_CC_ARCHIVE_HISTORY_ALL is referenced by following:

IGC: IGC_CC_ARCHIVE_HISTORY_ALL#