eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PA.PA_PROJ_FP_OPTIONS

Object Details

Object Name:	PA_PROJ_FP_OPTIONS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_PROJ_FP_OPTIONS
Subobject Name:
Status:	VALID

This table stores the default financial planning options for a project, plan type or plan version.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PROJ_FP_OPTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROJ_FP_OPTIONS_ID
PA_PROJ_FP_OPTIONS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROJECT_ID FIN_PLAN_TYPE_ID FIN_PLAN_VERSION_ID
PA_PROJ_FP_OPTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FIN_PLAN_VERSION_ID
PA_PROJ_FP_OPTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COST_PERIOD_MASK_ID
PA_PROJ_FP_OPTIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REV_PERIOD_MASK_ID
PA_PROJ_FP_OPTIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ALL_PERIOD_MASK_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PROJ_FP_OPTIONS_ID	NUMBER	(15)	Yes	The system generated number that uniquely identifies the financial planning option
RECORD_VERSION_NUMBER	NUMBER	(15)	Yes	Internally generated number used for record locking
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project
FIN_PLAN_OPTION_LEVEL_CODE	VARCHAR2	(30)	Yes	Indicates the level at which the plan option is stored
FIN_PLAN_TYPE_ID	NUMBER	(15)		The identifier of the plan type associated with the planning options
FIN_PLAN_START_DATE	DATE			The start date of the planning option
FIN_PLAN_END_DATE	DATE			The end date of the planning option
FIN_PLAN_PREFERENCE_CODE	VARCHAR2	(30)		Indicates the planning preference for the option. You can choose to plan for cost and revenue in different ways as specified by this preference
ALL_AMOUNT_SET_ID	NUMBER	(15)		The amount set to be used when planning for cost and revenue together
COST_AMOUNT_SET_ID	NUMBER	(15)		The amount set to be used for cost plans
REVENUE_AMOUNT_SET_ID	NUMBER	(15)		The amount set to be used for revenue plans
ALL_FIN_PLAN_LEVEL_CODE	VARCHAR2	(30)		Planning level when planning for cost and revenue together
ALL_TIME_PHASED_CODE	VARCHAR2	(30)		Then indicator of what time periods to be used, if applicable, when planning for cost and revenue amounts together
ALL_RESOURCE_LIST_ID	NUMBER	(15)		The resource list used while planning for cost and revenue together
COST_FIN_PLAN_LEVEL_CODE	VARCHAR2	(30)		Planning level for cost plans
COST_TIME_PHASED_CODE	VARCHAR2	(30)		Then indicator of what time periods to be used, if applicable, for cost plans
COST_RESOURCE_LIST_ID	NUMBER	(15)		The resource list to be used for cost plans
REVENUE_FIN_PLAN_LEVEL_CODE	VARCHAR2	(30)		Planning level for revenue plans
REVENUE_RESOURCE_LIST_ID	NUMBER	(15)		The resource list to be used for revenue plans
REVENUE_TIME_PHASED_CODE	VARCHAR2	(30)		Then indicator of what time periods to be used, if applicable, for revenue plans
REPORT_LABOR_HRS_FROM_CODE	VARCHAR2	(30)		Indicates where to report Labor Hours from, while displaying cost and revenue plan amounts. This column is only applicable if the planning for cost and revenue amounts separately
FIN_PLAN_VERSION_ID	NUMBER	(15)		The identifier of the plan version to which this planning option is applicable. Values for this column are applicable only for Plan Version Level records
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column
DEFAULT_AMOUNT_TYPE_CODE	VARCHAR2	(30)		Internal Column used for displaying the amounts
DEFAULT_AMOUNT_SUBTYPE_CODE	VARCHAR2	(30)		Internal Column used for displaying the amounts
PLAN_IN_MULTI_CURR_FLAG	VARCHAR2	(1)		Indicates whether the plan amounts can be entered in any currency
FACTOR_BY_CODE	VARCHAR2	(30)		Indicates the quantum by which amounts will be factored during display. Set at the project planning option level only
APPROVED_COST_PLAN_TYPE_FLAG	VARCHAR2	(1)		Indicates whether this plan type is used as an approved cost budget
APPROVED_REV_PLAN_TYPE_FLAG	VARCHAR2	(1)		This flag indicates whether this plan type is used as an approved revenue budget
PROJFUNC_COST_RATE_TYPE	VARCHAR2	(30)		The cost rate type for project functional currency
PROJFUNC_COST_RATE_DATE_TYPE	VARCHAR2	(30)		The cost rate date type for project functional currency
PROJFUNC_COST_RATE_DATE	DATE			The cost rate date for project functional currency
PROJFUNC_REV_RATE_TYPE	VARCHAR2	(30)		The revenue rate type for project functional currency
PROJFUNC_REV_RATE_DATE_TYPE	VARCHAR2	(30)		The revenue rate date type for project functional currency
PROJFUNC_REV_RATE_DATE	DATE			The revenue rate date for project functional currency
PROJECT_COST_RATE_TYPE	VARCHAR2	(30)		The cost rate type for project currency
PROJECT_COST_RATE_DATE_TYPE	VARCHAR2	(30)		The cost rate date type for project currency
PROJECT_COST_RATE_DATE	DATE			The cost rate date for project currency
PROJECT_REV_RATE_TYPE	VARCHAR2	(30)		The revenue rate type for project currency
PROJECT_REV_RATE_DATE_TYPE	VARCHAR2	(30)		The revenue rate date type for project currency
PROJECT_REV_RATE_DATE	DATE			The revenue rate date for project currency
MARGIN_DERIVED_FROM_CODE	VARCHAR2	(30)		Indicates if margin is calculated from raw cost or burdened cost. Also indicates if raw cost or burdened cost is to be reported in the pages..
SELECT_COST_RES_AUTO_FLAG	VARCHAR2	(1)		Indicates if resources should be automatically added to new cost plannable elements (project/tasks). VaIid Values: Y/N
COST_RES_PLANNING_LEVEL	VARCHAR2	(1)		Indicates if Resources or Resource Groups needs to added to the cost plannable tasks automatically. Applicable when COST_AUTO_RES_SELECTION is Yes.
SELECT_REV_RES_AUTO_FLAG	VARCHAR2	(1)		Indiacates if resources should be automatically added to new revenue plannable elements (project/tasks). Valid Values: Y/N
REVENUE_RES_PLANNING_LEVEL	VARCHAR2	(1)		Indicates if Resources or Resource Groups needs to added to the cost plannable tasks automatically. Applicable when REVENUE_AUTO_RES_SELECTION is Yes.
SELECT_ALL_RES_AUTO_FLAG	VARCHAR2	(1)		Indicates if resources should be automatically added to new plannable elements in case plannig is done for cost and revenue together. (project/tasks). Valid Values: Y/N
ALL_RES_PLANNING_LEVEL	VARCHAR2	(1)		Indicates if Resources or Resource Groups needs to added to the cost plannable tasks automatically. Applicable when ALL_AUTO_RES_SELECTION is Yes.
PROCESS_UPDATE_WBS_FLAG	VARCHAR2	(1)		This column indicates whether the budget version requires a planning elements refresh
REQUEST_ID	NUMBER	(15)		Stores the concurrent request Id
PLAN_PROCESSING_CODE	VARCHAR2	(30)		Stores the concurrent request Id.
PRIMARY_COST_FORECAST_FLAG	VARCHAR2	(1)		Indicates if the plan type is a primary cost forecast.
PRIMARY_REV_FORECAST_FLAG	VARCHAR2	(1)		Indicates if the plan type is a primary revenue forecast.
USE_PLANNING_RATES_FLAG	VARCHAR2	(1)		Indicates if the planning options uses the planning rates. When N, schedules for class and organization need to be selected by the user..
RES_CLASS_RAW_COST_SCH_ID	NUMBER	(15)		Indicates the raw cost rate schedule for resource class.
RES_CLASS_BILL_RATE_SCH_ID	NUMBER	(15)		Indicates the bill rate schedule for resource class.
COST_EMP_RATE_SCH_ID	NUMBER	(15)		Indicates the employee rate schedule id for cost.
COST_JOB_RATE_SCH_ID	NUMBER	(15)		Indicate the job rate schedule id for cost.
COST_NON_LABOR_RES_RATE_SCH_ID	NUMBER	(15)		Indicates the resource class rate schedule id for cost.
COST_RES_CLASS_RATE_SCH_ID	NUMBER	(15)		Indicates the burden rate schedule id for cost.
COST_BURDEN_RATE_SCH_ID	NUMBER	(15)		Indicates current planning period for cost.
COST_CURRENT_PLANNING_PERIOD	VARCHAR2	(15)		Indicates current planning period for cost.
COST_PERIOD_MASK_ID	NUMBER	(15)		The identifier of the period mask that is used for the cost options.
REV_EMP_RATE_SCH_ID	NUMBER	(15)		Indicates the employee rate schedule id for revenue.
REV_JOB_RATE_SCH_ID	NUMBER	(15)		Indicate the job rate schedule id for revenue.
REV_NON_LABOR_RES_RATE_SCH_ID	NUMBER	(15)		Indicates the resource class rate schedule id for revenue.
REV_RES_CLASS_RATE_SCH_ID	NUMBER	(15)		Indicates current planning period for revenue..
REV_CURRENT_PLANNING_PERIOD	VARCHAR2	(15)		Indicates current planning period for revenue..
REV_PERIOD_MASK_ID	NUMBER	(15)		The identifier of the period mask that is used for the revenue options.
ALL_CURRENT_PLANNING_PERIOD	VARCHAR2	(15)		Indicates current planning period for cost and revenue together.
ALL_PERIOD_MASK_ID	NUMBER	(15)		Cost source code to be used in generation.
GEN_COST_SRC_CODE	VARCHAR2	(30)		Source of forecast generation for cost only.
GEN_COST_ETC_SRC_CODE	VARCHAR2	(30)		Indicates if change documents will be included in the generation of budgets and forecasts for cost.
GEN_COST_INCL_CHANGE_DOC_FLAG	VARCHAR2	(1)		Indicates if change documents will be included in the generation of budgets and forecasts for cost.
GEN_COST_INCL_OPEN_COMM_FLAG	VARCHAR2	(1)		Indicates if open commitments will be included in the generation of forecasts for cost.
GEN_COST_RET_MANUAL_LINE_FLAG	VARCHAR2	(1)		Indicates if manually added cost plan line amounts must be retained.
GEN_COST_ACTUAL_AMTS_THRU_CODE	VARCHAR2	(30)		Indicates the end period of actual data to be used in generation of forecasts for cost .
GEN_COST_INCL_UNSPENT_AMT_FLAG	VARCHAR2	(1)		Indicates if unspent amounts will be used in generation of forecast generation for cost .
GEN_REV_SRC_CODE	VARCHAR2	(30)		Revenue source code to be used in generation.
GEN_REV_ETC_SRC_CODE	VARCHAR2	(30)		Source of forecast generation for revenue only.
GEN_REV_INCL_CHANGE_DOC_FLAG	VARCHAR2	(1)		Indicates if change documents will be included in the generation of budgets and forecasts for revenue.
GEN_REV_INCL_BILL_EVENT_FLAG	VARCHAR2	(1)		Indicates if manual-billing events will be included in generating the budget or forecast for revenue.
GEN_REV_RET_MANUAL_LINE_FLAG	VARCHAR2	(1)		Indicates if manually added revenue plan line amounts must be retained.
GEN_REV_ACTUAL_AMTS_THRU_CODE	VARCHAR2	(30)		Indicates the end period of actual data to be used in generation of forecasts for revenue .
GEN_SRC_COST_PLAN_TYPE_ID	NUMBER	(15)		Cost plan type to be used in generation.
GEN_SRC_COST_PLAN_VERSION_ID	NUMBER	(15)		Cost plan version to be used in deriving cost numbers during generation.
GEN_SRC_COST_PLAN_VER_CODE	VARCHAR2	(30)		Cost plan version code to be used in deriving cost numbers during generation.
GEN_SRC_REV_PLAN_TYPE_ID	NUMBER	(15)		Revenue plan type id to be used in deriving cost numbers during generation.
GEN_SRC_REV_PLAN_VERSION_ID	NUMBER	(15)		Revenue plan version id to be used in deriving cost numbers during generation.
GEN_SRC_REV_PLAN_VER_CODE	VARCHAR2	(30)		Revenue plan version code to be used in deriving cost numbers during generation.
GEN_SRC_ALL_PLAN_TYPE_ID	NUMBER	(15)		Cost and Revenue plan type id to be used in deriving cost numbers during generation.
GEN_SRC_ALL_PLAN_VERSION_ID	NUMBER	(15)		Cost and Revenue plan version id to be used in deriving cost numbers during generation.
GEN_SRC_ALL_PLAN_VER_CODE	VARCHAR2	(30)		Cost and Revenue plan version code to be used in deriving cost numbers during generation.
GEN_ALL_SRC_CODE	VARCHAR2	(30)		Cost and Revenue source code to be used in generation.
GEN_ALL_ETC_SRC_CODE	VARCHAR2	(30)		Indicates if change documents will be included in the generation of budgets and forecasts for cost and revenue together.
GEN_ALL_INCL_CHANGE_DOC_FLAG	VARCHAR2	(1)		Indicates if change documents will be included in the generation of budgets and forecasts for cost and revenue together.
GEN_ALL_INCL_OPEN_COMM_FLAG	VARCHAR2	(1)		Indicates if open commitments will be included in the generation of forecasts for cost and revenue together.
GEN_ALL_RET_MANUAL_LINE_FLAG	VARCHAR2	(1)		Indicates if manually added plan line amounts must be retained.
GEN_ALL_INCL_BILL_EVENT_FLAG	VARCHAR2	(1)		Indicates if manual-billing events will be included in generating the budget or forecast for revenue and cost together.
GEN_ALL_ACTUAL_AMTS_THRU_CODE	VARCHAR2	(30)		Indicates the end period of actual data to be used in generation of forecasts for cost and revenue together.
GEN_ALL_INCL_UNSPENT_AMT_FLAG	VARCHAR2	(1)		Indicates if unspent amounts will be used in generation of forecast generation for cost and revenue together.
TRACK_WORKPLAN_COSTS_FLAG	VARCHAR2	(1)		Indicates whether work plan costs are tracked
RBS_VERSION_ID	NUMBER	(15)		Indicates the RBS version
GEN_SRC_COST_WP_VERSION_ID	NUMBER	(15)		Indicates workplan version to be used for generation of cost numbers.
GEN_SRC_COST_WP_VER_CODE	VARCHAR2	(30)		Indicates workplan version code used to identify a workplan version which inturn is used for generation of cost numbers.
GEN_SRC_REV_WP_VERSION_ID	NUMBER	(15)		Indicates workplan version to be used for generation of revenue numbers.
GEN_SRC_REV_WP_VER_CODE	VARCHAR2	(30)		Indicates workplan version code used to identify a workplan version which inturn is used for generation of revenue numbers.
GEN_SRC_ALL_WP_VERSION_ID	NUMBER	(15)		Indicates workplan version to be used for generation of cost and revenue numbers.
GEN_SRC_ALL_WP_VER_CODE	VARCHAR2	(30)		Indicates workplan version code used to identify a workplan version which inturn is used for generation of cost and revenue numbers.
COST_LAYOUT_CODE	VARCHAR2	(30)		MS Excel Layout Code used for Cost Options
REVENUE_LAYOUT_CODE	VARCHAR2	(30)		MS Excel Layout Code used for Revenue Options
ALL_LAYOUT_CODE	VARCHAR2	(30)		MS Excel Layout Code used for Cost and Revenue
REVENUE_DERIVATION_METHOD	VARCHAR2	(30)		This column indicates the revenue generation method for a Revenue Plan Version.
COPY_ETC_FROM_PLAN_FLAG	VARCHAR2	(1)		This is used to store the Copy ETC from plan flag.
DEFAULT_RAW_COST	NUMBER			This column indicates the default raw cost.
DEFAULT_BILL_RATE	NUMBER			This column indicates the default bill rate.
DEF_MARKUP_PERCENTAGE	NUMBER	(9)		This column indicates the default markup percentage.
DEF_RAW_COST_CURRENCY_CODE	VARCHAR2	(15)		This column indicates the default currency information for raw cost.
DEF_BILL_RATE_CURRENCY_CODE	VARCHAR2	(15)		This column indicates the default currency information for bill rate.

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 does not reference any database object

PA.PA_PROJ_FP_OPTIONS is referenced by following:

PA: PA_PROJ_FP_OPTIONS#