View: PA_FP_WEBADI_CUSTOM_V

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

View Text

SELECT BUDGET_VERSION_ID
, FIN_PLAN_PREFERENCE_CODE
, PROJECT_NAME
, RESOURCE_ASSIGNMENT_ID
, TASK_NUM
, TASK_NAME
, RESOURCE_GP_NAME
, RESOURCE_NAME
, START_DATE
, END_DATE
, QUANTITY
, RAW_COST
, BURDENED_COST
, REVENUE
, AMOUNT_TYPE_NAME
, AMOUNT_TYPE_CODE
, AMOUNT_SUBTYPE_CODE
, DECODE(AMOUNT_SUBTYPE_CODE
, 'QUANTITY'
, 1
, 'RAW_COST'
, 2
, 'BURDENED_COST'
, 3
, 'REVENUE'
, 4
, 5) AS AMOUNT_TYPE_ORDER
, TXN_CURRENCY_CODE
, PRED_PERIODS
, SUCD_PERIODS
, 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
, UOM
, DESCRIPTION
, CHANGE_REASON
, PROJFUNC_CR_TYPE
, PROJFUNC_CR_DATE_TYPE
, PROJECT_CR_TYPE
, PROJECT_CR_DATE_TYPE
, PROJFUNC_RR_TYPE
, PROJFUNC_RR_DATE_TYPE
, PROJECT_RR_TYPE
, PROJECT_RR_DATE_TYPE
, PROJFUNC_COST_RATE
, PROJFUNC_CR_DATE
, PROJECT_COST_RATE
, PROJECT_CR_DATE
, PROJFUNC_REV_RATE
, PROJFUNC_RR_DATE
, PROJECT_REV_RATE
, PROJECT_RR_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, PROJFUNC_RATE_TYPE
, PROJFUNC_DATE_TYPE
, PROJECT_RATE_TYPE
, PROJECT_DATE_TYPE
, PROJFUNC_RATE
, PROJFUNC_DATE
, PROJECT_RATE
, PROJECT_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM PA_FP_WEBADI_CONTENTS_V
WHERE AMOUNT_SUBTYPE_CODE IN ('RAW_COST'
, 'BURDENED_COST'
, 'REVENUE'
, 'QUANTITY')
AND AMOUNT_SUBTYPE_CODE <> DECODE(FIN_PLAN_PREFERENCE_CODE
, 'COST_ONLY'
, 'REVENUE'
, 'REVENUE_ONLY'
, 'RAW_COST'
, 'XXX')
AND AMOUNT_SUBTYPE_CODE <> DECODE(FIN_PLAN_PREFERENCE_CODE
, 'REVENUE_ONLY'
, 'BURDENED_COST'
, 'XXX') ORDER BY TASK_NUM
, RESOURCE_GP_NAME
, RESOURCE_NAME
, UOM
, AMOUNT_TYPE_ORDER

Columns