View: PA_FP_WEBADI_NP_CUSTOM_V

Product:	PA - Projects
Description:	This view is used in Financial Planning to customize the non-periodic budget/forecast download to Excel Spreadsheet.
Implementation/DBA Data:	APPS.PA_FP_WEBADI_NP_CUSTOM_V

View Text

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
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, RECORD_VERSION_NUMBER
FROM PA_FP_WEBADI_NON_PERIODIC_V ORDER BY TASK_DISPLAY_SEQUENCE
, RESOURCE_NAME
, UOM
, CURRENCY

Columns