VIEW: APPS.PA_FP_WEBADI_NP_CUSTOM_V

Source

View Text - Preformatted

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, cost_code, cost_code_name from pa_fp_webadi_non_periodic_v order by task_display_sequence, resource_name, uom, currency

View Text - HTML Formatted

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