View: PA_FP_WEBADI_P_CUSTOM_V

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

View Text

SELECT BUDGET_VERSION_ID
, FIN_PLAN_PREFERENCE_CODE
, PROJECT_NAME
, RESOURCE_ASSIGNMENT_ID
, TASK_NUMBER
, TASK_NAME
, TASK_DISPLAY_SEQUENCE
, RESOURCE_NAME
, PLANNING_START_DATE
, PLANNING_END_DATE
, AMOUNT_TYPE_NAME
, AMOUNT_TYPE_CODE
, TXN_CURRENCY_CODE
, MFC_COST_TYPE
, ETC_METHOD
, ETC_SOURCE
, SPREAD_CURVE
, PRECEDING_PERIOD
, PRD1
, PRD2
, PRD3
, PRD4
, PRD5
, PRD6
, PRD7
, PRD8
, PRD9
, PRD10
, PRD11
, PRD12
, PRD13
, PRD14
, PRD15
, PRD16
, PRD17
, PRD18
, PRD19
, PRD20
, PRD21
, PRD22
, PRD23
, PRD24
, PRD25
, PRD26
, PRD27
, PRD28
, PRD29
, PRD30
, PRD31
, PRD32
, PRD33
, PRD34
, PRD35
, PRD36
, PRD37
, PRD38
, PRD39
, PRD40
, PRD41
, PRD42
, PRD43
, PRD44
, PRD45
, PRD46
, PRD47
, PRD48
, PRD49
, PRD50
, PRD51
, PRD52
, SUCCEEDING_PERIOD
, UNIT_OF_MEASURE
, PROJFUNC_RATE_TYPE
, PROJFUNC_RATE_DATE_TYPE
, PROJFUNC_RATE
, PROJFUNC_RATE_DATE
, PROJECT_RATE_TYPE
, PROJECT_RATE_DATE_TYPE
, PROJECT_RATE
, PROJECT_RATE_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DELETE_FLAG
, PHYSICAL_PERCENT_COMPLETE
, RECORD_VERSION_NUMBER
FROM PA_FP_WEBADI_PERIODIC_V ORDER BY TASK_DISPLAY_SEQUENCE
, RESOURCE_NAME
, UNIT_OF_MEASURE
, TXN_CURRENCY_CODE
, AMOUNT_TYPE_NAME

Columns