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

VIEW: APPS.PA_FIN_PLAN_TYPES_VL

Object Details
Object Name: PA_FIN_PLAN_TYPES_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_FIN_PLAN_TYPES_VL
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
FIN_PLAN_TYPE_ID NUMBER (15) Yes
FIN_PLAN_TYPE_CODE VARCHAR2 (30)
MIGRATED_FRM_BDGT_TYP_CODE VARCHAR2 (30)
PRE_DEFINED_FLAG VARCHAR2 (1) Yes
GENERATED_FLAG VARCHAR2 (1) Yes
EDIT_GENERATED_AMT_FLAG VARCHAR2 (1) Yes
USED_IN_BILLING_FLAG VARCHAR2 (1)
ENABLE_WF_FLAG VARCHAR2 (1) Yes
START_DATE_ACTIVE DATE
Yes
END_DATE_ACTIVE DATE

RECORD_VERSION_NUMBER NUMBER (15)
PLAN_CLASS_CODE VARCHAR2 (30) Yes
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

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
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
NAME VARCHAR2 (150) Yes
DESCRIPTION VARCHAR2 (2000)
ENABLE_PARTIAL_IMPL_FLAG VARCHAR2 (1)
PRIMARY_COST_FORECAST_FLAG VARCHAR2 (1)
PRIMARY_REV_FORECAST_FLAG VARCHAR2 (1)
EDIT_AFTER_BASELINE_FLAG VARCHAR2 (1)
USE_FOR_WORKPLAN_FLAG VARCHAR2 (1)
Query Text

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


SELECT ROW_ID
,      FIN_PLAN_TYPE_ID
,      FIN_PLAN_TYPE_CODE
,      MIGRATED_FRM_BDGT_TYP_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
,      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
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      NAME
,      DESCRIPTION
,      ENABLE_PARTIAL_IMPL_FLAG
,      PRIMARY_COST_FORECAST_FLAG
,      PRIMARY_REV_FORECAST_FLAG
,      EDIT_AFTER_BASELINE_FLAG
,      USE_FOR_WORKPLAN_FLAG
FROM APPS.PA_FIN_PLAN_TYPES_VL;

Dependencies

[top of page]

APPS.PA_FIN_PLAN_TYPES_VL references the following:

SchemaAPPS
SynonymPA_FIN_PLAN_TYPES_B
SynonymPA_FIN_PLAN_TYPES_TL
APPS.PA_FIN_PLAN_TYPES_VL is referenced by following:

SchemaAPPS
Package BodyPA_ALLOC_COPY_RULE_PKG - show dependent code
Package BodyPA_BUDGET_PUB - show dependent code
PL/SQL PackagePA_BUDGET_PUB - show dependent code
Package BodyPA_BUDGET_PVT - show dependent code
ViewPA_BUDGET_TYPES_V
ViewPA_CE_INTEGRATION_BUDGETS_V
Package BodyPA_CLIENT_EXTN_BUDGET_WF - show dependent code
ViewPA_FINPLAN_TYPES_V
ViewPA_FIN_PLAN_CREATE_PLAN_BV_V
ViewPA_FIN_PLAN_CREATE_PLAN_NOBV_V
Package BodyPA_FIN_PLAN_PUB - show dependent code
Package BodyPA_FIN_PLAN_PVT - show dependent code
ViewPA_FIN_PLAN_TYPES_B_V
Package BodyPA_FIN_PLAN_TYPES_UTILS - show dependent code
ViewPA_FIN_PLAN_TYPES_W_V
Package BodyPA_FIN_PLAN_TYPE_GLOBAL - show dependent code
PL/SQL PackagePA_FIN_PLAN_UTILS - show dependent code
Package BodyPA_FIN_PLAN_UTILS - show dependent code
PL/SQL PackagePA_FP_CALC_PLAN_PUB - show dependent code
Package BodyPA_FP_CALC_PLAN_PUB - show dependent code
Package BodyPA_FP_CI_MERGE - show dependent code
Package BodyPA_FP_CONTROL_ITEMS_UTILS - show dependent code
Package BodyPA_FP_EDIT_LINE_PKG - show dependent code
Package BodyPA_FP_GEN_AMOUNT_UTILS - show dependent code
Package BodyPA_FP_GEN_FCST_AMT_PUB1 - show dependent code
ViewPA_PROJ_FINPLAN_TYPES_V
Package BodyPA_PROJ_FP_OPTIONS_PUB - show dependent code
ViewPA_RESOURCE_LIST_USE_CODES_V
Package BodyPJI_PJP_SUM_MAIN - show dependent code
Package BodyPJI_REP_UTIL - show dependent code