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_FIN_PLAN_TYPES_B

Object Details

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

This table stores the various plan types for financial plans.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_FIN_PLAN_TYPES_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FIN_PLAN_TYPE_ID ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
FIN_PLAN_TYPE_ID	NUMBER	(15)	Yes	System generated number to uniquely identify row
FIN_PLAN_TYPE_CODE	VARCHAR2	(30)		The type of plan to forecast
PRE_DEFINED_FLAG	VARCHAR2	(1)	Yes	The identifier of pre-defined data. Valid values are Y and N
GENERATED_FLAG	VARCHAR2	(1)	Yes	The identifier of whether the plan type allows generation or is manually entered. Valid values are Y and N
EDIT_GENERATED_AMT_FLAG	VARCHAR2	(1)	Yes	The identiier of whether the generated amounts for the plan type can be edited
USED_IN_BILLING_FLAG	VARCHAR2	(1)		The identiier of whether the plan type can be used in billing. Valid values are Y and N
ENABLE_WF_FLAG	VARCHAR2	(1)	Yes	The identiier of whether the plan type will call workflow when the status changes
START_DATE_ACTIVE	DATE		Yes	The effective start date of the financial play type
END_DATE_ACTIVE	DATE			The effective end date of the financial play type
RECORD_VERSION_NUMBER	NUMBER	(15)		Internally generated number used for record locking
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
PLAN_CLASS_CODE	VARCHAR2	(30)	Yes	Plan Class for the plan type
APPROVED_COST_PLAN_TYPE_FLAG	VARCHAR2	(1)		This flag indicates if this plan type can be used as an approved cost budget or not.
APPROVED_REV_PLAN_TYPE_FLAG	VARCHAR2	(1)		This flag indicates if this plan type can be used as an approved revenue budget or not.
PROJFUNC_COST_RATE_TYPE	VARCHAR2	(30)		The project functional cost rate type
PROJFUNC_COST_RATE_DATE_TYPE	VARCHAR2	(30)		The project functional cost rate date type
PROJFUNC_COST_RATE_DATE	DATE			The project functional cost rate date
PROJFUNC_REV_RATE_TYPE	VARCHAR2	(30)		The project functional revenue rate type
PROJFUNC_REV_RATE_DATE_TYPE	VARCHAR2	(30)		The project functional revenue rate date type
PROJFUNC_REV_RATE_DATE	DATE			The project functional revenue rate date
PROJECT_COST_RATE_TYPE	VARCHAR2	(30)		The project cost rate type
PROJECT_COST_RATE_DATE_TYPE	VARCHAR2	(30)		The project cost rate date type
PROJECT_COST_RATE_DATE	DATE			The project cost rate date
PROJECT_REV_RATE_TYPE	VARCHAR2	(30)		The project revenue rate type
PROJECT_REV_RATE_DATE_TYPE	VARCHAR2	(30)		The project revenue rate date type
PROJECT_REV_RATE_DATE	DATE			The project revenue rate date
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield context field
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
MIGRATED_FRM_BDGT_TYP_CODE	VARCHAR2	(30)		Identifier of the budget type the plan type has been migrated from
ENABLE_PARTIAL_IMPL_FLAG	VARCHAR2	(1)		This flag indentifies whether the partial revenue implementation is allowed for the approved revenue budget plan type.
PRIMARY_COST_FORECAST_FLAG	VARCHAR2	(1)		Indicates whether a forecast is primary cost forecast.
PRIMARY_REV_FORECAST_FLAG	VARCHAR2	(1)		Indicates whether a forecast is primary revenue forecast.
EDIT_AFTER_BASELINE_FLAG	VARCHAR2	(1)		Indicates whether edition of a current working version after baseline is possible.
USE_FOR_WORKPLAN_FLAG	VARCHAR2	(1)		Indicates if the plan type is used for work planning.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT FIN_PLAN_TYPE_ID
,      FIN_PLAN_TYPE_CODE
,      PRE_DEFINED_FLAG
,      GENERATED_FLAG
,      EDIT_GENERATED_AMT_FLAG
,      USED_IN_BILLING_FLAG
,      ENABLE_WF_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      RECORD_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PLAN_CLASS_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
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      MIGRATED_FRM_BDGT_TYP_CODE
,      ENABLE_PARTIAL_IMPL_FLAG
,      PRIMARY_COST_FORECAST_FLAG
,      PRIMARY_REV_FORECAST_FLAG
,      EDIT_AFTER_BASELINE_FLAG
,      USE_FOR_WORKPLAN_FLAG
,      ZD_EDITION_NAME
FROM PA.PA_FIN_PLAN_TYPES_B;

Dependencies

[top of page]

PA.PA_FIN_PLAN_TYPES_B does not reference any database object

PA.PA_FIN_PLAN_TYPES_B is referenced by following:

PA: PA_FIN_PLAN_TYPES_B#