View: PA_FP_WEBADI_PERIODIC_V

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

View Text

SELECT BUDGET_VERSION_ID
, FIN_PLAN_PREFERENCE_CODE
, PLAN_CLASS_CODE
, PROJECT_NAME
, PROJECT_NUMBER
, PROJECT_ID
, RESOURCE_ASSIGNMENT_ID
, TASK_NAME
, TASK_NUMBER
, TASK_DISPLAY_SEQUENCE
, RESOURCE_ALIAS
, RESOURCE_LIST_MEMBER_ID
, UNIT_OF_MEASURE
, TXN_CURRENCY_CODE
, AMOUNT_TYPE_CODE
, AMOUNT_TYPE_NAME
, SPREAD_CURVE_ID
, SPREAD_CURVE
, START_DATE
, END_DATE
, MFC_COST_TYPE_ID
, MFC_COST_TYPE
, ETC_METHOD_CODE
, ETC_METHOD
, ETC_SOURCE
, DELETE_FLAG
, PROJFUNC_RATE_TYPE
, PROJFUNC_RATE_DATE_TYPE
, PROJFUNC_EXCHANGE_RATE
, PROJFUNC_RATE_DATE
, PROJECT_RATE_TYPE
, PROJECT_RATE_DATE_TYPE
, PROJECT_EXCHANGE_RATE
, PROJECT_RATE_DATE
, PRECEDING_PERIOD_AMOUNT
, 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_AMOUNT
, PHYSICAL_PERCENT_COMPLETE
, RECORD_VERSION_NUMBER
FROM PA_FP_WEBADI_XFACE_TMP

Columns