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.FV_BUDGETS_WITH_DATES_V

Object Details

Object Name:	FV_BUDGETS_WITH_DATES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FV.FV_BUDGETS_WITH_DATES_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

FV_BUDGETS_WITH_DATES_V stores budget information for the Set of Books.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BUDGET_NAME	VARCHAR2	(15)	Yes	Budget name
BUDGET_TYPE	VARCHAR2	(15)	Yes	Budget type
BUDGET_VERSION_ID	NUMBER	(15)	Yes	Budget version identifier
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books identifier
FIRST_VALID_PERIOD_NAME	VARCHAR2	(15)		First valid period name
LAST_VALID_PERIOD_NAME	VARCHAR2	(15)		Last valid period name
LATEST_OPENED_YEAR	NUMBER	(15)		Latest opened year
REQUIRE_BUDGET_JOURNALS_FLAG	VARCHAR2	(1)	Yes	Budget journal flag
STATUS	VARCHAR2	(1)	Yes	Status
START_DATE	DATE		Yes	Start date
END_DATE	DATE		Yes	End date

Query Text

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


SELECT BUDGET_NAME
,      BUDGET_TYPE
,      BUDGET_VERSION_ID
,      SET_OF_BOOKS_ID
,      FIRST_VALID_PERIOD_NAME
,      LAST_VALID_PERIOD_NAME
,      LATEST_OPENED_YEAR
,      REQUIRE_BUDGET_JOURNALS_FLAG
,      STATUS
,      START_DATE
,      END_DATE
FROM APPS.FV_BUDGETS_WITH_DATES_V;

Dependencies

[top of page]

APPS.FV_BUDGETS_WITH_DATES_V references the following:

APPS: GL_BUDGETS; GL_BUDGET_VERSIONS; GL_PERIOD_STATUSES

APPS.FV_BUDGETS_WITH_DATES_V is not referenced by any database object