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]

VIEW: APPS.FII_PA_BUDGET_F_FCV

Object Details

Object Name:	FII_PA_BUDGET_F_FCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FII.FII_PA_BUDGET_F_FCV
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.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SEQ_ID	VARCHAR2	(0)
BUDGET_LINE_PK	VARCHAR2	(82)
INSTANCE_FK	VARCHAR2	(30)
SET_OF_BOOKS_FK	VARCHAR2	(71)
PROJECT_FK	VARCHAR2	(78)
PROJECT_ORG_FK	VARCHAR2	(0)
BUDGET_FK	VARCHAR2	(71)
EXPENDITURE_TYPE_FK	VARCHAR2	(271)
CURRENCY_GL_FK	VARCHAR2	(15)	Yes
GL_PERIOD_FK	VARCHAR2	(82)
PA_PERIOD_FK	VARCHAR2	(82)
UNIT_OF_MEASURE_FK	VARCHAR2	(4000)
RANGE_FROM_DATE	DATE		Yes
RANGE_TO_DATE	DATE		Yes
DESCRIPTION	VARCHAR2	(240)
RAW_COST_G	VARCHAR2	(0)
RAW_COST_B	NUMBER
BURDENED_COST_G	VARCHAR2	(0)
BURDENED_COST_B	NUMBER
QUANTITY	NUMBER
REVENUE_G	VARCHAR2	(0)
REVENUE_B	NUMBER
GLOBAL_CURRENCY_RATE	NUMBER
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
USER_MEASURE1	NUMBER
USER_MEASURE2	NUMBER
USER_MEASURE3	NUMBER
USER_MEASURE4	NUMBER
USER_MEASURE5	NUMBER
USER_ATTRIBUTE1	VARCHAR2	(0)
USER_ATTRIBUTE2	VARCHAR2	(0)
USER_ATTRIBUTE3	VARCHAR2	(0)
USER_ATTRIBUTE4	VARCHAR2	(0)
USER_ATTRIBUTE5	VARCHAR2	(0)
USER_ATTRIBUTE6	VARCHAR2	(0)
USER_ATTRIBUTE7	VARCHAR2	(0)
USER_ATTRIBUTE8	VARCHAR2	(0)
USER_ATTRIBUTE9	VARCHAR2	(0)
USER_ATTRIBUTE10	VARCHAR2	(0)
USER_FK1	CHAR	(6)
USER_FK2	CHAR	(6)
USER_FK3	CHAR	(6)
USER_FK4	CHAR	(6)
USER_FK5	CHAR	(6)
TRANSACTION_DATE	DATE

Query Text

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


SELECT SEQ_ID
,      BUDGET_LINE_PK
,      INSTANCE_FK
,      SET_OF_BOOKS_FK
,      PROJECT_FK
,      PROJECT_ORG_FK
,      BUDGET_FK
,      EXPENDITURE_TYPE_FK
,      CURRENCY_GL_FK
,      GL_PERIOD_FK
,      PA_PERIOD_FK
,      UNIT_OF_MEASURE_FK
,      RANGE_FROM_DATE
,      RANGE_TO_DATE
,      DESCRIPTION
,      RAW_COST_G
,      RAW_COST_B
,      BURDENED_COST_G
,      BURDENED_COST_B
,      QUANTITY
,      REVENUE_G
,      REVENUE_B
,      GLOBAL_CURRENCY_RATE
,      LAST_UPDATE_DATE
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE10
,      USER_FK1
,      USER_FK2
,      USER_FK3
,      USER_FK4
,      USER_FK5
,      TRANSACTION_DATE
FROM APPS.FII_PA_BUDGET_F_FCV;

Dependencies

[top of page]

APPS.FII_PA_BUDGET_F_FCV references the following:

APPS: EDW_CURRENCY - show dependent code; EDW_UTIL - show dependent code; FIIBV_PA_BUDGET_F_FCV

APPS.FII_PA_BUDGET_F_FCV is referenced by following:

APPS: FII_PA_BUDGET_F_C - show dependent code