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: GL.GL_MC_BOOK_ASSIGNMENTS_11I

Object Details

Object Name:	GL_MC_BOOK_ASSIGNMENTS_11I
Object Type:	TABLE
Owner:	GL
FND Design Data:	SQLGL.GL_MC_BOOK_ASSIGNMENTS_11I
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_MC_BOOK_ASSIGNMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PRIMARY_SET_OF_BOOKS_ID REPORTING_SET_OF_BOOKS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PRIMARY_SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Primary set of books defining column
REPORTING_SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Reporting set of books defining column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column
FIRST_MRC_DATE	DATE			First accounting date for MRC
FIRST_MRC_PERIOD	VARCHAR2	(15)		First accounting period for MRC
CONVERSION_OPTION_CODE	VARCHAR2	(1)		Determines conversion option for initializing transactions and balances in this reporting book
INIT_CONVERSION_TYPE	VARCHAR2	(30)		Currency conversion type to use for initializing MRC balances
INIT_CONVERSION_DATE	DATE			Currency conversion date to use for initializing MRC balances
EFC_BOOK_FLAG	VARCHAR2	(1)		Flag which indicates reporting set of book selected for EFC
PRE_EFC_SELECTED_FLAG	VARCHAR2	(1)		Flag which indicates primary/reporting set of books selected for Pre-EFC processes.
EFC_SELECTED_FLAG	VARCHAR2	(1)		Flag which indicates primary/reporting set of books selected for the EFC process.
EFC_COMPLETED_FLAG	VARCHAR2	(1)		Determines if EFC process has been completed.
EFC_RUN_ID	NUMBER	(15)		Identifier for the Pre-EFC/EFC processes

Query Text

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


SELECT PRIMARY_SET_OF_BOOKS_ID
,      REPORTING_SET_OF_BOOKS_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      FIRST_MRC_DATE
,      FIRST_MRC_PERIOD
,      CONVERSION_OPTION_CODE
,      INIT_CONVERSION_TYPE
,      INIT_CONVERSION_DATE
,      EFC_BOOK_FLAG
,      PRE_EFC_SELECTED_FLAG
,      EFC_SELECTED_FLAG
,      EFC_COMPLETED_FLAG
,      EFC_RUN_ID
FROM GL.GL_MC_BOOK_ASSIGNMENTS_11I;

Dependencies

[top of page]

GL.GL_MC_BOOK_ASSIGNMENTS_11I does not reference any database object

GL.GL_MC_BOOK_ASSIGNMENTS_11I is referenced by following:

GL: GL_MC_BOOK_ASSIGNMENTS_11I#