DBA Data[Home] [Help] [Dependency Information]

TABLE: IGC.IGC_CC_ACCT_LINE_HISTORY

Object Details
Object Name: IGC_CC_ACCT_LINE_HISTORY
Object Type: TABLE
Owner: IGC
FND Design Data: TableIGC.IGC_CC_ACCT_LINE_HISTORY
Subobject Name:
Status: VALID


IGC_CC_ACCT_LINE_HISTORY stores information specific to a given version of an account line of the contract. A new version of an account line is created any time there is a significant change to the account line, such as the amount or the project information for the account line. When this information changes, the entire row of the previous version of the IGC_CC_ACCT_LINE row is inserted into IGC_CC_ACCT_LINE_HISTORY and the version number of the contract in the IGC_CC_HEADERS table will increase. The insertion of this row occurs systematically.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGC_CC_ACCT_LINE_HISTORY_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCC_ACCT_LINE_ID
ColumnCC_ACCT_VERSION_NUM
IGC_CC_ACCT_LINE_HISTORY_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCC_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
CC_ACCT_LINE_ID NUMBER
Yes Account line defining column
CC_HEADER_ID NUMBER
Yes Contract commitment defining column
PARENT_HEADER_ID NUMBER

Contract commitment defining column for the parent contract
PARENT_ACCT_LINE_ID NUMBER

Account line defining column for parent account line
CC_ACCT_LINE_NUM NUMBER
Yes Account line number
CC_ACCT_VERSION_NUM NUMBER
Yes Contract commitment version number
CC_ACCT_VERSION_ACTION VARCHAR2 (1) Yes Action corresponding to the creation of this version
CC_CHARGE_CODE_COMBINATION_ID NUMBER (15)
Key Flexfield combination defining column for charge account
CC_BUDGET_CODE_COMBINATION_ID NUMBER (15)
Key Flexfield combination defining column for budget account
CC_ACCT_ENTERED_AMT NUMBER

Account line entered amount
CC_ACCT_FUNC_AMT NUMBER

Account line functional amount
CC_ACCT_DESC VARCHAR2 (240)
Account line description
CC_ACCT_BILLED_AMT NUMBER

Account line billed amount
CC_ACCT_UNBILLED_AMT NUMBER

Account line unbilled amount
CC_ACCT_TAXABLE_FLAG VARCHAR2 (1)
Flag to indicate if the line is taxable
TAX_ID NUMBER (15)
Tax code identifier
CC_ACCT_ENCMBRNC_AMT NUMBER

Amount of the account line that has been encumbered, to date, on the commitment budget
CC_ACCT_ENCMBRNC_DATE DATE

Date account line was last encumbered on the commitment budget
CC_ACCT_ENCMBRNC_STATUS VARCHAR2 (1)
Encumbrance status, as of the last time this account line was encumbered
PROJECT_ID NUMBER (15)
Project accounting project unique identifier
TASK_ID NUMBER (15)
Project accounting task unique identifier
EXPENDITURE_TYPE VARCHAR2 (30)
Project accounting expenditure type
EXPENDITURE_ORG_ID NUMBER

Project accounting expenditure operating unit unique identifier
EXPENDITURE_ITEM_DATE DATE

Date the project expenditure item occurred if the account line is related to a project
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

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
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CONTEXT VARCHAR2 (30)
Descriptive Flexfield context column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
CC_FUNC_WITHHELD_AMT NUMBER

Withheld Amount in the Functional Currency
CC_ENT_WITHHELD_AMT NUMBER

Withheld Amount in the Entered Currency
TAX_CLASSIF_CODE VARCHAR2 (50)
Tax Classification Code
Query Text

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


SELECT CC_ACCT_LINE_ID
,      CC_HEADER_ID
,      PARENT_HEADER_ID
,      PARENT_ACCT_LINE_ID
,      CC_ACCT_LINE_NUM
,      CC_ACCT_VERSION_NUM
,      CC_ACCT_VERSION_ACTION
,      CC_CHARGE_CODE_COMBINATION_ID
,      CC_BUDGET_CODE_COMBINATION_ID
,      CC_ACCT_ENTERED_AMT
,      CC_ACCT_FUNC_AMT
,      CC_ACCT_DESC
,      CC_ACCT_BILLED_AMT
,      CC_ACCT_UNBILLED_AMT
,      CC_ACCT_TAXABLE_FLAG
,      TAX_ID
,      CC_ACCT_ENCMBRNC_AMT
,      CC_ACCT_ENCMBRNC_DATE
,      CC_ACCT_ENCMBRNC_STATUS
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ORG_ID
,      EXPENDITURE_ITEM_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CC_FUNC_WITHHELD_AMT
,      CC_ENT_WITHHELD_AMT
,      TAX_CLASSIF_CODE
FROM IGC.IGC_CC_ACCT_LINE_HISTORY;

Dependencies

[top of page]

IGC.IGC_CC_ACCT_LINE_HISTORY does not reference any database object

IGC.IGC_CC_ACCT_LINE_HISTORY is referenced by following:

SchemaAPPS
SynonymIGC_CC_ACCT_LINE_HISTORY