VIEW: PA.PA_FP_ELEMENTS#

Source

View Text - Preformatted

select PROJ_FP_ELEMENTS_ID PROJ_FP_ELEMENTS_ID, PROJ_FP_OPTIONS_ID PROJ_FP_OPTIONS_ID, PROJECT_ID PROJECT_ID, FIN_PLAN_TYPE_ID FIN_PLAN_TYPE_ID, ELEMENT_TYPE ELEMENT_TYPE, FIN_PLAN_VERSION_ID FIN_PLAN_VERSION_ID, TASK_ID TASK_ID, TOP_TASK_ID TOP_TASK_ID, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID, TOP_TASK_PLANNING_LEVEL TOP_TASK_PLANNING_LEVEL, RESOURCE_PLANNING_LEVEL RESOURCE_PLANNING_LEVEL, PLANNABLE_FLAG PLANNABLE_FLAG, RESOURCES_PLANNED_FOR_TASK RESOURCES_PLANNED_FOR_TASK, PLAN_AMOUNT_EXISTS_FLAG PLAN_AMOUNT_EXISTS_FLAG, TMP_PLANNABLE_FLAG TMP_PLANNABLE_FLAG, TMP_TOP_TASK_PLANNING_LEVEL TMP_TOP_TASK_PLANNING_LEVEL, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "PA"."PA_FP_ELEMENTS"

View Text - HTML Formatted

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