VIEW: PA.PA_RESOURCE_ASGN_CURR#

Source

View Text - Preformatted

select RA_TXN_ID RA_TXN_ID, BUDGET_VERSION_ID BUDGET_VERSION_ID, RESOURCE_ASSIGNMENT_ID RESOURCE_ASSIGNMENT_ID, TXN_CURRENCY_CODE TXN_CURRENCY_CODE, TOTAL_QUANTITY TOTAL_QUANTITY, TOTAL_INIT_QUANTITY TOTAL_INIT_QUANTITY, TXN_RAW_COST_RATE_OVERRIDE TXN_RAW_COST_RATE_OVERRIDE, TXN_BURDEN_COST_RATE_OVERRIDE TXN_BURDEN_COST_RATE_OVERRIDE, TXN_BILL_RATE_OVERRIDE TXN_BILL_RATE_OVERRIDE, TXN_AVERAGE_RAW_COST_RATE TXN_AVERAGE_RAW_COST_RATE, TXN_AVERAGE_BURDEN_COST_RATE TXN_AVERAGE_BURDEN_COST_RATE, TXN_AVERAGE_BILL_RATE TXN_AVERAGE_BILL_RATE, TXN_ETC_RAW_COST_RATE TXN_ETC_RAW_COST_RATE, TXN_ETC_BURDEN_COST_RATE TXN_ETC_BURDEN_COST_RATE, TXN_ETC_BILL_RATE TXN_ETC_BILL_RATE, TOTAL_TXN_RAW_COST TOTAL_TXN_RAW_COST, TOTAL_TXN_BURDENED_COST TOTAL_TXN_BURDENED_COST, TOTAL_TXN_REVENUE TOTAL_TXN_REVENUE, TOTAL_TXN_INIT_RAW_COST TOTAL_TXN_INIT_RAW_COST, TOTAL_TXN_INIT_BURDENED_COST TOTAL_TXN_INIT_BURDENED_COST, TOTAL_TXN_INIT_REVENUE TOTAL_TXN_INIT_REVENUE, TOTAL_PROJECT_RAW_COST TOTAL_PROJECT_RAW_COST, TOTAL_PROJECT_BURDENED_COST TOTAL_PROJECT_BURDENED_COST, TOTAL_PROJECT_REVENUE TOTAL_PROJECT_REVENUE, TOTAL_PROJECT_INIT_RAW_COST TOTAL_PROJECT_INIT_RAW_COST, TOTAL_PROJECT_INIT_BD_COST TOTAL_PROJECT_INIT_BD_COST, TOTAL_PROJECT_INIT_REVENUE TOTAL_PROJECT_INIT_REVENUE, TOTAL_PROJFUNC_RAW_COST TOTAL_PROJFUNC_RAW_COST, TOTAL_PROJFUNC_BURDENED_COST TOTAL_PROJFUNC_BURDENED_COST, TOTAL_PROJFUNC_REVENUE TOTAL_PROJFUNC_REVENUE, TOTAL_PROJFUNC_INIT_RAW_COST TOTAL_PROJFUNC_INIT_RAW_COST, TOTAL_PROJFUNC_INIT_BD_COST TOTAL_PROJFUNC_INIT_BD_COST, TOTAL_PROJFUNC_INIT_REVENUE TOTAL_PROJFUNC_INIT_REVENUE, TOTAL_DISPLAY_QUANTITY TOTAL_DISPLAY_QUANTITY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER, EXPENDITURE_TYPE EXPENDITURE_TYPE from "PA"."PA_RESOURCE_ASGN_CURR"

View Text - HTML Formatted

SELECT RA_TXN_ID RA_TXN_ID
, BUDGET_VERSION_ID BUDGET_VERSION_ID
, RESOURCE_ASSIGNMENT_ID RESOURCE_ASSIGNMENT_ID
, TXN_CURRENCY_CODE TXN_CURRENCY_CODE
, TOTAL_QUANTITY TOTAL_QUANTITY
, TOTAL_INIT_QUANTITY TOTAL_INIT_QUANTITY
, TXN_RAW_COST_RATE_OVERRIDE TXN_RAW_COST_RATE_OVERRIDE
, TXN_BURDEN_COST_RATE_OVERRIDE TXN_BURDEN_COST_RATE_OVERRIDE
, TXN_BILL_RATE_OVERRIDE TXN_BILL_RATE_OVERRIDE
, TXN_AVERAGE_RAW_COST_RATE TXN_AVERAGE_RAW_COST_RATE
, TXN_AVERAGE_BURDEN_COST_RATE TXN_AVERAGE_BURDEN_COST_RATE
, TXN_AVERAGE_BILL_RATE TXN_AVERAGE_BILL_RATE
, TXN_ETC_RAW_COST_RATE TXN_ETC_RAW_COST_RATE
, TXN_ETC_BURDEN_COST_RATE TXN_ETC_BURDEN_COST_RATE
, TXN_ETC_BILL_RATE TXN_ETC_BILL_RATE
, TOTAL_TXN_RAW_COST TOTAL_TXN_RAW_COST
, TOTAL_TXN_BURDENED_COST TOTAL_TXN_BURDENED_COST
, TOTAL_TXN_REVENUE TOTAL_TXN_REVENUE
, TOTAL_TXN_INIT_RAW_COST TOTAL_TXN_INIT_RAW_COST
, TOTAL_TXN_INIT_BURDENED_COST TOTAL_TXN_INIT_BURDENED_COST
, TOTAL_TXN_INIT_REVENUE TOTAL_TXN_INIT_REVENUE
, TOTAL_PROJECT_RAW_COST TOTAL_PROJECT_RAW_COST
, TOTAL_PROJECT_BURDENED_COST TOTAL_PROJECT_BURDENED_COST
, TOTAL_PROJECT_REVENUE TOTAL_PROJECT_REVENUE
, TOTAL_PROJECT_INIT_RAW_COST TOTAL_PROJECT_INIT_RAW_COST
, TOTAL_PROJECT_INIT_BD_COST TOTAL_PROJECT_INIT_BD_COST
, TOTAL_PROJECT_INIT_REVENUE TOTAL_PROJECT_INIT_REVENUE
, TOTAL_PROJFUNC_RAW_COST TOTAL_PROJFUNC_RAW_COST
, TOTAL_PROJFUNC_BURDENED_COST TOTAL_PROJFUNC_BURDENED_COST
, TOTAL_PROJFUNC_REVENUE TOTAL_PROJFUNC_REVENUE
, TOTAL_PROJFUNC_INIT_RAW_COST TOTAL_PROJFUNC_INIT_RAW_COST
, TOTAL_PROJFUNC_INIT_BD_COST TOTAL_PROJFUNC_INIT_BD_COST
, TOTAL_PROJFUNC_INIT_REVENUE TOTAL_PROJFUNC_INIT_REVENUE
, TOTAL_DISPLAY_QUANTITY TOTAL_DISPLAY_QUANTITY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER
, EXPENDITURE_TYPE EXPENDITURE_TYPE
FROM "PA"."PA_RESOURCE_ASGN_CURR"