[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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). |
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;
IGC.IGC_CC_ARCHIVE_HISTORY_ALL does not reference any database object
IGC.IGC_CC_ARCHIVE_HISTORY_ALL is referenced by following:
|
|
|