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

VIEW: PA.PA_FP_ELEMENTS#

Object Details
Object Name: PA_FP_ELEMENTS#
Object Type: VIEW
Owner: PA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJ_FP_ELEMENTS_ID NUMBER (15) Yes
PROJ_FP_OPTIONS_ID NUMBER (15) Yes
PROJECT_ID NUMBER (15) Yes
FIN_PLAN_TYPE_ID NUMBER (15)
ELEMENT_TYPE VARCHAR2 (30) Yes
FIN_PLAN_VERSION_ID NUMBER (15)
TASK_ID NUMBER (15) Yes
TOP_TASK_ID NUMBER (15) Yes
RESOURCE_LIST_MEMBER_ID NUMBER (15) Yes
TOP_TASK_PLANNING_LEVEL VARCHAR2 (30)
RESOURCE_PLANNING_LEVEL VARCHAR2 (30)
PLANNABLE_FLAG VARCHAR2 (1) Yes
RESOURCES_PLANNED_FOR_TASK VARCHAR2 (1)
PLAN_AMOUNT_EXISTS_FLAG VARCHAR2 (1)
TMP_PLANNABLE_FLAG VARCHAR2 (1) Yes
TMP_TOP_TASK_PLANNING_LEVEL VARCHAR2 (30)
RECORD_VERSION_NUMBER NUMBER (15) Yes
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
Query Text

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


SELECT PROJ_FP_ELEMENTS_ID
,      PROJ_FP_OPTIONS_ID
,      PROJECT_ID
,      FIN_PLAN_TYPE_ID
,      ELEMENT_TYPE
,      FIN_PLAN_VERSION_ID
,      TASK_ID
,      TOP_TASK_ID
,      RESOURCE_LIST_MEMBER_ID
,      TOP_TASK_PLANNING_LEVEL
,      RESOURCE_PLANNING_LEVEL
,      PLANNABLE_FLAG
,      RESOURCES_PLANNED_FOR_TASK
,      PLAN_AMOUNT_EXISTS_FLAG
,      TMP_PLANNABLE_FLAG
,      TMP_TOP_TASK_PLANNING_LEVEL
,      RECORD_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM PA.PA_FP_ELEMENTS#;

Dependencies

[top of page]

PA.PA_FP_ELEMENTS# references the following:

SchemaPA
TablePA_FP_ELEMENTS
PA.PA_FP_ELEMENTS# is referenced by following:

SchemaAPPS
SynonymPA_FP_ELEMENTS