VIEW: APPS.PA_FP_WEBADI_PERIODIC_V

Source

View Text - Preformatted

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, cost_code, cost_code_name from pa_fp_webadi_xface_tmp

View Text - HTML Formatted

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
, COST_CODE
, COST_CODE_NAME
FROM PA_FP_WEBADI_XFACE_TMP