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

VIEW: APPS.PA_FP_WEBADI_NP_CUSTOM_V

Object Details
Object Name: PA_FP_WEBADI_NP_CUSTOM_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_FP_WEBADI_NP_CUSTOM_V
Subobject Name:
Status: VALID

View Type

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


This view is used in Financial Planning to customize the non-periodic budget/forecast download to Excel Spreadsheet.


[View Source]

Columns
Name Datatype Length Mandatory Comments
BUDGET_VERSION_ID NUMBER (15) Yes Identifier of the plan version.
FIN_PLAN_PREFERENCE_CODE VARCHAR2 (30)
Indicates the planning preference.
PLAN_CLASS_CODE VARCHAR2 (30) Yes Plan Class for the plan type.
PROJECT_ID NUMBER (15) Yes Identifier of the project for which the budget is entered
PROJECT_NAME VARCHAR2 (30) Yes The name of the project for which the budget is entered
PROJECT_NUMBER VARCHAR2 (25) Yes User-defined number that uniquely identifies the project for which the budget is entered
RESOURCE_ASSIGNMENT_ID NUMBER (15) Yes The system-generated number that uniquely identifies the resource list member.
TASK_NUMBER VARCHAR2 (100)
User-defined number that uniquely identifies the task within a project.
TASK_NAME VARCHAR2 (240)
User-defined short name of the task.
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 (15) Yes 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) Yes The unit of measure of the resource.
DESCRIPTION VARCHAR2 (4000)
The description of the budget line.
CHANGE_REASON VARCHAR2 (4000)
The reason to create the budget line.
SPREAD_CURVE_ID NUMBER (15)
System-generated number that uniquely identifies the spread curve.
SPREAD_CURVE VARCHAR2 (240) Yes Indicates the spread curve name.
MFC_COST_TYPE_ID NUMBER (15)
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 quantity of the budget line.
ACTUAL_QUANTITY NUMBER

The actual quantity in the budget line.
ETC_QUANTITY NUMBER

The estimate to complete quantity of the budget line.
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 raw cost of the budget line.
ACTUAL_RAW_COST NUMBER

The actual raw cost in the budget line.
ETC_RAW_COST NUMBER

The estimate to complete raw cost of the budget line.
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 burdened cost of the budget line.
ACTUAL_BURDENED_COST NUMBER

The actual burden cost in the budget line.
ETC_BURDENED_COST NUMBER

The estimate to complete burdened cost of the budget line.
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 revenue of the budget line.
ACTUAL_REVENUE NUMBER

The actual revenue in the budget line.
ETC_REVENUE NUMBER

The estimate to complete revenue of the budget line.
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 raw 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 raw cost rate of the budget line.
BURDENED_COST_RATE NUMBER

The burdened cost rate of the budget line.
BILL_RATE NUMBER

The bill rate of the budget line.
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.
CUSTOM_COL1 VARCHAR2 (0)
User customizable column 1.
CUSTOM_COL2 VARCHAR2 (0)
User customizable column 2.
CUSTOM_COL3 VARCHAR2 (0)
User customizable column 3.
CUSTOM_COL4 VARCHAR2 (0)
User customizable column 4.
CUSTOM_COL5 VARCHAR2 (0)
User customizable column 5.
CUSTOM_COL6 VARCHAR2 (0)
User customizable column 6.
CUSTOM_COL7 VARCHAR2 (0)
User customizable column 7.
CUSTOM_COL8 VARCHAR2 (0)
User customizable column 8.
CUSTOM_COL9 VARCHAR2 (0)
User customizable column 9.
CUSTOM_COL10 VARCHAR2 (0)
User customizable column 10.
CUSTOM_COL11 VARCHAR2 (0)
User customizable column 11.
CUSTOM_COL12 VARCHAR2 (0)
User customizable column 12.
CUSTOM_COL13 VARCHAR2 (0)
User customizable column 13.
CUSTOM_COL14 VARCHAR2 (0)
User customizable column 14.
CUSTOM_COL15 VARCHAR2 (0)
User customizable column 15.
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_NUMBER
,      TASK_NAME
,      TASK_DISPLAY_SEQUENCE
,      RESOURCE_NAME
,      RESOURCE_LIST_MEMBER_ID
,      START_DATE
,      END_DATE
,      CURRENCY
,      UOM
,      DESCRIPTION
,      CHANGE_REASON
,      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
,      CUSTOM_COL1
,      CUSTOM_COL2
,      CUSTOM_COL3
,      CUSTOM_COL4
,      CUSTOM_COL5
,      CUSTOM_COL6
,      CUSTOM_COL7
,      CUSTOM_COL8
,      CUSTOM_COL9
,      CUSTOM_COL10
,      CUSTOM_COL11
,      CUSTOM_COL12
,      CUSTOM_COL13
,      CUSTOM_COL14
,      CUSTOM_COL15
FROM APPS.PA_FP_WEBADI_NP_CUSTOM_V;

Dependencies

[top of page]

APPS.PA_FP_WEBADI_NP_CUSTOM_V references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
PL/SQL PackagePA_CROSS_BUSINESS_GRP - show dependent code
PL/SQL PackagePA_FIN_PLAN_UTILS - show dependent code
PL/SQL PackagePA_FIN_PLAN_UTILS2 - show dependent code
ViewPA_FP_WEBADI_NON_PERIODIC_V
PL/SQL PackagePA_FP_WEBADI_UTILS - show dependent code
PL/SQL PackagePA_PLANNING_ELEMENT_UTILS - show dependent code

APPS.PA_FP_WEBADI_NP_CUSTOM_V is not referenced by any database object