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

TABLE: IGC.IGC_CC_ACCT_LINES

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


IGC_CC_ACCT_LINES stores current information pertaining to each account line of the contract commitment. For each contract in the IGC_CC_HEADERS table, there can be one or more account lines in the IGC_CC_ACCT_LINES table. Each row includes the corresponding CC_HEADER_ID for this contract, the line number, and information specific to the General Ledger account and the project expenditures for the account line. If commitment budgetary control is enabled and if this is a parent contract, the amount for this account line, in the functional currency, is encumbered against the commitment budget. The CC_ACCT_ENCMBRNC_AMT reflects the total amount that has been encumbered to date for the given account line. If the account line is for a release contract commitment, the account line will be related to a parent account line. The PARENT_HEADER_ID and PARENT_ACCT_LINE_ID form the relationship between the parent contract commitment and the release contract commitment for any given account line.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGC_CC_ACCT_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCC_ACCT_LINE_ID
IGC_CC_ACCT_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCC_HEADER_ID
IGC_CC_ACCT_LINES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARENT_HEADER_ID
IGC_CC_ACCT_LINES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARENT_ACCT_LINE_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_CHARGE_CODE_COMBINATION_ID NUMBER (15)
Key Flexfield combination defining column for charge account
CC_ACCT_LINE_NUM NUMBER
Yes Account line number
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 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

Functional Withheld Amount
CC_ENT_WITHHELD_AMT NUMBER

Withheld Amount in the Entered Currency
EVENT_ID NUMBER (15)
Event Identifier
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_CHARGE_CODE_COMBINATION_ID
,      CC_ACCT_LINE_NUM
,      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
,      EVENT_ID
,      TAX_CLASSIF_CODE
FROM IGC.IGC_CC_ACCT_LINES;

Dependencies

[top of page]

IGC.IGC_CC_ACCT_LINES does not reference any database object

IGC.IGC_CC_ACCT_LINES is referenced by following:

SchemaAPPS
SynonymIGC_CC_ACCT_LINES