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_BASE_FINPLAN_BY_GL_PERIOD_V

Object Details

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

View Type

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

This view displays budget lines by GL period, for a baselined financial plan

[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
FIN_PLAN_TYPE_ID	NUMBER	(15)		The identifier of the financial plan type
VERSION_TYPE	VARCHAR2	(30)		Indicates if the version is planned for COST or REVENUE or ALL (Cost and Revenue together)
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_LIST_MEMBER_ID	NUMBER	(15)	Yes	The identifier of the resource list member
RESOURCE_ALIAS	VARCHAR2	(80)		Name of the resource
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 for financial plan type
BURDENED_COST	NUMBER			The burdened cost budget of the project for financial plan type
REVENUE	NUMBER			The revenue budget of the project for financial plan type
QUANTITY	NUMBER			The quantity budgeted for the project for financial plan type
DISPLAY_QUANTITY	NUMBER			Same as Quantity except for amount based transaction, transactions for which amount only was entered and quantity was not entered, this field would be blank
LABOR_QUANTITY	NUMBER			The number of labor hours budgeted for the project for financial plan type
UNIT_OF_MEASURE	VARCHAR2	(30)		Unit of measure of the resource for financial plan type
RESOURCE_UOM	VARCHAR2	(30)		Unit of measure of the resource in the planning transaction
APPROVED_COST_PLAN_TYPE_FLAG	VARCHAR2	(1)		Flag that indicates plan type is approved cost version
APPROVED_REV_PLAN_TYPE_FLAG	VARCHAR2	(1)		Flag that indicates plan type is approved revenue version
RBS_VERSION_ID	NUMBER			The identifier of the resource breakdown structure
RBS_ELEMENT_ID	NUMBER	(15)		The identifier resource breakdown structure element id
PRIMARY_COST_FORECAST_FLAG	VARCHAR2	(1)		Flag that indicates plan type is a primary cost forecast
PRIMARY_REV_FORECAST_FLAG	VARCHAR2	(1)		Flag that indicates plan type is a primary revenue forecast
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
,      FIN_PLAN_TYPE_ID
,      VERSION_TYPE
,      GL_PERIOD_NAME
,      PERIOD_YEAR
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      RESOURCE_LIST_MEMBER_ID
,      RESOURCE_ALIAS
,      RESOURCE_LIST_ID
,      RESOURCE_ID
,      RESOURCE_ACCUMULATED_FLAG
,      RAW_COST
,      BURDENED_COST
,      REVENUE
,      QUANTITY
,      DISPLAY_QUANTITY
,      LABOR_QUANTITY
,      UNIT_OF_MEASURE
,      RESOURCE_UOM
,      APPROVED_COST_PLAN_TYPE_FLAG
,      APPROVED_REV_PLAN_TYPE_FLAG
,      RBS_VERSION_ID
,      RBS_ELEMENT_ID
,      PRIMARY_COST_FORECAST_FLAG
,      PRIMARY_REV_FORECAST_FLAG
,      ORG_ID
FROM APPS.PA_BASE_FINPLAN_BY_GL_PERIOD_V;

Dependencies

[top of page]

APPS.PA_BASE_FINPLAN_BY_GL_PERIOD_V references the following:

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

APPS.PA_BASE_FINPLAN_BY_GL_PERIOD_V is referenced by following:

APPS: PA_ALLOC_RUN - show dependent code