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_MC_ACCT_LINES

Object Details

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

IGC_CC_MC_ACCT_LINES stores reporting currency information for each account line in the IGC_CC_ACCT_LINE table. There is an optional one to many relationship between IGC_CC_ACCT_LINES and this table. For each account line, there can be several lines in the IGC_CC_MC_ACCT_LINE table with the same CC_ACCT_LINE_ID, but different values for the REPORTING_SET_OF_BOOKS_ID. The number of lines stored in the IGC_CC_MC_ACCT_LINES table corresponds with the number of Reporting Sets of Books that have been defined.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGC_CC_MC_ACCT_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CC_ACCT_LINE_ID SET_OF_BOOKS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CC_ACCT_LINE_ID	NUMBER		Yes	Account line defining column
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Reporting Set of Books defining column
CC_ACCT_FUNC_AMT	NUMBER			Account line functional amount to be converted
CC_ACCT_ENCMBRNC_AMT	NUMBER			Account line encumbrance amount to be converted
CONVERSION_TYPE	VARCHAR2	(30)		Conversion type used for converting between currencies
CONVERSION_DATE	DATE			Conversion date used for converting the currencies
CONVERSION_RATE	NUMBER			Conversion rate used for converting the currencies
CC_FUNC_WITHHELD_AMT	NUMBER			Withheld Amount in the Functional Currency

Query Text

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


SELECT CC_ACCT_LINE_ID
,      SET_OF_BOOKS_ID
,      CC_ACCT_FUNC_AMT
,      CC_ACCT_ENCMBRNC_AMT
,      CONVERSION_TYPE
,      CONVERSION_DATE
,      CONVERSION_RATE
,      CC_FUNC_WITHHELD_AMT
FROM IGC.IGC_CC_MC_ACCT_LINES;

Dependencies

[top of page]

IGC.IGC_CC_MC_ACCT_LINES does not reference any database object

IGC.IGC_CC_MC_ACCT_LINES is referenced by following:

APPS: IGC_CC_MC_ACCT_LINES