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_BUDGET_EXTRACT_T

Object Details

Object Name:	FII_GL_BUDGET_EXTRACT_T
Object Type:	TABLE
Owner:	FII
FND Design Data:	FII.FII_GL_BUDGET_EXTRACT_T
Subobject Name:
Status:	VALID

Temporary table for GL budget extraction.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
PLAN_TYPE_CODE_FLAG	VARCHAR2	(1)		Value is B and stands for Budget
TIME_ID	NUMBER	(15)		Time Identifier
PERIOD_TYPE_ID	NUMBER	(15)		Period Type Identifier
PERIOD_NAME	VARCHAR2	(15)		Period name such as Oct-04
PRIM_AMOUNT_G	NUMBER			Primary amount from gl_balances table
SEC_AMOUNT_G	NUMBER			Secondary amount from gl_balances table
COMPANY_COST_CENTER_ORG_ID	NUMBER	(15)		Company Cost Center Org Identifier
COMPANY_ID	NUMBER	(15)		Company Identifier
COST_CENTER_ID	NUMBER	(15)		Cost Center Identifier
FIN_CATEGORY_ID	NUMBER	(15)		Financial Category Identifier
CATEGORY_ID	NUMBER	(15)		Product Category Identifier
USER_DIM1_ID	NUMBER	(15)		User Defined Dimension 1 Identifier
USER_DIM2_ID	NUMBER	(15)		User Defined Dimension 2 Identifier
CODE_COMBINATION_ID	NUMBER	(15)		Code Combination Identifier
LAST_UPDATE_DATE	DATE		Yes	Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Who column
CREATION_DATE	DATE		Yes	Who column
CREATED_BY	NUMBER	(15)	Yes	Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Who column
LEDGER_ID	NUMBER	(15)		Ledger identifier
BUDGET_VERSION_ID	NUMBER	(15)		Budget Version Identifier
CURRENCY_CODE	VARCHAR2	(15)		Currency Code

Query Text

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


SELECT PLAN_TYPE_CODE_FLAG
,      TIME_ID
,      PERIOD_TYPE_ID
,      PERIOD_NAME
,      PRIM_AMOUNT_G
,      SEC_AMOUNT_G
,      COMPANY_COST_CENTER_ORG_ID
,      COMPANY_ID
,      COST_CENTER_ID
,      FIN_CATEGORY_ID
,      CATEGORY_ID
,      USER_DIM1_ID
,      USER_DIM2_ID
,      CODE_COMBINATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LEDGER_ID
,      BUDGET_VERSION_ID
,      CURRENCY_CODE
FROM FII.FII_GL_BUDGET_EXTRACT_T;

Dependencies

[top of page]

FII.FII_GL_BUDGET_EXTRACT_T does not reference any database object

FII.FII_GL_BUDGET_EXTRACT_T is referenced by following:

APPS: FII_GL_BUDGET_EXTRACT_T