VIEW: PA.PA_FIN_PLAN_AMOUNT_SETS#

Source

View Text - Preformatted

select FIN_PLAN_AMOUNT_SET_ID FIN_PLAN_AMOUNT_SET_ID, AMOUNT_SET_TYPE_CODE AMOUNT_SET_TYPE_CODE, RAW_COST_FLAG RAW_COST_FLAG, BURDENED_COST_FLAG BURDENED_COST_FLAG, COST_QTY_FLAG COST_QTY_FLAG, REVENUE_FLAG REVENUE_FLAG, REVENUE_QTY_FLAG REVENUE_QTY_FLAG, TP_COST_FLAG TP_COST_FLAG, TP_REVENUE_FLAG TP_REVENUE_FLAG, UTIL_PERCENT_FLAG UTIL_PERCENT_FLAG, UTIL_HOURS_FLAG UTIL_HOURS_FLAG, CAPACITY_FLAG CAPACITY_FLAG, PRE_DEFINED_FLAG PRE_DEFINED_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ALL_QTY_FLAG ALL_QTY_FLAG, BILL_RATE_FLAG BILL_RATE_FLAG, COST_RATE_FLAG COST_RATE_FLAG, BURDEN_RATE_FLAG BURDEN_RATE_FLAG, ZD_EDITION_NAME ZD_EDITION_NAME from "PA"."PA_FIN_PLAN_AMOUNT_SETS"

View Text - HTML Formatted

SELECT FIN_PLAN_AMOUNT_SET_ID FIN_PLAN_AMOUNT_SET_ID
, AMOUNT_SET_TYPE_CODE AMOUNT_SET_TYPE_CODE
, RAW_COST_FLAG RAW_COST_FLAG
, BURDENED_COST_FLAG BURDENED_COST_FLAG
, COST_QTY_FLAG COST_QTY_FLAG
, REVENUE_FLAG REVENUE_FLAG
, REVENUE_QTY_FLAG REVENUE_QTY_FLAG
, TP_COST_FLAG TP_COST_FLAG
, TP_REVENUE_FLAG TP_REVENUE_FLAG
, UTIL_PERCENT_FLAG UTIL_PERCENT_FLAG
, UTIL_HOURS_FLAG UTIL_HOURS_FLAG
, CAPACITY_FLAG CAPACITY_FLAG
, PRE_DEFINED_FLAG PRE_DEFINED_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ALL_QTY_FLAG ALL_QTY_FLAG
, BILL_RATE_FLAG BILL_RATE_FLAG
, COST_RATE_FLAG COST_RATE_FLAG
, BURDEN_RATE_FLAG BURDEN_RATE_FLAG
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "PA"."PA_FIN_PLAN_AMOUNT_SETS"