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_FORECASTING_OPTIONS_ALL

Object Details

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

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_FORECASTING_OPTIONS_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORG_ID	NUMBER			Operating Unit Identifier for Multi-Organization installations
INCLUDE_ADMIN_PROJ_FLAG	VARCHAR2	(1)	Yes	Obsolete. Not in use.
GL_PERIOD_FLAG	VARCHAR2	(1)	Yes	Obsolete. Not in use.
PA_PERIOD_FLAG	VARCHAR2	(1)	Yes	Obsolete. Not in use.
MAX_HISTORICAL_VERSIONS	NUMBER		Yes	Obsolete. Not in use.
FORECAST_THRU_DATE	DATE			Indicates if Forecast information will be available by forecast thru date. => Date till forecast utilization has been calculated
ACTUALS_THRU_DATE	DATE			Indicates if Forecast information will be available by actuals thru date. => Date till actuals utilization has been calculated
UTIL_CALC_METHOD	VARCHAR2	(30)	Yes	Obsolete. Not in use.
DEFAULT_ASSIGN_EXP_TYPE_CLASS	VARCHAR2	(30)	Yes	Default labor expenditure type class for the default expenditure type for the requirement or assignment. The labor expenditure type on the requirement or assignment is used in determining the forecast burdened cost.
DEFAULT_ASSIGN_EXP_TYPE	VARCHAR2	(30)	Yes	Default labor expenditure type for the requirement or assignment. The labor expenditure type on the requirement or assignment is used in determining the forecast burdened cost.
DEFAULT_TP_AMOUNT_TYPE	VARCHAR2	(30)	Yes	Default transfer price amount type for the requirement or assignment. The transfer price amount type on the requirement or assignment is used in classification of forecast cross charged cost for the project or organization.
BILL_UNASSIGN_TIME_FLAG	VARCHAR2	(1)	Yes	Flag that indicates if organization forecast should include raw or burdened forecast costs for unassigned time for billable resource => Default value for this column is "N"
NONBILL_UNASSIGN_TIME_FLAG	VARCHAR2	(1)	Yes	Flag that indicates if organization forecast should include raw or burdened forecast costs for unassigned time for Non - billable resource => Default value for this column is "N"
BILL_UNASSIGN_PROJ_ID	NUMBER			The administrative project to which the resources unassigned time is charged to.
BILL_UNASSIGN_EXP_TYPE_CLASS	VARCHAR2	(30)		The labor expenditure type class for the expenditure type to be used for calculation of burdened forecast cost for billable resources unassigned time.
BILL_UNASSIGN_EXP_TYPE	VARCHAR2	(30)		The labor expenditure type to be used for calculation of burdened forecast cost for billable resources unassigned time.
NONBILL_UNASSIGN_PROJ_ID	NUMBER			The administrative project to which resource unassigned time is charged to for the non billable resources.
NONBILL_UNASSIGN_EXP_TYP_CLS	VARCHAR2	(30)		The labor expenditure type class for expenditure type to be used for calculation of burdened forecast cost for unassigned time for the non billable resources.
NONBILL_UNASSIGN_EXP_TYPE	VARCHAR2	(30)		The labor expenditure type to be used for calculation of burdened forecast cost for unassigned time for the non billable resources.
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
JOB_COST_RATE_SCHEDULE_ID	NUMBER			Stores the Job-based Cost Rate Schedule ID
KEY_MEMBER_ROLE_ID	NUMBER			Stores the unique identifier of the role that is used as the Project owner in the forecasting pages
FORECAST_CLASS_CATEGORY	VARCHAR2	(30)		Stores the Project Class Category for which the class code is displayed in the forecasting pages
ORG_FCST_PERIOD_TYPE	VARCHAR2	(30)
START_PERIOD_NAME	VARCHAR2	(30)
NUMBER_OF_PERIODS	NUMBER
WEIGHTED_OR_FULL_CODE	VARCHAR2	(30)
ORG_FCST_PROJECT_TEMPLATE_ID	NUMBER	(15)

Query Text

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


SELECT ORG_ID
,      INCLUDE_ADMIN_PROJ_FLAG
,      GL_PERIOD_FLAG
,      PA_PERIOD_FLAG
,      MAX_HISTORICAL_VERSIONS
,      FORECAST_THRU_DATE
,      ACTUALS_THRU_DATE
,      UTIL_CALC_METHOD
,      DEFAULT_ASSIGN_EXP_TYPE_CLASS
,      DEFAULT_ASSIGN_EXP_TYPE
,      DEFAULT_TP_AMOUNT_TYPE
,      BILL_UNASSIGN_TIME_FLAG
,      NONBILL_UNASSIGN_TIME_FLAG
,      BILL_UNASSIGN_PROJ_ID
,      BILL_UNASSIGN_EXP_TYPE_CLASS
,      BILL_UNASSIGN_EXP_TYPE
,      NONBILL_UNASSIGN_PROJ_ID
,      NONBILL_UNASSIGN_EXP_TYP_CLS
,      NONBILL_UNASSIGN_EXP_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      JOB_COST_RATE_SCHEDULE_ID
,      KEY_MEMBER_ROLE_ID
,      FORECAST_CLASS_CATEGORY
,      ORG_FCST_PERIOD_TYPE
,      START_PERIOD_NAME
,      NUMBER_OF_PERIODS
,      WEIGHTED_OR_FULL_CODE
,      ORG_FCST_PROJECT_TEMPLATE_ID
FROM PA.PA_FORECASTING_OPTIONS_ALL;

Dependencies

[top of page]

PA.PA_FORECASTING_OPTIONS_ALL does not reference any database object

PA.PA_FORECASTING_OPTIONS_ALL is referenced by following:

APPS: PA_FORECASTING_OPTIONS; PA_FORECASTING_OPTIONS_ALL