VIEW: PA.PA_FP_WEBADI_XFACE_TMP1#

Source

View Text - Preformatted

select BUDGET_VERSION_ID BUDGET_VERSION_ID, PROJECT_ID PROJECT_ID, RESOURCE_ASSIGNMENT_ID RESOURCE_ASSIGNMENT_ID, RESOURCE_GROUP_NAME RESOURCE_GROUP_NAME, RESOURCE_ALIAS RESOURCE_ALIAS, PROJECT_NAME PROJECT_NAME, TASK_NAME TASK_NAME, TASK_NUMBER TASK_NUMBER, AMOUNT_TYPE_NAME AMOUNT_TYPE_NAME, AMOUNT_SUBTYPE_NAME AMOUNT_SUBTYPE_NAME, TXN_CURRENCY_CODE TXN_CURRENCY_CODE, SUCCEEDING_PERIOD_AMOUNT SUCCEEDING_PERIOD_AMOUNT, PRECEDING_PERIOD_AMOUNT PRECEDING_PERIOD_AMOUNT, DELETE_FLAG DELETE_FLAG, PARENT_PERIODS PARENT_PERIODS, START_DATE START_DATE, END_DATE END_DATE, UNIT_OF_MEASURE UNIT_OF_MEASURE, DESCRIPTION DESCRIPTION, CHANGE_REASON CHANGE_REASON, QUANTITY QUANTITY, RAW_COST RAW_COST, BURDENED_COST BURDENED_COST, REVENUE REVENUE, PROJFUNC_COST_RATE_TYPE PROJFUNC_COST_RATE_TYPE, PROJFUNC_COST_RATE_DATE_TYPE PROJFUNC_COST_RATE_DATE_TYPE, PROJFUNC_COST_EXCHANGE_RATE PROJFUNC_COST_EXCHANGE_RATE, PROJFUNC_COST_RATE_DATE PROJFUNC_COST_RATE_DATE, PROJECT_COST_RATE_TYPE PROJECT_COST_RATE_TYPE, PROJECT_COST_RATE_DATE_TYPE PROJECT_COST_RATE_DATE_TYPE, PROJECT_COST_EXCHANGE_RATE PROJECT_COST_EXCHANGE_RATE, PROJECT_COST_RATE_DATE PROJECT_COST_RATE_DATE, PROJFUNC_REV_RATE_TYPE PROJFUNC_REV_RATE_TYPE, PROJFUNC_REV_RATE_DATE_TYPE PROJFUNC_REV_RATE_DATE_TYPE, PROJFUNC_REV_EXCHANGE_RATE PROJFUNC_REV_EXCHANGE_RATE, PROJFUNC_REV_RATE_DATE PROJFUNC_REV_RATE_DATE, PROJECT_REV_RATE_TYPE PROJECT_REV_RATE_TYPE, PROJECT_REV_RATE_DATE_TYPE PROJECT_REV_RATE_DATE_TYPE, PROJECT_REV_EXCHANGE_RATE PROJECT_REV_EXCHANGE_RATE, PROJECT_REV_RATE_DATE PROJECT_REV_RATE_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, VAL_ERROR_FLAG VAL_ERROR_FLAG, VAL_ERROR_CODE VAL_ERROR_CODE, PRD1 PRD1, PRD2 PRD2, PRD3 PRD3, PRD4 PRD4, PRD5 PRD5, PRD6 PRD6, PRD7 PRD7, PRD8 PRD8, PRD9 PRD9, PRD10 PRD10, PRD11 PRD11, PRD12 PRD12, PRD13 PRD13, PRD14 PRD14, PRD15 PRD15, PRD16 PRD16, PRD17 PRD17, PRD18 PRD18, PRD19 PRD19, PRD20 PRD20, PRD21 PRD21, PRD22 PRD22, PRD23 PRD23, PRD24 PRD24, PRD25 PRD25, PRD26 PRD26, PRD27 PRD27, PRD28 PRD28, PRD29 PRD29, PRD30 PRD30, PRD31 PRD31, PRD32 PRD32, PRD33 PRD33, PRD34 PRD34, PRD35 PRD35, PRD36 PRD36, PRD37 PRD37, PRD38 PRD38, PRD39 PRD39, PRD40 PRD40, PRD41 PRD41, PRD42 PRD42, PRD43 PRD43, PRD44 PRD44, PRD45 PRD45, PRD46 PRD46, PRD47 PRD47, PRD48 PRD48, PRD49 PRD49, PRD50 PRD50, PRD51 PRD51, PRD52 PRD52, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER, PROJFUNC_RATE_TYPE PROJFUNC_RATE_TYPE, PROJFUNC_RATE_DATE_TYPE PROJFUNC_RATE_DATE_TYPE, PROJFUNC_EXCHANGE_RATE PROJFUNC_EXCHANGE_RATE, PROJFUNC_RATE_DATE PROJFUNC_RATE_DATE, PROJECT_RATE_TYPE PROJECT_RATE_TYPE, PROJECT_RATE_DATE_TYPE PROJECT_RATE_DATE_TYPE, PROJECT_EXCHANGE_RATE PROJECT_EXCHANGE_RATE, PROJECT_RATE_DATE PROJECT_RATE_DATE, FIN_PLAN_PREFERENCE_CODE FIN_PLAN_PREFERENCE_CODE, PLAN_CLASS_CODE PLAN_CLASS_CODE, PROJECT_NUMBER PROJECT_NUMBER, TASK_DISPLAY_SEQUENCE TASK_DISPLAY_SEQUENCE, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID, AMOUNT_TYPE_CODE AMOUNT_TYPE_CODE, SPREAD_CURVE_ID SPREAD_CURVE_ID, SPREAD_CURVE SPREAD_CURVE, MFC_COST_TYPE_ID MFC_COST_TYPE_ID, MFC_COST_TYPE MFC_COST_TYPE, ETC_METHOD_CODE ETC_METHOD_CODE, ETC_METHOD ETC_METHOD, ETC_SOURCE ETC_SOURCE, PHYSICAL_PERCENT_COMPLETE PHYSICAL_PERCENT_COMPLETE, COST_CODE COST_CODE, COST_CODE_NAME COST_CODE_NAME from "PA"."PA_FP_WEBADI_XFACE_TMP1"

View Text - HTML Formatted

SELECT BUDGET_VERSION_ID BUDGET_VERSION_ID
, PROJECT_ID PROJECT_ID
, RESOURCE_ASSIGNMENT_ID RESOURCE_ASSIGNMENT_ID
, RESOURCE_GROUP_NAME RESOURCE_GROUP_NAME
, RESOURCE_ALIAS RESOURCE_ALIAS
, PROJECT_NAME PROJECT_NAME
, TASK_NAME TASK_NAME
, TASK_NUMBER TASK_NUMBER
, AMOUNT_TYPE_NAME AMOUNT_TYPE_NAME
, AMOUNT_SUBTYPE_NAME AMOUNT_SUBTYPE_NAME
, TXN_CURRENCY_CODE TXN_CURRENCY_CODE
, SUCCEEDING_PERIOD_AMOUNT SUCCEEDING_PERIOD_AMOUNT
, PRECEDING_PERIOD_AMOUNT PRECEDING_PERIOD_AMOUNT
, DELETE_FLAG DELETE_FLAG
, PARENT_PERIODS PARENT_PERIODS
, START_DATE START_DATE
, END_DATE END_DATE
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, DESCRIPTION DESCRIPTION
, CHANGE_REASON CHANGE_REASON
, QUANTITY QUANTITY
, RAW_COST RAW_COST
, BURDENED_COST BURDENED_COST
, REVENUE REVENUE
, PROJFUNC_COST_RATE_TYPE PROJFUNC_COST_RATE_TYPE
, PROJFUNC_COST_RATE_DATE_TYPE PROJFUNC_COST_RATE_DATE_TYPE
, PROJFUNC_COST_EXCHANGE_RATE PROJFUNC_COST_EXCHANGE_RATE
, PROJFUNC_COST_RATE_DATE PROJFUNC_COST_RATE_DATE
, PROJECT_COST_RATE_TYPE PROJECT_COST_RATE_TYPE
, PROJECT_COST_RATE_DATE_TYPE PROJECT_COST_RATE_DATE_TYPE
, PROJECT_COST_EXCHANGE_RATE PROJECT_COST_EXCHANGE_RATE
, PROJECT_COST_RATE_DATE PROJECT_COST_RATE_DATE
, PROJFUNC_REV_RATE_TYPE PROJFUNC_REV_RATE_TYPE
, PROJFUNC_REV_RATE_DATE_TYPE PROJFUNC_REV_RATE_DATE_TYPE
, PROJFUNC_REV_EXCHANGE_RATE PROJFUNC_REV_EXCHANGE_RATE
, PROJFUNC_REV_RATE_DATE PROJFUNC_REV_RATE_DATE
, PROJECT_REV_RATE_TYPE PROJECT_REV_RATE_TYPE
, PROJECT_REV_RATE_DATE_TYPE PROJECT_REV_RATE_DATE_TYPE
, PROJECT_REV_EXCHANGE_RATE PROJECT_REV_EXCHANGE_RATE
, PROJECT_REV_RATE_DATE PROJECT_REV_RATE_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, VAL_ERROR_FLAG VAL_ERROR_FLAG
, VAL_ERROR_CODE VAL_ERROR_CODE
, PRD1 PRD1
, PRD2 PRD2
, PRD3 PRD3
, PRD4 PRD4
, PRD5 PRD5
, PRD6 PRD6
, PRD7 PRD7
, PRD8 PRD8
, PRD9 PRD9
, PRD10 PRD10
, PRD11 PRD11
, PRD12 PRD12
, PRD13 PRD13
, PRD14 PRD14
, PRD15 PRD15
, PRD16 PRD16
, PRD17 PRD17
, PRD18 PRD18
, PRD19 PRD19
, PRD20 PRD20
, PRD21 PRD21
, PRD22 PRD22
, PRD23 PRD23
, PRD24 PRD24
, PRD25 PRD25
, PRD26 PRD26
, PRD27 PRD27
, PRD28 PRD28
, PRD29 PRD29
, PRD30 PRD30
, PRD31 PRD31
, PRD32 PRD32
, PRD33 PRD33
, PRD34 PRD34
, PRD35 PRD35
, PRD36 PRD36
, PRD37 PRD37
, PRD38 PRD38
, PRD39 PRD39
, PRD40 PRD40
, PRD41 PRD41
, PRD42 PRD42
, PRD43 PRD43
, PRD44 PRD44
, PRD45 PRD45
, PRD46 PRD46
, PRD47 PRD47
, PRD48 PRD48
, PRD49 PRD49
, PRD50 PRD50
, PRD51 PRD51
, PRD52 PRD52
, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER
, PROJFUNC_RATE_TYPE PROJFUNC_RATE_TYPE
, PROJFUNC_RATE_DATE_TYPE PROJFUNC_RATE_DATE_TYPE
, PROJFUNC_EXCHANGE_RATE PROJFUNC_EXCHANGE_RATE
, PROJFUNC_RATE_DATE PROJFUNC_RATE_DATE
, PROJECT_RATE_TYPE PROJECT_RATE_TYPE
, PROJECT_RATE_DATE_TYPE PROJECT_RATE_DATE_TYPE
, PROJECT_EXCHANGE_RATE PROJECT_EXCHANGE_RATE
, PROJECT_RATE_DATE PROJECT_RATE_DATE
, FIN_PLAN_PREFERENCE_CODE FIN_PLAN_PREFERENCE_CODE
, PLAN_CLASS_CODE PLAN_CLASS_CODE
, PROJECT_NUMBER PROJECT_NUMBER
, TASK_DISPLAY_SEQUENCE TASK_DISPLAY_SEQUENCE
, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID
, AMOUNT_TYPE_CODE AMOUNT_TYPE_CODE
, SPREAD_CURVE_ID SPREAD_CURVE_ID
, SPREAD_CURVE SPREAD_CURVE
, MFC_COST_TYPE_ID MFC_COST_TYPE_ID
, MFC_COST_TYPE MFC_COST_TYPE
, ETC_METHOD_CODE ETC_METHOD_CODE
, ETC_METHOD ETC_METHOD
, ETC_SOURCE ETC_SOURCE
, PHYSICAL_PERCENT_COMPLETE PHYSICAL_PERCENT_COMPLETE
, COST_CODE COST_CODE
, COST_CODE_NAME COST_CODE_NAME
FROM "PA"."PA_FP_WEBADI_XFACE_TMP1"