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_INTERFACE

Object Details

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

IGC_CC_INTERFACE stores information from the Contract Commitment system that is to be passed to the Commitment Budgetary Control submodule for funds checking and funds reservation. Both a funds check and a funds reservation request can be initiated from Contract Commitment. When the tasks are initiated, the system inserts the rows into this table, which acts as an interface to the submodule. The funds check and reservation may occur in the General Ledger standard budget and commitment budget, depending on whether budgetary control has been inabled in those systems. This table temporarily stores all of the information required to accomplish the tasks in the submodules.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGC_CC_INTERFACE_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	CC_HEADER_ID DOCUMENT_TYPE ACTUAL_FLAG BATCH_LINE_NUM
IGC_CC_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	CC_HEADER_ID ACTUAL_FLAG
IGC_CC_INTERFACE_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	CC_ACCT_LINE_ID
IGC_CC_INTERFACE_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	CC_DET_PF_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CC_HEADER_ID	NUMBER		Yes	Document identifier defining column
CC_VERSION_NUM	NUMBER			Contract commitment version number
CC_ACCT_LINE_ID	NUMBER			Account line defining column
CC_DET_PF_LINE_ID	NUMBER			Detail payment forecast line defining column
CODE_COMBINATION_ID	NUMBER	(15)	Yes	Key Flexfield combination defining column
BATCH_LINE_NUM	NUMBER		Yes	Line number of batch
CC_TRANSACTION_DATE	DATE		Yes	Accounting date of contract
CC_FUNC_DR_AMT	NUMBER			Transactional debit amount
CC_FUNC_CR_AMT	NUMBER			Transactional credit amount
JE_SOURCE_NAME	VARCHAR2	(25)		Journal entry source
JE_CATEGORY_NAME	VARCHAR2	(25)		Journal entry category
PERIOD_SET_NAME	VARCHAR2	(15)		Accounting calendar name
PERIOD_NAME	VARCHAR2	(15)		Accounting period
ACTUAL_FLAG	VARCHAR2	(1)	Yes	Balance type. Values are Actual, Budget, or Encumbrance.
BUDGET_DEST_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the line is for commitment or standard budget
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Accounting books defining column
ENCUMBRANCE_TYPE_ID	NUMBER	(15)		Encumbrance type defining column
CBC_RESULT_CODE	VARCHAR2	(3)		Result code for transaction line
STATUS_CODE	VARCHAR2	(2)		Status code for batch
BUDGET_VERSION_ID	NUMBER	(15)		Budget version defining column
BUDGET_AMT	NUMBER			Budget amount for this account and period
COMMITMENT_ENCMBRNC_AMT	NUMBER			Encumbrance amount of commitment type for this account and period
OBLIGATION_ENCMBRNC_AMT	NUMBER			Encumbrance amount of obligation type for this account and period
CC_ENCMBRNC_DATE	DATE			Date on which this transaction is encumbered
FUNDS_AVAILABLE_AMT	NUMBER			Funds available for this account and period
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency code for functional currency for this transaction
DOCUMENT_TYPE	VARCHAR2	(25)	Yes	Category for this document type
TRANSACTION_DESCRIPTION	VARCHAR2	(240)		Description for this transaction
PA_FLAG	VARCHAR2	(1)		Flag to indicate whethere there are any associated Projects
RESULT_CODE_SOURCE	VARCHAR2	(1)		Result Code Source
BATCH_ID	NUMBER	(20)		Batch Identifier
REFERENCE_1	VARCHAR2	(240)		Journal entry line reference column
REFERENCE_2	VARCHAR2	(240)		Journal entry line reference column
REFERENCE_3	VARCHAR2	(240)		Journal entry line reference column
REFERENCE_4	VARCHAR2	(240)		Journal entry line reference column
REFERENCE_5	VARCHAR2	(240)		Journal entry line reference column
REFERENCE_6	VARCHAR2	(240)		Journal entry line reference column
REFERENCE_7	VARCHAR2	(240)		Journal entry line reference column
REFERENCE_8	VARCHAR2	(240)		Journal entry line reference column
REFERENCE_9	VARCHAR2	(240)		Journal entry line reference column
REFERENCE_10	VARCHAR2	(240)		Journal entry line reference column
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).
EVENT_ID	NUMBER			SLA Event ID
PROJECT_LINE	VARCHAR2	(1)		Flag to indicate whether row is created by PA.
PA_BURDEN_FLAG	VARCHAR2	(1)		Flag to indicate whether row is PA Burden line

Query Text

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


SELECT CC_HEADER_ID
,      CC_VERSION_NUM
,      CC_ACCT_LINE_ID
,      CC_DET_PF_LINE_ID
,      CODE_COMBINATION_ID
,      BATCH_LINE_NUM
,      CC_TRANSACTION_DATE
,      CC_FUNC_DR_AMT
,      CC_FUNC_CR_AMT
,      JE_SOURCE_NAME
,      JE_CATEGORY_NAME
,      PERIOD_SET_NAME
,      PERIOD_NAME
,      ACTUAL_FLAG
,      BUDGET_DEST_FLAG
,      SET_OF_BOOKS_ID
,      ENCUMBRANCE_TYPE_ID
,      CBC_RESULT_CODE
,      STATUS_CODE
,      BUDGET_VERSION_ID
,      BUDGET_AMT
,      COMMITMENT_ENCMBRNC_AMT
,      OBLIGATION_ENCMBRNC_AMT
,      CC_ENCMBRNC_DATE
,      FUNDS_AVAILABLE_AMT
,      CURRENCY_CODE
,      DOCUMENT_TYPE
,      TRANSACTION_DESCRIPTION
,      PA_FLAG
,      RESULT_CODE_SOURCE
,      BATCH_ID
,      REFERENCE_1
,      REFERENCE_2
,      REFERENCE_3
,      REFERENCE_4
,      REFERENCE_5
,      REFERENCE_6
,      REFERENCE_7
,      REFERENCE_8
,      REFERENCE_9
,      REFERENCE_10
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      EVENT_ID
,      PROJECT_LINE
,      PA_BURDEN_FLAG
FROM IGC.IGC_CC_INTERFACE;

Dependencies

[top of page]

IGC.IGC_CC_INTERFACE does not reference any database object

IGC.IGC_CC_INTERFACE is referenced by following:

APPS: IGC_CC_INTERFACE