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_INTERFACE

Object Details

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

Indexes

Index	Type	Uniqueness	Tablespace	Column
FII_BUDGET_INTERFACE_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PLAN_TYPE_CODE REPORT_TIME_PERIOD LEDGER_ID FIN_CATEGORY_ID COMPANY_ID COST_CENTER_ID USER_DIM1_ID PROD_CATEGORY_ID VERSION_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
PLAN_TYPE_CODE	VARCHAR2	(2)	Yes	Budget/Forecast
PRIM_AMOUNT_G	NUMBER		Yes	Primary Amount
REPORT_TIME_PERIOD	VARCHAR2	(100)		Report Time Period
REPORT_DATE	DATE			Report Date
COMPANY_COST_CENTER	VARCHAR2	(240)		Company Cost Center
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
CONVERSION_RATE	NUMBER			Conversion Rate
SEC_AMOUNT_G	NUMBER			Secondary Amount
FIN_CATEGORY_ID	NUMBER	(15)		Financial Category Identifier
COMPANY_COST_CENTER_ORG_ID	NUMBER	(15)		Company Cost Center Organization Identifier
PROD_CATEGORY_ID	NUMBER	(15)		Product Category Identifier
STATUS_CODE	VARCHAR2	(30)		Status Code
LEDGER_ID	NUMBER	(15)		Ledger Identifier
LEDGER	VARCHAR2	(150)		Ledger
COMPANY_ID	NUMBER	(15)		Company Identifier
COMPANY	VARCHAR2	(150)		Company
COST_CENTER_ID	NUMBER	(15)		Cost Center Identifier
COST_CENTER	VARCHAR2	(150)		Cost Center
USER_DIM1_ID	NUMBER	(15)		User-defined Dimension 1 Identifier
USER_DIM1	VARCHAR2	(150)		User-defined Dimension 1
USER_DIM2_ID	NUMBER	(15)		User-defined Dimension 2 Identifier
USER_DIM2	VARCHAR2	(150)		User-defined Dimension 2
VERSION_DATE	DATE			Version Date
UPLOAD_DATE	DATE			Upload Date

Query Text

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


SELECT PLAN_TYPE_CODE
,      PRIM_AMOUNT_G
,      REPORT_TIME_PERIOD
,      REPORT_DATE
,      COMPANY_COST_CENTER
,      LINE_OF_BUSINESS
,      NATURAL_ACCOUNT
,      FIN_ITEM
,      PRODUCT_CODE
,      CONVERSION_RATE
,      SEC_AMOUNT_G
,      FIN_CATEGORY_ID
,      COMPANY_COST_CENTER_ORG_ID
,      PROD_CATEGORY_ID
,      STATUS_CODE
,      LEDGER_ID
,      LEDGER
,      COMPANY_ID
,      COMPANY
,      COST_CENTER_ID
,      COST_CENTER
,      USER_DIM1_ID
,      USER_DIM1
,      USER_DIM2_ID
,      USER_DIM2
,      VERSION_DATE
,      UPLOAD_DATE
FROM FII.FII_BUDGET_INTERFACE;

Dependencies

[top of page]

FII.FII_BUDGET_INTERFACE does not reference any database object

FII.FII_BUDGET_INTERFACE is referenced by following:

APPS: FII_BUDGET_INTERFACE