VIEW: PA.PA_PROJ_FP_OPTIONS#

Source

View Text - Preformatted

select PROJ_FP_OPTIONS_ID PROJ_FP_OPTIONS_ID, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER, PROJECT_ID PROJECT_ID, FIN_PLAN_OPTION_LEVEL_CODE FIN_PLAN_OPTION_LEVEL_CODE, FIN_PLAN_TYPE_ID FIN_PLAN_TYPE_ID, FIN_PLAN_START_DATE FIN_PLAN_START_DATE, FIN_PLAN_END_DATE FIN_PLAN_END_DATE, FIN_PLAN_PREFERENCE_CODE FIN_PLAN_PREFERENCE_CODE, ALL_AMOUNT_SET_ID ALL_AMOUNT_SET_ID, COST_AMOUNT_SET_ID COST_AMOUNT_SET_ID, REVENUE_AMOUNT_SET_ID REVENUE_AMOUNT_SET_ID, ALL_FIN_PLAN_LEVEL_CODE ALL_FIN_PLAN_LEVEL_CODE, ALL_TIME_PHASED_CODE ALL_TIME_PHASED_CODE, ALL_RESOURCE_LIST_ID ALL_RESOURCE_LIST_ID, COST_FIN_PLAN_LEVEL_CODE COST_FIN_PLAN_LEVEL_CODE, COST_TIME_PHASED_CODE COST_TIME_PHASED_CODE, COST_RESOURCE_LIST_ID COST_RESOURCE_LIST_ID, REVENUE_FIN_PLAN_LEVEL_CODE REVENUE_FIN_PLAN_LEVEL_CODE, REVENUE_RESOURCE_LIST_ID REVENUE_RESOURCE_LIST_ID, REVENUE_TIME_PHASED_CODE REVENUE_TIME_PHASED_CODE, REPORT_LABOR_HRS_FROM_CODE REPORT_LABOR_HRS_FROM_CODE, FIN_PLAN_VERSION_ID FIN_PLAN_VERSION_ID, 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, DEFAULT_AMOUNT_TYPE_CODE DEFAULT_AMOUNT_TYPE_CODE, DEFAULT_AMOUNT_SUBTYPE_CODE DEFAULT_AMOUNT_SUBTYPE_CODE, PLAN_IN_MULTI_CURR_FLAG PLAN_IN_MULTI_CURR_FLAG, FACTOR_BY_CODE FACTOR_BY_CODE, APPROVED_COST_PLAN_TYPE_FLAG APPROVED_COST_PLAN_TYPE_FLAG, APPROVED_REV_PLAN_TYPE_FLAG APPROVED_REV_PLAN_TYPE_FLAG, PROJFUNC_COST_RATE_TYPE PROJFUNC_COST_RATE_TYPE, PROJFUNC_COST_RATE_DATE_TYPE PROJFUNC_COST_RATE_DATE_TYPE, PROJFUNC_COST_RATE_DATE PROJFUNC_COST_RATE_DATE, PROJFUNC_REV_RATE_TYPE PROJFUNC_REV_RATE_TYPE, PROJFUNC_REV_RATE_DATE_TYPE PROJFUNC_REV_RATE_DATE_TYPE, PROJFUNC_REV_RATE_DATE PROJFUNC_REV_RATE_DATE, PROJECT_COST_RATE_TYPE PROJECT_COST_RATE_TYPE, PROJECT_COST_RATE_DATE_TYPE PROJECT_COST_RATE_DATE_TYPE, PROJECT_COST_RATE_DATE PROJECT_COST_RATE_DATE, PROJECT_REV_RATE_TYPE PROJECT_REV_RATE_TYPE, PROJECT_REV_RATE_DATE_TYPE PROJECT_REV_RATE_DATE_TYPE, PROJECT_REV_RATE_DATE PROJECT_REV_RATE_DATE, MARGIN_DERIVED_FROM_CODE MARGIN_DERIVED_FROM_CODE, SELECT_COST_RES_AUTO_FLAG SELECT_COST_RES_AUTO_FLAG, COST_RES_PLANNING_LEVEL COST_RES_PLANNING_LEVEL, SELECT_REV_RES_AUTO_FLAG SELECT_REV_RES_AUTO_FLAG, REVENUE_RES_PLANNING_LEVEL REVENUE_RES_PLANNING_LEVEL, SELECT_ALL_RES_AUTO_FLAG SELECT_ALL_RES_AUTO_FLAG, ALL_RES_PLANNING_LEVEL ALL_RES_PLANNING_LEVEL, PROCESS_UPDATE_WBS_FLAG PROCESS_UPDATE_WBS_FLAG, REQUEST_ID REQUEST_ID, PLAN_PROCESSING_CODE PLAN_PROCESSING_CODE, PRIMARY_COST_FORECAST_FLAG PRIMARY_COST_FORECAST_FLAG, PRIMARY_REV_FORECAST_FLAG PRIMARY_REV_FORECAST_FLAG, USE_PLANNING_RATES_FLAG USE_PLANNING_RATES_FLAG, RES_CLASS_RAW_COST_SCH_ID RES_CLASS_RAW_COST_SCH_ID, RES_CLASS_BILL_RATE_SCH_ID RES_CLASS_BILL_RATE_SCH_ID, COST_EMP_RATE_SCH_ID COST_EMP_RATE_SCH_ID, COST_JOB_RATE_SCH_ID COST_JOB_RATE_SCH_ID, COST_NON_LABOR_RES_RATE_SCH_ID COST_NON_LABOR_RES_RATE_SCH_ID, COST_RES_CLASS_RATE_SCH_ID COST_RES_CLASS_RATE_SCH_ID, COST_BURDEN_RATE_SCH_ID COST_BURDEN_RATE_SCH_ID, COST_CURRENT_PLANNING_PERIOD COST_CURRENT_PLANNING_PERIOD, COST_PERIOD_MASK_ID COST_PERIOD_MASK_ID, REV_EMP_RATE_SCH_ID REV_EMP_RATE_SCH_ID, REV_JOB_RATE_SCH_ID REV_JOB_RATE_SCH_ID, REV_NON_LABOR_RES_RATE_SCH_ID REV_NON_LABOR_RES_RATE_SCH_ID, REV_RES_CLASS_RATE_SCH_ID REV_RES_CLASS_RATE_SCH_ID, REV_CURRENT_PLANNING_PERIOD REV_CURRENT_PLANNING_PERIOD, REV_PERIOD_MASK_ID REV_PERIOD_MASK_ID, ALL_CURRENT_PLANNING_PERIOD ALL_CURRENT_PLANNING_PERIOD, ALL_PERIOD_MASK_ID ALL_PERIOD_MASK_ID, GEN_COST_SRC_CODE GEN_COST_SRC_CODE, GEN_COST_ETC_SRC_CODE GEN_COST_ETC_SRC_CODE, GEN_COST_INCL_CHANGE_DOC_FLAG GEN_COST_INCL_CHANGE_DOC_FLAG, GEN_COST_INCL_OPEN_COMM_FLAG GEN_COST_INCL_OPEN_COMM_FLAG, GEN_COST_RET_MANUAL_LINE_FLAG GEN_COST_RET_MANUAL_LINE_FLAG, GEN_COST_ACTUAL_AMTS_THRU_CODE GEN_COST_ACTUAL_AMTS_THRU_CODE, GEN_COST_INCL_UNSPENT_AMT_FLAG GEN_COST_INCL_UNSPENT_AMT_FLAG, GEN_REV_SRC_CODE GEN_REV_SRC_CODE, GEN_REV_ETC_SRC_CODE GEN_REV_ETC_SRC_CODE, GEN_REV_INCL_CHANGE_DOC_FLAG GEN_REV_INCL_CHANGE_DOC_FLAG, GEN_REV_INCL_BILL_EVENT_FLAG GEN_REV_INCL_BILL_EVENT_FLAG, GEN_REV_RET_MANUAL_LINE_FLAG GEN_REV_RET_MANUAL_LINE_FLAG, GEN_REV_ACTUAL_AMTS_THRU_CODE GEN_REV_ACTUAL_AMTS_THRU_CODE, GEN_SRC_COST_PLAN_TYPE_ID GEN_SRC_COST_PLAN_TYPE_ID, GEN_SRC_COST_PLAN_VERSION_ID GEN_SRC_COST_PLAN_VERSION_ID, GEN_SRC_COST_PLAN_VER_CODE GEN_SRC_COST_PLAN_VER_CODE, GEN_SRC_REV_PLAN_TYPE_ID GEN_SRC_REV_PLAN_TYPE_ID, GEN_SRC_REV_PLAN_VERSION_ID GEN_SRC_REV_PLAN_VERSION_ID, GEN_SRC_REV_PLAN_VER_CODE GEN_SRC_REV_PLAN_VER_CODE, GEN_SRC_ALL_PLAN_TYPE_ID GEN_SRC_ALL_PLAN_TYPE_ID, GEN_SRC_ALL_PLAN_VERSION_ID GEN_SRC_ALL_PLAN_VERSION_ID, GEN_SRC_ALL_PLAN_VER_CODE GEN_SRC_ALL_PLAN_VER_CODE, GEN_ALL_SRC_CODE GEN_ALL_SRC_CODE, GEN_ALL_ETC_SRC_CODE GEN_ALL_ETC_SRC_CODE, GEN_ALL_INCL_CHANGE_DOC_FLAG GEN_ALL_INCL_CHANGE_DOC_FLAG, GEN_ALL_INCL_OPEN_COMM_FLAG GEN_ALL_INCL_OPEN_COMM_FLAG, GEN_ALL_RET_MANUAL_LINE_FLAG GEN_ALL_RET_MANUAL_LINE_FLAG, GEN_ALL_INCL_BILL_EVENT_FLAG GEN_ALL_INCL_BILL_EVENT_FLAG, GEN_ALL_ACTUAL_AMTS_THRU_CODE GEN_ALL_ACTUAL_AMTS_THRU_CODE, GEN_ALL_INCL_UNSPENT_AMT_FLAG GEN_ALL_INCL_UNSPENT_AMT_FLAG, TRACK_WORKPLAN_COSTS_FLAG TRACK_WORKPLAN_COSTS_FLAG, RBS_VERSION_ID RBS_VERSION_ID, GEN_SRC_COST_WP_VERSION_ID GEN_SRC_COST_WP_VERSION_ID, GEN_SRC_COST_WP_VER_CODE GEN_SRC_COST_WP_VER_CODE, GEN_SRC_REV_WP_VERSION_ID GEN_SRC_REV_WP_VERSION_ID, GEN_SRC_REV_WP_VER_CODE GEN_SRC_REV_WP_VER_CODE, GEN_SRC_ALL_WP_VERSION_ID GEN_SRC_ALL_WP_VERSION_ID, GEN_SRC_ALL_WP_VER_CODE GEN_SRC_ALL_WP_VER_CODE, COST_LAYOUT_CODE COST_LAYOUT_CODE, REVENUE_LAYOUT_CODE REVENUE_LAYOUT_CODE, ALL_LAYOUT_CODE ALL_LAYOUT_CODE, REVENUE_DERIVATION_METHOD REVENUE_DERIVATION_METHOD, COPY_ETC_FROM_PLAN_FLAG COPY_ETC_FROM_PLAN_FLAG, DEFAULT_RAW_COST DEFAULT_RAW_COST, DEFAULT_BILL_RATE DEFAULT_BILL_RATE, DEF_MARKUP_PERCENTAGE DEF_MARKUP_PERCENTAGE, DEF_RAW_COST_CURRENCY_CODE DEF_RAW_COST_CURRENCY_CODE, DEF_BILL_RATE_CURRENCY_CODE DEF_BILL_RATE_CURRENCY_CODE from "PA"."PA_PROJ_FP_OPTIONS"

View Text - HTML Formatted

SELECT PROJ_FP_OPTIONS_ID PROJ_FP_OPTIONS_ID
, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER
, PROJECT_ID PROJECT_ID
, FIN_PLAN_OPTION_LEVEL_CODE FIN_PLAN_OPTION_LEVEL_CODE
, FIN_PLAN_TYPE_ID FIN_PLAN_TYPE_ID
, FIN_PLAN_START_DATE FIN_PLAN_START_DATE
, FIN_PLAN_END_DATE FIN_PLAN_END_DATE
, FIN_PLAN_PREFERENCE_CODE FIN_PLAN_PREFERENCE_CODE
, ALL_AMOUNT_SET_ID ALL_AMOUNT_SET_ID
, COST_AMOUNT_SET_ID COST_AMOUNT_SET_ID
, REVENUE_AMOUNT_SET_ID REVENUE_AMOUNT_SET_ID
, ALL_FIN_PLAN_LEVEL_CODE ALL_FIN_PLAN_LEVEL_CODE
, ALL_TIME_PHASED_CODE ALL_TIME_PHASED_CODE
, ALL_RESOURCE_LIST_ID ALL_RESOURCE_LIST_ID
, COST_FIN_PLAN_LEVEL_CODE COST_FIN_PLAN_LEVEL_CODE
, COST_TIME_PHASED_CODE COST_TIME_PHASED_CODE
, COST_RESOURCE_LIST_ID COST_RESOURCE_LIST_ID
, REVENUE_FIN_PLAN_LEVEL_CODE REVENUE_FIN_PLAN_LEVEL_CODE
, REVENUE_RESOURCE_LIST_ID REVENUE_RESOURCE_LIST_ID
, REVENUE_TIME_PHASED_CODE REVENUE_TIME_PHASED_CODE
, REPORT_LABOR_HRS_FROM_CODE REPORT_LABOR_HRS_FROM_CODE
, FIN_PLAN_VERSION_ID FIN_PLAN_VERSION_ID
, 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
, DEFAULT_AMOUNT_TYPE_CODE DEFAULT_AMOUNT_TYPE_CODE
, DEFAULT_AMOUNT_SUBTYPE_CODE DEFAULT_AMOUNT_SUBTYPE_CODE
, PLAN_IN_MULTI_CURR_FLAG PLAN_IN_MULTI_CURR_FLAG
, FACTOR_BY_CODE FACTOR_BY_CODE
, APPROVED_COST_PLAN_TYPE_FLAG APPROVED_COST_PLAN_TYPE_FLAG
, APPROVED_REV_PLAN_TYPE_FLAG APPROVED_REV_PLAN_TYPE_FLAG
, PROJFUNC_COST_RATE_TYPE PROJFUNC_COST_RATE_TYPE
, PROJFUNC_COST_RATE_DATE_TYPE PROJFUNC_COST_RATE_DATE_TYPE
, PROJFUNC_COST_RATE_DATE PROJFUNC_COST_RATE_DATE
, PROJFUNC_REV_RATE_TYPE PROJFUNC_REV_RATE_TYPE
, PROJFUNC_REV_RATE_DATE_TYPE PROJFUNC_REV_RATE_DATE_TYPE
, PROJFUNC_REV_RATE_DATE PROJFUNC_REV_RATE_DATE
, PROJECT_COST_RATE_TYPE PROJECT_COST_RATE_TYPE
, PROJECT_COST_RATE_DATE_TYPE PROJECT_COST_RATE_DATE_TYPE
, PROJECT_COST_RATE_DATE PROJECT_COST_RATE_DATE
, PROJECT_REV_RATE_TYPE PROJECT_REV_RATE_TYPE
, PROJECT_REV_RATE_DATE_TYPE PROJECT_REV_RATE_DATE_TYPE
, PROJECT_REV_RATE_DATE PROJECT_REV_RATE_DATE
, MARGIN_DERIVED_FROM_CODE MARGIN_DERIVED_FROM_CODE
, SELECT_COST_RES_AUTO_FLAG SELECT_COST_RES_AUTO_FLAG
, COST_RES_PLANNING_LEVEL COST_RES_PLANNING_LEVEL
, SELECT_REV_RES_AUTO_FLAG SELECT_REV_RES_AUTO_FLAG
, REVENUE_RES_PLANNING_LEVEL REVENUE_RES_PLANNING_LEVEL
, SELECT_ALL_RES_AUTO_FLAG SELECT_ALL_RES_AUTO_FLAG
, ALL_RES_PLANNING_LEVEL ALL_RES_PLANNING_LEVEL
, PROCESS_UPDATE_WBS_FLAG PROCESS_UPDATE_WBS_FLAG
, REQUEST_ID REQUEST_ID
, PLAN_PROCESSING_CODE PLAN_PROCESSING_CODE
, PRIMARY_COST_FORECAST_FLAG PRIMARY_COST_FORECAST_FLAG
, PRIMARY_REV_FORECAST_FLAG PRIMARY_REV_FORECAST_FLAG
, USE_PLANNING_RATES_FLAG USE_PLANNING_RATES_FLAG
, RES_CLASS_RAW_COST_SCH_ID RES_CLASS_RAW_COST_SCH_ID
, RES_CLASS_BILL_RATE_SCH_ID RES_CLASS_BILL_RATE_SCH_ID
, COST_EMP_RATE_SCH_ID COST_EMP_RATE_SCH_ID
, COST_JOB_RATE_SCH_ID COST_JOB_RATE_SCH_ID
, COST_NON_LABOR_RES_RATE_SCH_ID COST_NON_LABOR_RES_RATE_SCH_ID
, COST_RES_CLASS_RATE_SCH_ID COST_RES_CLASS_RATE_SCH_ID
, COST_BURDEN_RATE_SCH_ID COST_BURDEN_RATE_SCH_ID
, COST_CURRENT_PLANNING_PERIOD COST_CURRENT_PLANNING_PERIOD
, COST_PERIOD_MASK_ID COST_PERIOD_MASK_ID
, REV_EMP_RATE_SCH_ID REV_EMP_RATE_SCH_ID
, REV_JOB_RATE_SCH_ID REV_JOB_RATE_SCH_ID
, REV_NON_LABOR_RES_RATE_SCH_ID REV_NON_LABOR_RES_RATE_SCH_ID
, REV_RES_CLASS_RATE_SCH_ID REV_RES_CLASS_RATE_SCH_ID
, REV_CURRENT_PLANNING_PERIOD REV_CURRENT_PLANNING_PERIOD
, REV_PERIOD_MASK_ID REV_PERIOD_MASK_ID
, ALL_CURRENT_PLANNING_PERIOD ALL_CURRENT_PLANNING_PERIOD
, ALL_PERIOD_MASK_ID ALL_PERIOD_MASK_ID
, GEN_COST_SRC_CODE GEN_COST_SRC_CODE
, GEN_COST_ETC_SRC_CODE GEN_COST_ETC_SRC_CODE
, GEN_COST_INCL_CHANGE_DOC_FLAG GEN_COST_INCL_CHANGE_DOC_FLAG
, GEN_COST_INCL_OPEN_COMM_FLAG GEN_COST_INCL_OPEN_COMM_FLAG
, GEN_COST_RET_MANUAL_LINE_FLAG GEN_COST_RET_MANUAL_LINE_FLAG
, GEN_COST_ACTUAL_AMTS_THRU_CODE GEN_COST_ACTUAL_AMTS_THRU_CODE
, GEN_COST_INCL_UNSPENT_AMT_FLAG GEN_COST_INCL_UNSPENT_AMT_FLAG
, GEN_REV_SRC_CODE GEN_REV_SRC_CODE
, GEN_REV_ETC_SRC_CODE GEN_REV_ETC_SRC_CODE
, GEN_REV_INCL_CHANGE_DOC_FLAG GEN_REV_INCL_CHANGE_DOC_FLAG
, GEN_REV_INCL_BILL_EVENT_FLAG GEN_REV_INCL_BILL_EVENT_FLAG
, GEN_REV_RET_MANUAL_LINE_FLAG GEN_REV_RET_MANUAL_LINE_FLAG
, GEN_REV_ACTUAL_AMTS_THRU_CODE GEN_REV_ACTUAL_AMTS_THRU_CODE
, GEN_SRC_COST_PLAN_TYPE_ID GEN_SRC_COST_PLAN_TYPE_ID
, GEN_SRC_COST_PLAN_VERSION_ID GEN_SRC_COST_PLAN_VERSION_ID
, GEN_SRC_COST_PLAN_VER_CODE GEN_SRC_COST_PLAN_VER_CODE
, GEN_SRC_REV_PLAN_TYPE_ID GEN_SRC_REV_PLAN_TYPE_ID
, GEN_SRC_REV_PLAN_VERSION_ID GEN_SRC_REV_PLAN_VERSION_ID
, GEN_SRC_REV_PLAN_VER_CODE GEN_SRC_REV_PLAN_VER_CODE
, GEN_SRC_ALL_PLAN_TYPE_ID GEN_SRC_ALL_PLAN_TYPE_ID
, GEN_SRC_ALL_PLAN_VERSION_ID GEN_SRC_ALL_PLAN_VERSION_ID
, GEN_SRC_ALL_PLAN_VER_CODE GEN_SRC_ALL_PLAN_VER_CODE
, GEN_ALL_SRC_CODE GEN_ALL_SRC_CODE
, GEN_ALL_ETC_SRC_CODE GEN_ALL_ETC_SRC_CODE
, GEN_ALL_INCL_CHANGE_DOC_FLAG GEN_ALL_INCL_CHANGE_DOC_FLAG
, GEN_ALL_INCL_OPEN_COMM_FLAG GEN_ALL_INCL_OPEN_COMM_FLAG
, GEN_ALL_RET_MANUAL_LINE_FLAG GEN_ALL_RET_MANUAL_LINE_FLAG
, GEN_ALL_INCL_BILL_EVENT_FLAG GEN_ALL_INCL_BILL_EVENT_FLAG
, GEN_ALL_ACTUAL_AMTS_THRU_CODE GEN_ALL_ACTUAL_AMTS_THRU_CODE
, GEN_ALL_INCL_UNSPENT_AMT_FLAG GEN_ALL_INCL_UNSPENT_AMT_FLAG
, TRACK_WORKPLAN_COSTS_FLAG TRACK_WORKPLAN_COSTS_FLAG
, RBS_VERSION_ID RBS_VERSION_ID
, GEN_SRC_COST_WP_VERSION_ID GEN_SRC_COST_WP_VERSION_ID
, GEN_SRC_COST_WP_VER_CODE GEN_SRC_COST_WP_VER_CODE
, GEN_SRC_REV_WP_VERSION_ID GEN_SRC_REV_WP_VERSION_ID
, GEN_SRC_REV_WP_VER_CODE GEN_SRC_REV_WP_VER_CODE
, GEN_SRC_ALL_WP_VERSION_ID GEN_SRC_ALL_WP_VERSION_ID
, GEN_SRC_ALL_WP_VER_CODE GEN_SRC_ALL_WP_VER_CODE
, COST_LAYOUT_CODE COST_LAYOUT_CODE
, REVENUE_LAYOUT_CODE REVENUE_LAYOUT_CODE
, ALL_LAYOUT_CODE ALL_LAYOUT_CODE
, REVENUE_DERIVATION_METHOD REVENUE_DERIVATION_METHOD
, COPY_ETC_FROM_PLAN_FLAG COPY_ETC_FROM_PLAN_FLAG
, DEFAULT_RAW_COST DEFAULT_RAW_COST
, DEFAULT_BILL_RATE DEFAULT_BILL_RATE
, DEF_MARKUP_PERCENTAGE DEF_MARKUP_PERCENTAGE
, DEF_RAW_COST_CURRENCY_CODE DEF_RAW_COST_CURRENCY_CODE
, DEF_BILL_RATE_CURRENCY_CODE DEF_BILL_RATE_CURRENCY_CODE
FROM "PA"."PA_PROJ_FP_OPTIONS"