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

Object Details

Object Name:	PA_ORIG_BUDGET_BY_GL_PERIOD_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_ORIG_BUDGET_BY_GL_PERIOD_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BUDGET_VERSION_ID	NUMBER	(15)	Yes	The identifier of the budget version
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project
TASK_ID	NUMBER	(15)	Yes	The identifier of the Task
BUDGET_TYPE_CODE	VARCHAR2	(30)		Type of budget
GL_PERIOD_NAME	VARCHAR2	(15)	Yes	GL period name
PERIOD_YEAR	NUMBER	(15)	Yes	GL period year
PERIOD_START_DATE	DATE		Yes	GL period start date
PERIOD_END_DATE	DATE		Yes	GL period end date
RESOURCE_ALIAS	NUMBER	(15)	Yes	Name of the resource
RESOURCE_LIST_MEMBER_ID	VARCHAR2	(80)		The identifier of the resource list member
RESOURCE_LIST_ID	NUMBER	(15)	Yes	The identifier of the resource list
RESOURCE_ID	NUMBER	(15)	Yes	The identifier of the resource
RESOURCE_ACCUMULATED_FLAG	VARCHAR2	(1)	Yes	Flag that indicates whether the budget version is summarized by resource
RAW_COST	NUMBER			The raw cost budget of the project
BURDENED_COST	NUMBER			The burdened cost budget of the project
REVENUE	NUMBER			The revenue budget of the project
QUANTITY	NUMBER			The quantity budgeted for the project
LABOR_QUANTITY	NUMBER			The number of labor hours budgeted for the project
UNIT_OF_MEASURE	VARCHAR2	(30)		Unit of measure of the resource
ORG_ID	NUMBER	(15)	Yes	The identifier of the operating unit

Query Text

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


SELECT BUDGET_VERSION_ID
,      PROJECT_ID
,      TASK_ID
,      BUDGET_TYPE_CODE
,      GL_PERIOD_NAME
,      PERIOD_YEAR
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      RESOURCE_ALIAS
,      RESOURCE_LIST_MEMBER_ID
,      RESOURCE_LIST_ID
,      RESOURCE_ID
,      RESOURCE_ACCUMULATED_FLAG
,      RAW_COST
,      BURDENED_COST
,      REVENUE
,      QUANTITY
,      LABOR_QUANTITY
,      UNIT_OF_MEASURE
,      ORG_ID
FROM APPS.PA_ORIG_BUDGET_BY_GL_PERIOD_V;

Dependencies

[top of page]

APPS.PA_ORIG_BUDGET_BY_GL_PERIOD_V references the following:

APPS: GL_PERIOD_STATUSES; PA_BUDGET_ENTRY_METHODS; PA_BUDGET_LINES; PA_BUDGET_VERSIONS; PA_IMPLEMENTATIONS; PA_MISC - show dependent code; PA_PERIOD_PROCESS_PKG - show dependent code; PA_RESOURCE_ASSIGNMENTS; PA_RESOURCE_LIST_MEMBERS

APPS.PA_ORIG_BUDGET_BY_GL_PERIOD_V is not referenced by any database object