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_BUDGET_BASE

Object Details

Object Name:	FII_BUDGET_BASE
Object Type:	TABLE
Owner:	FII
FND Design Data:	FII.FII_BUDGET_BASE
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_BUDGET_BASE_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	PLAN_TYPE_CODE PERIOD_TYPE_ID TIME_ID LEDGER_ID FIN_CATEGORY_ID COMPANY_ID COST_CENTER_ID USER_DIM1_ID VERSION_DATE NO_VERSION_FLAG POSTED_DATE CATEGORY_ID COMPANY_COST_CENTER_ORG_ID USER_DIM2_ID
FII_BUDGET_BASE_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	LEDGER_ID FIN_CATEGORY_ID COMPANY_ID COST_CENTER_ID USER_DIM1_ID CATEGORY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PLAN_TYPE_CODE	VARCHAR2	(2)	Yes	Budget/Forecast
TIME_ID	NUMBER	(15)	Yes	Time Identifier
PERIOD_TYPE_ID	NUMBER	(15)	Yes	Period Type Identifier
PRIM_AMOUNT_G	NUMBER		Yes	Primary Amount Delta
SEC_AMOUNT_G	NUMBER			Secondary Amount Delta
CREATION_DATE	DATE		Yes	Standard Who Columns
CREATED_BY	NUMBER	(15)	Yes	Standard Who Columns
LAST_UPDATE_DATE	DATE		Yes	Standard Who Columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Columns
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Columns
COMPANY_COST_CENTER_ORG_ID	NUMBER	(15)		Company Cost Center Organization Identifier
LINE_OF_BUSINESS	VARCHAR2	(150)		Line of Business
NATURAL_ACCOUNT	VARCHAR2	(25)		Natural Account
FIN_ITEM	VARCHAR2	(150)		Financial Item
PRODUCT_CODE	VARCHAR2	(150)		Product Code
CATEGORY_ID	NUMBER	(15)		Category Identifier
FIN_CATEGORY_ID	NUMBER	(15)		Financial Category Identifier
LEDGER_ID	NUMBER	(15)		Ledger Identifier
COMPANY_ID	NUMBER	(15)		Company Identifier
COST_CENTER_ID	NUMBER	(15)		Cost Center Identifier
USER_DIM1_ID	NUMBER	(15)		User-defined Dimension 1 Identifier
USER_DIM2_ID	NUMBER	(15)		User-defined Dimension 2 Identifier
PRIM_AMOUNT_TOTAL	NUMBER			Primary Amount
SEC_AMOUNT_TOTAL	NUMBER			Secondary Amount
VERSION_DATE	DATE			Version Date
UPLOAD_DATE	DATE			Upload Date
NO_VERSION_FLAG	VARCHAR2	(1)		No Version Flag
POSTED_DATE	DATE			Posted Date
BASELINE_AMOUNT_PRIM	NUMBER			Baseline Amount Primary

Query Text

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


SELECT PLAN_TYPE_CODE
,      TIME_ID
,      PERIOD_TYPE_ID
,      PRIM_AMOUNT_G
,      SEC_AMOUNT_G
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      COMPANY_COST_CENTER_ORG_ID
,      LINE_OF_BUSINESS
,      NATURAL_ACCOUNT
,      FIN_ITEM
,      PRODUCT_CODE
,      CATEGORY_ID
,      FIN_CATEGORY_ID
,      LEDGER_ID
,      COMPANY_ID
,      COST_CENTER_ID
,      USER_DIM1_ID
,      USER_DIM2_ID
,      PRIM_AMOUNT_TOTAL
,      SEC_AMOUNT_TOTAL
,      VERSION_DATE
,      UPLOAD_DATE
,      NO_VERSION_FLAG
,      POSTED_DATE
,      BASELINE_AMOUNT_PRIM
FROM FII.FII_BUDGET_BASE;

Dependencies

[top of page]

FII.FII_BUDGET_BASE does not reference any database object

FII.FII_BUDGET_BASE is referenced by following:

APPS: FII_BUDGET_BASE; FII_GL_BASE_MAP2_MV; FII_GL_BASE_MAP_MV; FII_GL_BASE_MV