VIEW: PA.PA_FP_WEBADI_UPLOAD_INF#

Source

View Text - Preformatted

select RUN_ID RUN_ID, BUDGET_VERSION_ID BUDGET_VERSION_ID, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER, PRD_MASK_REC_VER_NUMBER PRD_MASK_REC_VER_NUMBER, TASK_NAME TASK_NAME, TASK_NUMBER TASK_NUMBER, TASK_ID TASK_ID, RESOURCE_ALIAS RESOURCE_ALIAS, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID, AMOUNT_TYPE_CODE AMOUNT_TYPE_CODE, AMOUNT_TYPE_NAME AMOUNT_TYPE_NAME, TXN_CURRENCY_CODE TXN_CURRENCY_CODE, DELETE_FLAG DELETE_FLAG, PLANNING_START_DATE PLANNING_START_DATE, PLANNING_END_DATE PLANNING_END_DATE, DESCRIPTION DESCRIPTION, CHANGE_REASON_CODE CHANGE_REASON_CODE, QUANTITY QUANTITY, ACTUAL_QUANTITY ACTUAL_QUANTITY, ETC_QUANTITY ETC_QUANTITY, RAW_COST RAW_COST, ACTUAL_RAW_COST ACTUAL_RAW_COST, ETC_RAW_COST ETC_RAW_COST, RAW_COST_RATE RAW_COST_RATE, BURDENED_COST BURDENED_COST, ACTUAL_BURDENED_COST ACTUAL_BURDENED_COST, ETC_BURDENED_COST ETC_BURDENED_COST, BURDENED_COST_RATE BURDENED_COST_RATE, REVENUE REVENUE, ACTUAL_REVENUE ACTUAL_REVENUE, ETC_REVENUE ETC_REVENUE, BILL_RATE BILL_RATE, 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, 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, VAL_ERROR_FLAG VAL_ERROR_FLAG, VAL_ERROR_CODE VAL_ERROR_CODE, ERR_TASK_NAME ERR_TASK_NAME, ERR_TASK_NUMBER ERR_TASK_NUMBER, ERR_ALIAS ERR_ALIAS, ERR_AMOUNT_TYPE_CODE ERR_AMOUNT_TYPE_CODE, REQUEST_ID REQUEST_ID, PD_PRD PD_PRD, 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, SD_PRD SD_PRD, ETC_RAW_COST_RATE ETC_RAW_COST_RATE, ETC_BURDEN_COST_RATE ETC_BURDEN_COST_RATE, ETC_BILL_RATE ETC_BILL_RATE, RAW_COST_OVER_RATE RAW_COST_OVER_RATE, BURDENED_COST_OVER_RATE BURDENED_COST_OVER_RATE, BILL_OVER_RATE BILL_OVER_RATE, COST_CODE COST_CODE, COST_CODE_NAME COST_CODE_NAME, CBS_ELEMENT_ID CBS_ELEMENT_ID from "PA"."PA_FP_WEBADI_UPLOAD_INF"

View Text - HTML Formatted

SELECT RUN_ID RUN_ID
, BUDGET_VERSION_ID BUDGET_VERSION_ID
, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER
, PRD_MASK_REC_VER_NUMBER PRD_MASK_REC_VER_NUMBER
, TASK_NAME TASK_NAME
, TASK_NUMBER TASK_NUMBER
, TASK_ID TASK_ID
, RESOURCE_ALIAS RESOURCE_ALIAS
, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID
, AMOUNT_TYPE_CODE AMOUNT_TYPE_CODE
, AMOUNT_TYPE_NAME AMOUNT_TYPE_NAME
, TXN_CURRENCY_CODE TXN_CURRENCY_CODE
, DELETE_FLAG DELETE_FLAG
, PLANNING_START_DATE PLANNING_START_DATE
, PLANNING_END_DATE PLANNING_END_DATE
, DESCRIPTION DESCRIPTION
, CHANGE_REASON_CODE CHANGE_REASON_CODE
, QUANTITY QUANTITY
, ACTUAL_QUANTITY ACTUAL_QUANTITY
, ETC_QUANTITY ETC_QUANTITY
, RAW_COST RAW_COST
, ACTUAL_RAW_COST ACTUAL_RAW_COST
, ETC_RAW_COST ETC_RAW_COST
, RAW_COST_RATE RAW_COST_RATE
, BURDENED_COST BURDENED_COST
, ACTUAL_BURDENED_COST ACTUAL_BURDENED_COST
, ETC_BURDENED_COST ETC_BURDENED_COST
, BURDENED_COST_RATE BURDENED_COST_RATE
, REVENUE REVENUE
, ACTUAL_REVENUE ACTUAL_REVENUE
, ETC_REVENUE ETC_REVENUE
, BILL_RATE BILL_RATE
, 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
, 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
, VAL_ERROR_FLAG VAL_ERROR_FLAG
, VAL_ERROR_CODE VAL_ERROR_CODE
, ERR_TASK_NAME ERR_TASK_NAME
, ERR_TASK_NUMBER ERR_TASK_NUMBER
, ERR_ALIAS ERR_ALIAS
, ERR_AMOUNT_TYPE_CODE ERR_AMOUNT_TYPE_CODE
, REQUEST_ID REQUEST_ID
, PD_PRD PD_PRD
, 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
, SD_PRD SD_PRD
, ETC_RAW_COST_RATE ETC_RAW_COST_RATE
, ETC_BURDEN_COST_RATE ETC_BURDEN_COST_RATE
, ETC_BILL_RATE ETC_BILL_RATE
, RAW_COST_OVER_RATE RAW_COST_OVER_RATE
, BURDENED_COST_OVER_RATE BURDENED_COST_OVER_RATE
, BILL_OVER_RATE BILL_OVER_RATE
, COST_CODE COST_CODE
, COST_CODE_NAME COST_CODE_NAME
, CBS_ELEMENT_ID CBS_ELEMENT_ID
FROM "PA"."PA_FP_WEBADI_UPLOAD_INF"