[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_PROJ_FP_OPTIONS# |
|---|---|
| Object Type: | VIEW |
| Owner: | PA |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PROJ_FP_OPTIONS_ID | NUMBER | (15) | Yes | |
| RECORD_VERSION_NUMBER | NUMBER | (15) | Yes | |
| PROJECT_ID | NUMBER | (15) | Yes | |
| FIN_PLAN_OPTION_LEVEL_CODE | VARCHAR2 | (30) | Yes | |
| FIN_PLAN_TYPE_ID | NUMBER | (15) | ||
| FIN_PLAN_START_DATE | DATE | |||
| FIN_PLAN_END_DATE | DATE | |||
| FIN_PLAN_PREFERENCE_CODE | VARCHAR2 | (30) | ||
| ALL_AMOUNT_SET_ID | NUMBER | (15) | ||
| COST_AMOUNT_SET_ID | NUMBER | (15) | ||
| REVENUE_AMOUNT_SET_ID | NUMBER | (15) | ||
| ALL_FIN_PLAN_LEVEL_CODE | VARCHAR2 | (30) | ||
| ALL_TIME_PHASED_CODE | VARCHAR2 | (30) | ||
| ALL_RESOURCE_LIST_ID | NUMBER | (15) | ||
| COST_FIN_PLAN_LEVEL_CODE | VARCHAR2 | (30) | ||
| COST_TIME_PHASED_CODE | VARCHAR2 | (30) | ||
| COST_RESOURCE_LIST_ID | NUMBER | (15) | ||
| REVENUE_FIN_PLAN_LEVEL_CODE | VARCHAR2 | (30) | ||
| REVENUE_RESOURCE_LIST_ID | NUMBER | (15) | ||
| REVENUE_TIME_PHASED_CODE | VARCHAR2 | (30) | ||
| REPORT_LABOR_HRS_FROM_CODE | VARCHAR2 | (30) | ||
| FIN_PLAN_VERSION_ID | NUMBER | (15) | ||
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | |
| DEFAULT_AMOUNT_TYPE_CODE | VARCHAR2 | (30) | ||
| DEFAULT_AMOUNT_SUBTYPE_CODE | VARCHAR2 | (30) | ||
| PLAN_IN_MULTI_CURR_FLAG | VARCHAR2 | (1) | ||
| FACTOR_BY_CODE | VARCHAR2 | (30) | ||
| APPROVED_COST_PLAN_TYPE_FLAG | VARCHAR2 | (1) | ||
| APPROVED_REV_PLAN_TYPE_FLAG | VARCHAR2 | (1) | ||
| PROJFUNC_COST_RATE_TYPE | VARCHAR2 | (30) | ||
| PROJFUNC_COST_RATE_DATE_TYPE | VARCHAR2 | (30) | ||
| PROJFUNC_COST_RATE_DATE | DATE | |||
| PROJFUNC_REV_RATE_TYPE | VARCHAR2 | (30) | ||
| PROJFUNC_REV_RATE_DATE_TYPE | VARCHAR2 | (30) | ||
| PROJFUNC_REV_RATE_DATE | DATE | |||
| PROJECT_COST_RATE_TYPE | VARCHAR2 | (30) | ||
| PROJECT_COST_RATE_DATE_TYPE | VARCHAR2 | (30) | ||
| PROJECT_COST_RATE_DATE | DATE | |||
| PROJECT_REV_RATE_TYPE | VARCHAR2 | (30) | ||
| PROJECT_REV_RATE_DATE_TYPE | VARCHAR2 | (30) | ||
| PROJECT_REV_RATE_DATE | DATE | |||
| MARGIN_DERIVED_FROM_CODE | VARCHAR2 | (30) | ||
| SELECT_COST_RES_AUTO_FLAG | VARCHAR2 | (1) | ||
| COST_RES_PLANNING_LEVEL | VARCHAR2 | (1) | ||
| SELECT_REV_RES_AUTO_FLAG | VARCHAR2 | (1) | ||
| REVENUE_RES_PLANNING_LEVEL | VARCHAR2 | (1) | ||
| SELECT_ALL_RES_AUTO_FLAG | VARCHAR2 | (1) | ||
| ALL_RES_PLANNING_LEVEL | VARCHAR2 | (1) | ||
| PROCESS_UPDATE_WBS_FLAG | VARCHAR2 | (1) | ||
| REQUEST_ID | NUMBER | (15) | ||
| PLAN_PROCESSING_CODE | VARCHAR2 | (30) | ||
| PRIMARY_COST_FORECAST_FLAG | VARCHAR2 | (1) | ||
| PRIMARY_REV_FORECAST_FLAG | VARCHAR2 | (1) | ||
| USE_PLANNING_RATES_FLAG | VARCHAR2 | (1) | ||
| RES_CLASS_RAW_COST_SCH_ID | NUMBER | (15) | ||
| RES_CLASS_BILL_RATE_SCH_ID | NUMBER | (15) | ||
| COST_EMP_RATE_SCH_ID | NUMBER | (15) | ||
| COST_JOB_RATE_SCH_ID | NUMBER | (15) | ||
| COST_NON_LABOR_RES_RATE_SCH_ID | NUMBER | (15) | ||
| COST_RES_CLASS_RATE_SCH_ID | NUMBER | (15) | ||
| COST_BURDEN_RATE_SCH_ID | NUMBER | (15) | ||
| COST_CURRENT_PLANNING_PERIOD | VARCHAR2 | (15) | ||
| COST_PERIOD_MASK_ID | NUMBER | (15) | ||
| REV_EMP_RATE_SCH_ID | NUMBER | (15) | ||
| REV_JOB_RATE_SCH_ID | NUMBER | (15) | ||
| REV_NON_LABOR_RES_RATE_SCH_ID | NUMBER | (15) | ||
| REV_RES_CLASS_RATE_SCH_ID | NUMBER | (15) | ||
| REV_CURRENT_PLANNING_PERIOD | VARCHAR2 | (15) | ||
| REV_PERIOD_MASK_ID | NUMBER | (15) | ||
| ALL_CURRENT_PLANNING_PERIOD | VARCHAR2 | (15) | ||
| ALL_PERIOD_MASK_ID | NUMBER | (15) | ||
| GEN_COST_SRC_CODE | VARCHAR2 | (30) | ||
| GEN_COST_ETC_SRC_CODE | VARCHAR2 | (30) | ||
| GEN_COST_INCL_CHANGE_DOC_FLAG | VARCHAR2 | (1) | ||
| GEN_COST_INCL_OPEN_COMM_FLAG | VARCHAR2 | (1) | ||
| GEN_COST_RET_MANUAL_LINE_FLAG | VARCHAR2 | (1) | ||
| GEN_COST_ACTUAL_AMTS_THRU_CODE | VARCHAR2 | (30) | ||
| GEN_COST_INCL_UNSPENT_AMT_FLAG | VARCHAR2 | (1) | ||
| GEN_REV_SRC_CODE | VARCHAR2 | (30) | ||
| GEN_REV_ETC_SRC_CODE | VARCHAR2 | (30) | ||
| GEN_REV_INCL_CHANGE_DOC_FLAG | VARCHAR2 | (1) | ||
| GEN_REV_INCL_BILL_EVENT_FLAG | VARCHAR2 | (1) | ||
| GEN_REV_RET_MANUAL_LINE_FLAG | VARCHAR2 | (1) | ||
| GEN_REV_ACTUAL_AMTS_THRU_CODE | VARCHAR2 | (30) | ||
| GEN_SRC_COST_PLAN_TYPE_ID | NUMBER | (15) | ||
| GEN_SRC_COST_PLAN_VERSION_ID | NUMBER | (15) | ||
| GEN_SRC_COST_PLAN_VER_CODE | VARCHAR2 | (30) | ||
| GEN_SRC_REV_PLAN_TYPE_ID | NUMBER | (15) | ||
| GEN_SRC_REV_PLAN_VERSION_ID | NUMBER | (15) | ||
| GEN_SRC_REV_PLAN_VER_CODE | VARCHAR2 | (30) | ||
| GEN_SRC_ALL_PLAN_TYPE_ID | NUMBER | (15) | ||
| GEN_SRC_ALL_PLAN_VERSION_ID | NUMBER | (15) | ||
| GEN_SRC_ALL_PLAN_VER_CODE | VARCHAR2 | (30) | ||
| GEN_ALL_SRC_CODE | VARCHAR2 | (30) | ||
| GEN_ALL_ETC_SRC_CODE | VARCHAR2 | (30) | ||
| GEN_ALL_INCL_CHANGE_DOC_FLAG | VARCHAR2 | (1) | ||
| GEN_ALL_INCL_OPEN_COMM_FLAG | VARCHAR2 | (1) | ||
| GEN_ALL_RET_MANUAL_LINE_FLAG | VARCHAR2 | (1) | ||
| GEN_ALL_INCL_BILL_EVENT_FLAG | VARCHAR2 | (1) | ||
| GEN_ALL_ACTUAL_AMTS_THRU_CODE | VARCHAR2 | (30) | ||
| GEN_ALL_INCL_UNSPENT_AMT_FLAG | VARCHAR2 | (1) | ||
| TRACK_WORKPLAN_COSTS_FLAG | VARCHAR2 | (1) | ||
| RBS_VERSION_ID | NUMBER | (15) | ||
| GEN_SRC_COST_WP_VERSION_ID | NUMBER | (15) | ||
| GEN_SRC_COST_WP_VER_CODE | VARCHAR2 | (30) | ||
| GEN_SRC_REV_WP_VERSION_ID | NUMBER | (15) | ||
| GEN_SRC_REV_WP_VER_CODE | VARCHAR2 | (30) | ||
| GEN_SRC_ALL_WP_VERSION_ID | NUMBER | (15) | ||
| GEN_SRC_ALL_WP_VER_CODE | VARCHAR2 | (30) | ||
| COST_LAYOUT_CODE | VARCHAR2 | (30) | ||
| REVENUE_LAYOUT_CODE | VARCHAR2 | (30) | ||
| ALL_LAYOUT_CODE | VARCHAR2 | (30) | ||
| REVENUE_DERIVATION_METHOD | VARCHAR2 | (30) | ||
| COPY_ETC_FROM_PLAN_FLAG | VARCHAR2 | (1) | ||
| DEFAULT_RAW_COST | NUMBER | |||
| DEFAULT_BILL_RATE | NUMBER | |||
| DEF_MARKUP_PERCENTAGE | NUMBER | (9) | ||
| DEF_RAW_COST_CURRENCY_CODE | VARCHAR2 | (15) | ||
| DEF_BILL_RATE_CURRENCY_CODE | VARCHAR2 | (15) |
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#;
PA
PA_PROJ_FP_OPTIONS
APPS
PA_PROJ_FP_OPTIONS
|
|
|
|