VIEW: APPS.PA_FP_WEBADI_CUSTOM_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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