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_FP_WEBADI_NON_PERIODIC_V

Object Details

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

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
BUDGET_VERSION_ID	NUMBER	(15)	Identifier of the plan version.
FIN_PLAN_PREFERENCE_CODE	VARCHAR2	(30)	Indicates the planning preference.
PLAN_CLASS_CODE	VARCHAR2	(30)	Plan Class for the plan type.
PROJECT_ID	NUMBER	(15)	Identifier of the project for which the budget is entered
PROJECT_NAME	VARCHAR2	(30)	The name of the project for which the budget is entered
PROJECT_NUMBER	VARCHAR2	(25)	User-defined number that uniquely identifies the project for which the budget is entered
RESOURCE_ASSIGNMENT_ID	NUMBER		The system-generated number that uniquely identifies the resource list member.
TASK_NAME	VARCHAR2	(240)	User-defined short name of the task.
TASK_NUMBER	VARCHAR2	(100)	User-defined number that uniquely identifies the task within a project.
TASK_DISPLAY_SEQUENCE	NUMBER		Display Sequence of the task within the project.
RESOURCE_NAME	VARCHAR2	(80)	User-defined short name for a resource.
RESOURCE_LIST_MEMBER_ID	NUMBER		System-generated number that uniquely identifies a member within a resource list .
START_DATE	DATE		Indicates the planning start date.
END_DATE	DATE		Indicates the planning end date.
CURRENCY	VARCHAR2	(4000)	The transaction currency code of the amount.
UOM	VARCHAR2	(80)	The unit of measure of the resource.
DESCRIPTION	VARCHAR2	(4000)	The description of the budget line.
SPREAD_CURVE_ID	NUMBER		System-generated number that uniquely identifies the spread curve.
SPREAD_CURVE	VARCHAR2	(240)	Indicates the spread curve name.
MFC_COST_TYPE_ID	NUMBER		System-generated number that uniquely identifies the manufacturing source.
MFC_COST_TYPE	VARCHAR2	(10)	Indicates the manufacturing source.
ETC_METHOD_CODE	VARCHAR2	(30)	Identifier of the estimate to complete method.
ETC_METHOD	VARCHAR2	(80)	Indicates the estimate to complete method.
DELETE_FLAG	VARCHAR2	(0)	Indicator for deleting data.
QUANTITY	NUMBER		The total display quantity at the planning transaction level.
ACTUAL_QUANTITY	NUMBER		The total initial quantity at the planning transaction level.
ETC_QUANTITY	NUMBER		The estimate to complete quantity at the planning transaction level.
CURRENT_QUANTITY	NUMBER		The quantity in the current budget version.
ORIGINAL_QUANTITY	NUMBER		The quantity in the original budget version.
PRIOR_FORECAST_QUANTITY	NUMBER		The quantity in the prior forecast version.
RAW_COST	NUMBER		The total raw cost in transaction currency at the planning transaction level.
ACTUAL_RAW_COST	NUMBER		The total initial raw cost in transation currency at the planning transaction level.
ETC_RAW_COST	NUMBER		The estimate to complete raw cost in transaction currency at the planning transaction level.
CURRENT_RAW_COST	NUMBER		The raw cost in the current budget version.
ORIGINAL_RAW_COST	NUMBER		The raw cost if the original budget version.
PRIOR_FORECAST_RAW_COST	NUMBER		The raw cost in the prior forecast version.
BURDENED_COST	NUMBER		The total burdened cost in transation currency at the planning transation level.
ACTUAL_BURDENED_COST	NUMBER		The total initial burdened cost in transaction currency at the planning transaction level.
ETC_BURDENED_COST	NUMBER		The estimate to complete burdened cost in transation currency at the planning transation level.
CURRENT_BURDENED_COST	NUMBER		The burdened cost in the current budget version.
ORIGINAL_BURDENED_COST	NUMBER		The burdened cost in the original budget version.
PRIOR_FORECAST_BURDENED_COST	NUMBER		The burdened cost in the prior forecast version.
REVENUE	NUMBER		The total revenue in transation currency at the planning transation level.
ACTUAL_REVENUE	NUMBER		The total initial revenue in transation currency at the planning transation level.
ETC_REVENUE	NUMBER		The estimate to complete revenue in transation currency at the planning transation level.
CURRENT_REVENUE	NUMBER		The revenue in the current budget version.
ORIGINAL_REVENUE	NUMBER		The revenue in the original budget version.
PRIOR_FORECAST_REVENUE	NUMBER		The revenue in the prior forecast version.
RAW_COST_OVER_RATE	NUMBER		The overriding cost rate at the planning transaction level.
BURDENED_COST_OVER_RATE	NUMBER		The overriding burden cost rate at the planning transaction level.
BILL_OVER_RATE	NUMBER		The overriding bill rate at the planning transaction level.
RAW_COST_RATE	NUMBER		The average raw cost rate at the planning transation level.
BURDENED_COST_RATE	NUMBER		The average burdened cost rate at the planning transaction level.
BILL_RATE	NUMBER		The average bill rate at the planning transaction level.
ETC_RAW_COST_RATE	NUMBER		The ETC raw cost rate at the planning transaction level.
ETC_BURDENED_COST_RATE	NUMBER		The ETC burden cost rate at the planning transaction level.
ETC_BILL_RATE	NUMBER		The ETC bill rate at the planning transaction level.
PROJFUNC_COST_RATE_TYPE	VARCHAR2	(30)	The project functional cost rate type.
PROJFUNC_COST_RATE_DATE_TYPE	VARCHAR2	(80)	The project functional cost rate date type.
PROJECT_COST_RATE_TYPE	VARCHAR2	(30)	The project cost rate type.
PROJECT_COST_RATE_DATE_TYPE	VARCHAR2	(80)	The project cost rate date type.
PROJFUNC_REV_RATE_TYPE	VARCHAR2	(30)	The project functional revenue rate type.
PROJFUNC_REV_RATE_DATE_TYPE	VARCHAR2	(80)	The project functional revenue rate date type.
PROJECT_REV_RATE_TYPE	VARCHAR2	(30)	The project revenue rate type.
PROJECT_REV_RATE_DATE_TYPE	VARCHAR2	(80)	The project revenue rate date type.
PROJFUNC_COST_RATE	NUMBER		The project functional cost exchange rate.
PROJFUNC_COST_RATE_DATE	DATE		The cost rate date for project functional currency.
PROJECT_COST_RATE	NUMBER		The project cost exchange rate.
PROJECT_COST_RATE_DATE	DATE		The cost rate date for project currency.
PROJFUNC_REV_RATE	NUMBER		The project functional revenue exchange rate.
PROJFUNC_REV_RATE_DATE	DATE		The revenue rate date for project functional currency.
PROJECT_REV_RATE	NUMBER		The project revenue exchange rate.
PROJECT_REV_RATE_DATE	DATE		The revenue rate date for project currency.
PHYSICAL_PERCENT_COMPLETE	NUMBER		Indicates the Task Physical Percentage Completion.
ETC_SOURCE	VARCHAR2	(80)	Indicates the Transaction source code.
CHANGE_REASON	VARCHAR2	(4000)	The reason to create the budget line.
RECORD_VERSION_NUMBER	NUMBER		Record version number of the plan being processed.
COST_CODE	VARCHAR2	(250)	Cost Code selected for the task assignment.
COST_CODE_NAME	VARCHAR2	(240)	Cost Code Name selected for the task assignment.

Query Text

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


SELECT BUDGET_VERSION_ID
,      FIN_PLAN_PREFERENCE_CODE
,      PLAN_CLASS_CODE
,      PROJECT_ID
,      PROJECT_NAME
,      PROJECT_NUMBER
,      RESOURCE_ASSIGNMENT_ID
,      TASK_NAME
,      TASK_NUMBER
,      TASK_DISPLAY_SEQUENCE
,      RESOURCE_NAME
,      RESOURCE_LIST_MEMBER_ID
,      START_DATE
,      END_DATE
,      CURRENCY
,      UOM
,      DESCRIPTION
,      SPREAD_CURVE_ID
,      SPREAD_CURVE
,      MFC_COST_TYPE_ID
,      MFC_COST_TYPE
,      ETC_METHOD_CODE
,      ETC_METHOD
,      DELETE_FLAG
,      QUANTITY
,      ACTUAL_QUANTITY
,      ETC_QUANTITY
,      CURRENT_QUANTITY
,      ORIGINAL_QUANTITY
,      PRIOR_FORECAST_QUANTITY
,      RAW_COST
,      ACTUAL_RAW_COST
,      ETC_RAW_COST
,      CURRENT_RAW_COST
,      ORIGINAL_RAW_COST
,      PRIOR_FORECAST_RAW_COST
,      BURDENED_COST
,      ACTUAL_BURDENED_COST
,      ETC_BURDENED_COST
,      CURRENT_BURDENED_COST
,      ORIGINAL_BURDENED_COST
,      PRIOR_FORECAST_BURDENED_COST
,      REVENUE
,      ACTUAL_REVENUE
,      ETC_REVENUE
,      CURRENT_REVENUE
,      ORIGINAL_REVENUE
,      PRIOR_FORECAST_REVENUE
,      RAW_COST_OVER_RATE
,      BURDENED_COST_OVER_RATE
,      BILL_OVER_RATE
,      RAW_COST_RATE
,      BURDENED_COST_RATE
,      BILL_RATE
,      ETC_RAW_COST_RATE
,      ETC_BURDENED_COST_RATE
,      ETC_BILL_RATE
,      PROJFUNC_COST_RATE_TYPE
,      PROJFUNC_COST_RATE_DATE_TYPE
,      PROJECT_COST_RATE_TYPE
,      PROJECT_COST_RATE_DATE_TYPE
,      PROJFUNC_REV_RATE_TYPE
,      PROJFUNC_REV_RATE_DATE_TYPE
,      PROJECT_REV_RATE_TYPE
,      PROJECT_REV_RATE_DATE_TYPE
,      PROJFUNC_COST_RATE
,      PROJFUNC_COST_RATE_DATE
,      PROJECT_COST_RATE
,      PROJECT_COST_RATE_DATE
,      PROJFUNC_REV_RATE
,      PROJFUNC_REV_RATE_DATE
,      PROJECT_REV_RATE
,      PROJECT_REV_RATE_DATE
,      PHYSICAL_PERCENT_COMPLETE
,      ETC_SOURCE
,      CHANGE_REASON
,      RECORD_VERSION_NUMBER
,      COST_CODE
,      COST_CODE_NAME
FROM APPS.PA_FP_WEBADI_NON_PERIODIC_V;

Dependencies

[top of page]

APPS.PA_FP_WEBADI_NON_PERIODIC_V references the following:

APPS: CST_COST_TYPES_V; FND_PROFILE - show dependent code; PA_BUDGET_VERSIONS; PA_CONVERSION_TYPES_V; PA_CROSS_BUSINESS_GRP - show dependent code; PA_FIN_PLAN_TYPES_B; PA_FIN_PLAN_UTILS - show dependent code; PA_FIN_PLAN_UTILS2 - show dependent code; PA_FP_TXN_CURRENCIES; PA_FP_WEBADI_UTILS - show dependent code; PA_LOOKUPS; PA_PLANNING_ELEMENT_UTILS - show dependent code; PA_PROJECTS_ALL; PA_PROJ_ELEMENTS; PA_PROJ_ELEMENT_VERSIONS; PA_PROJ_ELEM_VER_STRUCTURE; PA_PROJ_FP_OPTIONS; PA_RBS_ELEMENTS; PA_RESOURCE_ASGN_CURR; PA_RESOURCE_ASSIGNMENTS; PA_RESOURCE_LISTS; PA_RESOURCE_LIST_MEMBERS; PA_SPREAD_CURVES_TL

APPS.PA_FP_WEBADI_NON_PERIODIC_V is referenced by following:

APPS: PA_FP_WEBADI_NP_CUSTOM_V