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

Object Details

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

A Business Intelligence System view

This shows information about versions of budgets.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BUDGET_VERSION_ID	NUMBER	(15)	Yes	Unique identifier for Budget Version
VERSION_NUMBER	NUMBER	(15)	Yes	Version Number
VERSION_NAME	VARCHAR2	(60)		Version Name
DESCRIPTION	VARCHAR2	(255)		Description
_LA:CURRENT_FLAG	CHAR	(47)		Current flag
_LA:ORIGINAL_FLAG	CHAR	(48)		Original flag
LABOR_QUANTITY	NUMBER			Labor Quantity
_LA:LABOR_UNIT_OF_MEASURE	CHAR	(53)		Labor Unit of measure
RAW_COST	NUMBER			Raw Cost
BURDENED_COST	NUMBER			Burdened Cost
REVENUE	NUMBER			Revenue
_LA:BUDGET_STATUS	CHAR	(59)		Budget Status
_LA:CHANGE_REASON	CHAR	(66)		Change Reason
_LA:CURRENT_ORIGINAL_FLAG	CHAR	(56)		Current Original flag
BASELINED_DATE	DATE			Baselined Date
_LA:PM_PRODUCT	CHAR	(58)		Project Management Product
PM_BUDGET_REFERENCE	VARCHAR2	(25)		Project Management Budget Reference
_LA:WF_STATUS	CHAR	(56)		Workflow Status
BASELINED_BY_PERSON_ID	NUMBER	(15)		Unique identifier for Baselined By Person
BASELINED_BY_PERSON_NAME	VARCHAR2	(240)		Baselined By Person Name
_DF	CHAR	(39)		Descriptive Flexfield
PROJECT_ID	NUMBER	(15)	Yes	Unique identifier for Project
PROJECT_NAME	VARCHAR2	(30)	Yes	Project Name
PROJECT_NUMBER	VARCHAR2	(25)	Yes	Project Number
BUDGET_TYPE_CODE	VARCHAR2	(30)		Budget Type Code
BUDGET_TYPE_NAME	VARCHAR2	(30)	Yes	Budget Type Name
RESOURCE_LIST_ID	NUMBER	(15)	Yes	Unique identifier for Resource List
RESOURCE_LIST_NAME	VARCHAR2	(60)		Resource List Name
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column.
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO column.
CREATION_DATE	DATE		Yes	Standard WHO column.
CREATED_BY	NUMBER		Yes	Standard WHO column.

Query Text

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


SELECT BUDGET_VERSION_ID
,      VERSION_NUMBER
,      VERSION_NAME
,      DESCRIPTION
,      _LA:CURRENT_FLAG
,      _LA:ORIGINAL_FLAG
,      LABOR_QUANTITY
,      _LA:LABOR_UNIT_OF_MEASURE
,      RAW_COST
,      BURDENED_COST
,      REVENUE
,      _LA:BUDGET_STATUS
,      _LA:CHANGE_REASON
,      _LA:CURRENT_ORIGINAL_FLAG
,      BASELINED_DATE
,      _LA:PM_PRODUCT
,      PM_BUDGET_REFERENCE
,      _LA:WF_STATUS
,      BASELINED_BY_PERSON_ID
,      BASELINED_BY_PERSON_NAME
,      _DF
,      PROJECT_ID
,      PROJECT_NAME
,      PROJECT_NUMBER
,      BUDGET_TYPE_CODE
,      BUDGET_TYPE_NAME
,      RESOURCE_LIST_ID
,      RESOURCE_LIST_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.PAFV_BUDGET_VERSIONS;

Dependencies

[top of page]

APPS.PAFV_BUDGET_VERSIONS references the following:

APPS: PA_BUDGET_TYPES; PA_BUDGET_VERSIONS; PA_PROJECTS_ALL; PA_RESOURCE_LISTS_ALL_BG; PER_ALL_PEOPLE_F

APPS.PAFV_BUDGET_VERSIONS is not referenced by any database object