DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PA_ORIG_FINPLAN_BY_GL_PERIOD_V

Object Details
Object Name: PA_ORIG_FINPLAN_BY_GL_PERIOD_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_ORIG_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 the original 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
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)
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
,      PRIMARY_COST_FORECAST_FLAG
,      PRIMARY_REV_FORECAST_FLAG
,      ORG_ID
FROM APPS.PA_ORIG_FINPLAN_BY_GL_PERIOD_V;

Dependencies

[top of page]

APPS.PA_ORIG_FINPLAN_BY_GL_PERIOD_V references the following:

SchemaAPPS
SynonymGL_PERIOD_STATUSES
SynonymPA_BUDGET_LINES
SynonymPA_BUDGET_VERSIONS
PL/SQL PackagePA_FIN_PLAN_UTILS - show dependent code
SynonymPA_IMPLEMENTATIONS
PL/SQL PackagePA_MISC - show dependent code
PL/SQL PackagePA_PERIOD_PROCESS_PKG - show dependent code
SynonymPA_RESOURCE_ASSIGNMENTS
SynonymPA_RESOURCE_LIST_MEMBERS

APPS.PA_ORIG_FINPLAN_BY_GL_PERIOD_V is not referenced by any database object