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]

VIEW: APPS.PA_FINPLAN_TYPES_V

Object Details

Object Name:	PA_FINPLAN_TYPES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_FINPLAN_TYPES_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view displays all the valid budget types and plan types which are used for different business purposes of a project.

[View Source]

Columns

Name	Datatype	Length	Comments
FIN_PLAN_TYPE_ID	NUMBER		When Fp_type_code is PLAN_TYPE, this column returns the fin_plan_type_id from pa_fin_plan_types_b. When Fp_type_code is BUDGET_TYPE, this column returns -1
NAME	VARCHAR2	(150)	Name of the financial plan type or the budget type
DESCRIPTION	VARCHAR2	(2000)	Description of the financial plan type or the budget type
PRE_DEFINED_FLAG	VARCHAR2	(1)	The identifier of pre-defined data. Valid values are Y and N
ENABLE_WF_FLAG	VARCHAR2	(1)	The identiier of whether the plan type will call workflow when the status changes. Valid values are Y and N
PLAN_CLASS_CODE	VARCHAR2	(30)	Indicates the Plan Class for the plan type
MIGRATED_FRM_BDGT_TYP_CODE	VARCHAR2	(30)	Contains the budget_type_code of the upgraded budget_type to financial_plan_type
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)	Indicates whether this plan type is used as an approved revenue budget.
FP_TYPE_CODE	VARCHAR2	(11)	Quick code column. Indicates plan type or budget type
BUDGET_TYPE_CODE	VARCHAR2	(30)	When Fp_type_code is BUDGET_TYPE, this column returns the budget_type_code from pa_budget_types. When Fp_type_code is PLAN_TYPE, this column returns Null.
BUDGET_AMOUNT_CODE	VARCHAR2	(30)	When Fp_type_code is BUDGET_TYPE, this column returns the budget_amount_code from pa_budget_types. When Fp_type_code is PLAN_TYPE, this column returns the fin_plan_preference_code from pa_proj_fp_options for the plan type
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_FOR_WORKPLAN_FLAG	VARCHAR2	(1)	Indicates if the plan type is used for work planning.

Query Text

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


SELECT FIN_PLAN_TYPE_ID
,      NAME
,      DESCRIPTION
,      PRE_DEFINED_FLAG
,      ENABLE_WF_FLAG
,      PLAN_CLASS_CODE
,      MIGRATED_FRM_BDGT_TYP_CODE
,      APPROVED_COST_PLAN_TYPE_FLAG
,      APPROVED_REV_PLAN_TYPE_FLAG
,      FP_TYPE_CODE
,      BUDGET_TYPE_CODE
,      BUDGET_AMOUNT_CODE
,      PRIMARY_COST_FORECAST_FLAG
,      PRIMARY_REV_FORECAST_FLAG
,      USE_FOR_WORKPLAN_FLAG
FROM APPS.PA_FINPLAN_TYPES_V;

Dependencies

[top of page]

APPS.PA_FINPLAN_TYPES_V references the following:

APPS: PA_BUDGET_PUB - show dependent code; PA_BUDGET_TYPES; PA_FIN_PLAN_TYPES_B; PA_FIN_PLAN_TYPES_VL; PA_PROJ_FP_OPTIONS

APPS.PA_FINPLAN_TYPES_V is not referenced by any database object