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: FII.FII_GL_JE_SUMMARY_B

Object Details

Object Name:	FII_GL_JE_SUMMARY_B
Object Type:	TABLE
Owner:	FII
FND Design Data:	FII.FII_GL_JE_SUMMARY_B
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_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FII_GL_JE_SUMMARY_B_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	PERIOD_TYPE_ID TIME_ID COMPANY_ID COST_CENTER_ID FIN_CATEGORY_ID LEDGER_ID USER_DIM1_ID USER_DIM2_ID JE_SOURCE JE_CATEGORY CHART_OF_ACCOUNTS_ID PROD_CATEGORY_ID POSTED_DATE
FII_GL_JE_SUMMARY_B_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	COMPANY_ID COST_CENTER_ID
FII_GL_JE_SUMMARY_B_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	FIN_CATEGORY_ID

Columns

Name	Datatype	Length	Comments
TIME_ID	NUMBER		Forign key to time levels
PERIOD_TYPE_ID	NUMBER		Period Type Identifier
PROD_CATEGORY_ID	NUMBER	(15)	Product Category identifier
COST_CENTER_ORG_ID	NUMBER	(15)	No longer used - Cost center Org ID deprecated
JE_SOURCE	VARCHAR2	(25)	Journal Entry Source
JE_CATEGORY	VARCHAR2	(25)	Journal Entry Category
LEDGER_ID	NUMBER	(15)	Ledger Identifier
CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Key flexfield structure defining column
FUNCTIONAL_CURRENCY	VARCHAR2	(15)	Functional currency code
AMOUNT_B	NUMBER		Total amount in Accounting currency
PRIM_AMOUNT_G	NUMBER		Amount in the primary currency
SEC_AMOUNT_G	NUMBER		Amount in the secondary currency
CREATION_DATE	DATE		Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
FIN_CATEGORY_ID	NUMBER	(15)	Financial Category Identifier
COMPANY_ID	NUMBER	(15)	Company Identifier
COST_CENTER_ID	NUMBER	(15)	Cost Center Identifier
SET_OF_BOOKS_ID	NUMBER	(15)	No longer used. deprecated
USER_DIM1_ID	NUMBER	(15)	User Dimension1 Identifier
USER_DIM2_ID	NUMBER	(15)	User Dimension2 Identifier
POSTED_DATE	DATE		Posted date for the journals
COMMITTED_AMOUNT_B	NUMBER		Committed amount in Accounting currency
COMMITTED_AMOUNT_PRIM	NUMBER		Committed amount in primary global currency
OBLIGATED_AMOUNT_B	NUMBER		Obligated amount in Accounting currency
OBLIGATED_AMOUNT_PRIM	NUMBER		Obligated amount in primary global currency
OTHER_AMOUNT_B	NUMBER		Amount in accounting currency which is either not committed or obligated for encumbrances
OTHER_AMOUNT_PRIM	NUMBER		Amount in primary global currency which is either not committed or obligated for encumbrances

Query Text

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


SELECT TIME_ID
,      PERIOD_TYPE_ID
,      PROD_CATEGORY_ID
,      COST_CENTER_ORG_ID
,      JE_SOURCE
,      JE_CATEGORY
,      LEDGER_ID
,      CHART_OF_ACCOUNTS_ID
,      FUNCTIONAL_CURRENCY
,      AMOUNT_B
,      PRIM_AMOUNT_G
,      SEC_AMOUNT_G
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      FIN_CATEGORY_ID
,      COMPANY_ID
,      COST_CENTER_ID
,      SET_OF_BOOKS_ID
,      USER_DIM1_ID
,      USER_DIM2_ID
,      POSTED_DATE
,      COMMITTED_AMOUNT_B
,      COMMITTED_AMOUNT_PRIM
,      OBLIGATED_AMOUNT_B
,      OBLIGATED_AMOUNT_PRIM
,      OTHER_AMOUNT_B
,      OTHER_AMOUNT_PRIM
FROM FII.FII_GL_JE_SUMMARY_B;