VIEW: APPS.PA_FP_WEBADI_P_CUSTOM_V

Source

View Text - Preformatted

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, cost_code, cost_code_name from pa_fp_webadi_periodic_v order by task_display_sequence, resource_name, unit_of_measure, txn_currency_code, amount_type_name

View Text - HTML Formatted

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
, COST_CODE
, COST_CODE_NAME
FROM PA_FP_WEBADI_PERIODIC_V ORDER BY TASK_DISPLAY_SEQUENCE
, RESOURCE_NAME
, UNIT_OF_MEASURE
, TXN_CURRENCY_CODE
, AMOUNT_TYPE_NAME