[Home] [Help] [Dependency Information]

VIEW: PA.PA_PROJ_FP_OPTIONS#

Object Details

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

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

Dependencies

[top of page]

PA

PA_PROJ_FP_OPTIONS

APPS

PA_PROJ_FP_OPTIONS