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

TABLE: PA.PA_STRUCTURES_TASKS_TMP

Object Details
Object Name: PA_STRUCTURES_TASKS_TMP
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_STRUCTURES_TASKS_TMP
Subobject Name:
Status: VALID

Temporary Table Details

PA.PA_STRUCTURES_TASKS_TMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
PA_STRUCTURES_TASKS_TMP_N1 NORMAL NONUNIQUE Tablespace ColumnPARENT_PROJECT_ID
PA_STRUCTURES_TASKS_TMP_N2 NORMAL NONUNIQUE Tablespace ColumnPROJECT_ID
ColumnPROJ_ELEMENT_ID
ColumnELEMENT_VERSION_ID
PA_STRUCTURES_TASKS_TMP_N3 NORMAL NONUNIQUE Tablespace ColumnPARENT_ELEMENT_VERSION_ID
PA_STRUCTURES_TASKS_TMP_N4 NORMAL NONUNIQUE Tablespace ColumnELEMENT_VERSION_ID
PA_STRUCTURES_TASKS_TMP_N5 NORMAL NONUNIQUE Tablespace ColumnPARENT_STRUCTURE_VERSION_ID
Columns
Name Datatype Length Mandatory Comments
PARENT_PROJECT_ID NUMBER

ELEMENT_NUMBER VARCHAR2 (100)
ELEMENT_NAME VARCHAR2 (240)
DESCRIPTION VARCHAR2 (2000)
OBJECT_TYPE VARCHAR2 (30)
ELEMENT_VERSION_ID NUMBER

PROJ_ELEMENT_ID NUMBER (15)
PROJECT_ID NUMBER

DISPLAY_SEQUENCE NUMBER

MILESTONE_FLAG VARCHAR2 (1)
MILESTONE_FLAG_MEANING VARCHAR2 (4000)
CRITICAL_FLAG VARCHAR2 (1)
CRITICAL_FLAG_MEANING VARCHAR2 (4000)
PARENT_ELEMENT_VERSION_ID NUMBER

PARENT_OBJECT_TYPE VARCHAR2 (30)
RELATIONSHIP_TYPE VARCHAR2 (30)
RELATIONSHIP_SUBTYPE VARCHAR2 (30)
SUMMARY_ELEMENT_FLAG VARCHAR2 (4000)
PROGRESS_STATUS_CODE VARCHAR2 (150)
PROGRESS_STATUS_MEANING VARCHAR2 (80)
PROGRESS_COMMENTS VARCHAR2 (4000)
PROGRESS_BRIEF_OVERVIEW VARCHAR2 (250)
SCHEDULED_START_DATE DATE

SCHEDULED_FINISH_DATE DATE

TASK_MANAGER_ID NUMBER (15)
TASK_MANAGER VARCHAR2 (240)
PARENT_STRUCTURE_VERSION_ID NUMBER (15)
WBS_LEVEL NUMBER (3)
WBS_NUMBER VARCHAR2 (240)
ELEM_REC_VER_NUMBER NUMBER (15)
ELEM_VER_REC_VER_NUMBER NUMBER (15)
ELEM_VER_SCH_REC_VER_NUMBER NUMBER (15)
PARENT_VER_REC_VER_NUMBER NUMBER (15)
STATUS_ICON_ACTIVE_IND VARCHAR2 (80)
PERCENT_COMPLETE_ID NUMBER (15)
STATUS_ICON_IND VARCHAR2 (80)
STATUS_CODE VARCHAR2 (150)
STATUS_CODE_MEANING VARCHAR2 (80)
PRIORITY_CODE VARCHAR2 (30)
PRIORITY_DESCRIPTION VARCHAR2 (4000)
ORGANIZATION_ID NUMBER (15)
ORGANIZATION_NAME VARCHAR2 (240)
INCLUDE_IN_PROJ_PROG_RPT VARCHAR2 (1)
ESTIMATED_START_DATE DATE

ESTIMATED_FINISH_DATE DATE

ACTUAL_START_DATE DATE

ACTUAL_FINISH_DATE DATE

COMPLETED_PERCENTAGE NUMBER

OBJECT_RELATIONSHIP_ID NUMBER

OBJECT_REC_VER_NUMBER NUMBER

PEV_SCHEDULE_ID NUMBER (15)
LATEST_EFF_PUBLISHED_FLAG VARCHAR2 (1)
PROJECT_NUMBER VARCHAR2 (25)
PROJECT_NAME VARCHAR2 (30)
PARENT_ELEMENT_ID NUMBER (15)
STRUCTURE_TYPE_CLASS_CODE VARCHAR2 (30)
PUBLISHED_DATE DATE

LINK_TASK_FLAG VARCHAR2 (1)
DISPLAY_PARENT_VERSION_ID NUMBER

AS_OF_DATE DATE

REPORT_VERSION_ID NUMBER

BASELINE_START_DATE DATE

BASELINE_FINISH_DATE DATE

SCH_BSL_START_VAR NUMBER

SCH_BSL_FINISH_VAR NUMBER

EST_SCH_START_VAR NUMBER

EST_SCH_FINISH_VAR NUMBER

ACT_SCH_START_VAR NUMBER

ACT_SCH_FINISH_VAR NUMBER

PM_SOURCE_NAME VARCHAR2 (4000)
PM_SOURCE_CODE VARCHAR2 (30)
PM_SOURCE_REFERENCE VARCHAR2 (25)
ACTIVE_TASK_FLAG VARCHAR2 (4000)
ACTIVE_TASK_MEANING VARCHAR2 (4000)
DAYS_TO_SCH_START NUMBER

DAYS_TO_SCH_FINISH NUMBER

WORK_TELEPHONE VARCHAR2 (60)
SERVICE_TYPE_MEANING VARCHAR2 (4000)
SERVICE_TYPE_CODE VARCHAR2 (30)
WORK_TYPE_NAME VARCHAR2 (80)
WORK_TYPE_ID NUMBER

CHARGEABLE_MEANING VARCHAR2 (4000)
CHARGEABLE_FLAG VARCHAR2 (1)
BILLABLE_MEANING VARCHAR2 (4000)
BILLABLE_FLAG VARCHAR2 (1)
RECEIVE_PROJECT_INVOICE_M VARCHAR2 (4000)
RECEIVE_PROJECT_INVOICE_FLAG VARCHAR2 (1)
TRANSACTION_CTRL_START_DATE DATE

TRANSACTION_CTRL_FINISH_DATE DATE

PRIOR_PERCENT_COMPLETE NUMBER

SCHEDULE_AS_OF_DATE DATE

TRANSACTION_AS_OF_DATE DATE

BASELINE_AS_OF_DATE DATE

ESTIMATE_AS_OF_DATE DATE

ACTUAL_AS_OF_DATE DATE

FINANCIAL_TASK_FLAG VARCHAR2 (4000)
DAYS_TO_ESTIMATE_START NUMBER

DAYS_TO_ESTIMATE_FINISH NUMBER

DAYS_SINCE_ACT_START NUMBER

DAYS_SINCE_ACT_FINISH NUMBER

FINISHED_TASK_FLAG VARCHAR2 (1)
FINISHED_TASK_MEANING VARCHAR2 (4000)
TASK_CREATION_DATE DATE

LOWEST_TASK_MEANING VARCHAR2 (4000)
TASK_TYPE_ID NUMBER (15)
TASK_TYPE VARCHAR2 (150)
TASK_STATUS_CODE VARCHAR2 (150)
TASK_STATUS_MEANING VARCHAR2 (80)
PHASE_CODE VARCHAR2 (150)
PHASE_CODE_MEANING VARCHAR2 (80)
PLANNED_EFFORT NUMBER

WEIGHTING_PERCENTAGE NUMBER

SCHEDULED_DURATION_DAYS NUMBER (15)
BASELINE_DURATION_DAYS NUMBER

ESTIMATED_DURATION_DAYS NUMBER

ACTUAL_DURATION_DAYS NUMBER

ADDRESS_ID NUMBER

ADDRESS1 VARCHAR2 (240)
ADDRESS2 VARCHAR2 (240)
ADDRESS3 VARCHAR2 (240)
ADDRESS4 VARCHAR2 (426)
WQ_ITEM_CODE VARCHAR2 (30)
WQ_ITEM_MEANING VARCHAR2 (4000)
WQ_UOM_CODE VARCHAR2 (30)
WQ_UOM_MEANING VARCHAR2 (4000)
WQ_PLANNED_QUANTITY NUMBER (17)
ACTUAL_WQ_ENTRY_CODE VARCHAR2 (30)
ACTUAL_WQ_ENTRY_MEANING VARCHAR2 (4000)
PROG_ENTRY_ENABLE_FLAG VARCHAR2 (1)
PERCENT_COMP_ENABLE_FLAG VARCHAR2 (1)
REMAIN_EFFORT_ENABLE_FLAG VARCHAR2 (1)
TASK_PROGRESS_ENTRY_PAGE_ID NUMBER (15)
PAGE_NAME VARCHAR2 (80)
BASE_PERCENT_COMP_DERIV_CODE VARCHAR2 (30)
BASE_PERCENT_COMP_DERIV_M VARCHAR2 (4000)
WQ_ENABLE_FLAG VARCHAR2 (1)
PROG_ENTRY_REQ_FLAG VARCHAR2 (1)
ESTIMATED_REMAINING_EFFORT NUMBER

STRUCT_PUBLISHED_FLAG VARCHAR2 (4000)
ACTUAL_WORK_QUANTITY NUMBER (17)
VERSIONING_ENABLED_FLAG VARCHAR2 (4000)
PHASE_VERSION_ID NUMBER (15)
PHASE_NAME VARCHAR2 (240)
SHORT_PHASE_NAME VARCHAR2 (100)
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)
LIFECYCLE_VERSION_ID NUMBER

TASK_UNPUB_VER_STATUS_CODE VARCHAR2 (30)
OPEN_ISSUES NUMBER

OPEN_CHANGE_DOCUMENTS NUMBER

CHILD_ELEMENT_FLAG VARCHAR2 (4000)
DAYS_UNTIL_SCHEDULED_FINISH NUMBER

CURRENT_PHASE_NAME VARCHAR2 (240)
OPEN_CHANGE_REQUESTS NUMBER

OPEN_CHANGE_ORDERS NUMBER

PLANNED_EQUIP_EFFORT NUMBER

RAW_COST NUMBER

BURDENED_COST NUMBER

PLANNED_COST NUMBER

ACTUAL_EFFORT NUMBER

ACTUAL_EQUIP_EFFORT NUMBER

PREDECESSORS VARCHAR2 (4000)
PERCENT_SPENT_EFFORT NUMBER

PERCENT_SPENT_COST NUMBER

PERCENT_COMPLETE_EFFORT NUMBER

PERCENT_COMPLETE_COST NUMBER

ACTUAL_DURATION NUMBER

REMAINING_DURATION NUMBER

CONSTRAINT_TYPE VARCHAR2 (4000)
CONSTRAINT_TYPE_CODE VARCHAR2 (30)
CONSTRAINT_DATE DATE

EARLY_START_DATE DATE

EARLY_FINISH_DATE DATE

LATE_START_DATE DATE

LATE_FINISH_DATE DATE

FREE_SLACK NUMBER (15)
TOTAL_SLACK NUMBER (15)
LOWEST_TASK VARCHAR2 (1)
ESTIMATED_BASELINE_START NUMBER

ESTIMATED_BASELINE_FINISH NUMBER

PLANNED_BASELINE_START NUMBER

PLANNED_BASELINE_FINISH NUMBER

BASELINE_EFFORT NUMBER

ETC_EFFORT NUMBER

ESTIMATE_AT_COMPLETION_EFFORT NUMBER

VARIANCE_AT_COMPLETION_EFFORT NUMBER

EFFORT_VARIANCE NUMBER

EFFORT_VARIANCE_PERCENT NUMBER

ACTUAL_COST NUMBER

BASELINE_COST NUMBER

ESTIMATE_AT_COMPLETION_COST NUMBER

COST_VARIANCE NUMBER

COST_VARIANCE_PERCENT NUMBER

ETC_WORK_QUANTITY NUMBER

PLANNED_COST_PER_UNIT NUMBER

ACTUAL_COST_PER_UNIT NUMBER

WORK_QUANTITY_VARIANCE NUMBER

WORK_QUANTITY_VARIANCE_PERCENT NUMBER

EARNED_VALUE NUMBER

SCHEDULE_VARIANCE NUMBER

EARNED_VALUE_COST_VARIANCE NUMBER

EARNED_VALUE_SCHEDULE_VARIANCE NUMBER

VARIANCE_AT_COMPLETION_COST NUMBER

TO_COMPLETE_PERFORMANCE_INDEX NUMBER

BUDGETED_COST_OF_WORK_SCH NUMBER

SCHEDULE_PERFORMANCE_INDEX NUMBER

COST_PERFORMANCE_INDEX NUMBER

MAPPED_FINANCIAL_TASK NUMBER

DELIVERABLES VARCHAR2 (4000)
ETC_SOURCE_CODE VARCHAR2 (30)
ETC_SOURCE_NAME VARCHAR2 (4000)
WF_ITEM_TYPE VARCHAR2 (30)
WF_PROCESS VARCHAR2 (30)
WF_START_LEAD_DAYS NUMBER (15)
ENABLE_WF_FLAG VARCHAR2 (1)
MAPPED_FIN_TASK_NAME VARCHAR2 (4000)
ETC_COST NUMBER

PROGRESS_ROLLUP_ID NUMBER (15)
EDIT_FLAG VARCHAR2 (1)
CURRENT_WORKING_FLAG VARCHAR2 (1)
CURRENT_FLAG VARCHAR2 (1)
BASE_PERCENT_COMPLETE NUMBER (17)
PLANNED_BASELINE_EFFORT_VAR NUMBER

PLANNED_BASELINE_COST_VAR NUMBER

Query Text

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


SELECT PARENT_PROJECT_ID
,      ELEMENT_NUMBER
,      ELEMENT_NAME
,      DESCRIPTION
,      OBJECT_TYPE
,      ELEMENT_VERSION_ID
,      PROJ_ELEMENT_ID
,      PROJECT_ID
,      DISPLAY_SEQUENCE
,      MILESTONE_FLAG
,      MILESTONE_FLAG_MEANING
,      CRITICAL_FLAG
,      CRITICAL_FLAG_MEANING
,      PARENT_ELEMENT_VERSION_ID
,      PARENT_OBJECT_TYPE
,      RELATIONSHIP_TYPE
,      RELATIONSHIP_SUBTYPE
,      SUMMARY_ELEMENT_FLAG
,      PROGRESS_STATUS_CODE
,      PROGRESS_STATUS_MEANING
,      PROGRESS_COMMENTS
,      PROGRESS_BRIEF_OVERVIEW
,      SCHEDULED_START_DATE
,      SCHEDULED_FINISH_DATE
,      TASK_MANAGER_ID
,      TASK_MANAGER
,      PARENT_STRUCTURE_VERSION_ID
,      WBS_LEVEL
,      WBS_NUMBER
,      ELEM_REC_VER_NUMBER
,      ELEM_VER_REC_VER_NUMBER
,      ELEM_VER_SCH_REC_VER_NUMBER
,      PARENT_VER_REC_VER_NUMBER
,      STATUS_ICON_ACTIVE_IND
,      PERCENT_COMPLETE_ID
,      STATUS_ICON_IND
,      STATUS_CODE
,      STATUS_CODE_MEANING
,      PRIORITY_CODE
,      PRIORITY_DESCRIPTION
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      INCLUDE_IN_PROJ_PROG_RPT
,      ESTIMATED_START_DATE
,      ESTIMATED_FINISH_DATE
,      ACTUAL_START_DATE
,      ACTUAL_FINISH_DATE
,      COMPLETED_PERCENTAGE
,      OBJECT_RELATIONSHIP_ID
,      OBJECT_REC_VER_NUMBER
,      PEV_SCHEDULE_ID
,      LATEST_EFF_PUBLISHED_FLAG
,      PROJECT_NUMBER
,      PROJECT_NAME
,      PARENT_ELEMENT_ID
,      STRUCTURE_TYPE_CLASS_CODE
,      PUBLISHED_DATE
,      LINK_TASK_FLAG
,      DISPLAY_PARENT_VERSION_ID
,      AS_OF_DATE
,      REPORT_VERSION_ID
,      BASELINE_START_DATE
,      BASELINE_FINISH_DATE
,      SCH_BSL_START_VAR
,      SCH_BSL_FINISH_VAR
,      EST_SCH_START_VAR
,      EST_SCH_FINISH_VAR
,      ACT_SCH_START_VAR
,      ACT_SCH_FINISH_VAR
,      PM_SOURCE_NAME
,      PM_SOURCE_CODE
,      PM_SOURCE_REFERENCE
,      ACTIVE_TASK_FLAG
,      ACTIVE_TASK_MEANING
,      DAYS_TO_SCH_START
,      DAYS_TO_SCH_FINISH
,      WORK_TELEPHONE
,      SERVICE_TYPE_MEANING
,      SERVICE_TYPE_CODE
,      WORK_TYPE_NAME
,      WORK_TYPE_ID
,      CHARGEABLE_MEANING
,      CHARGEABLE_FLAG
,      BILLABLE_MEANING
,      BILLABLE_FLAG
,      RECEIVE_PROJECT_INVOICE_M
,      RECEIVE_PROJECT_INVOICE_FLAG
,      TRANSACTION_CTRL_START_DATE
,      TRANSACTION_CTRL_FINISH_DATE
,      PRIOR_PERCENT_COMPLETE
,      SCHEDULE_AS_OF_DATE
,      TRANSACTION_AS_OF_DATE
,      BASELINE_AS_OF_DATE
,      ESTIMATE_AS_OF_DATE
,      ACTUAL_AS_OF_DATE
,      FINANCIAL_TASK_FLAG
,      DAYS_TO_ESTIMATE_START
,      DAYS_TO_ESTIMATE_FINISH
,      DAYS_SINCE_ACT_START
,      DAYS_SINCE_ACT_FINISH
,      FINISHED_TASK_FLAG
,      FINISHED_TASK_MEANING
,      TASK_CREATION_DATE
,      LOWEST_TASK_MEANING
,      TASK_TYPE_ID
,      TASK_TYPE
,      TASK_STATUS_CODE
,      TASK_STATUS_MEANING
,      PHASE_CODE
,      PHASE_CODE_MEANING
,      PLANNED_EFFORT
,      WEIGHTING_PERCENTAGE
,      SCHEDULED_DURATION_DAYS
,      BASELINE_DURATION_DAYS
,      ESTIMATED_DURATION_DAYS
,      ACTUAL_DURATION_DAYS
,      ADDRESS_ID
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      WQ_ITEM_CODE
,      WQ_ITEM_MEANING
,      WQ_UOM_CODE
,      WQ_UOM_MEANING
,      WQ_PLANNED_QUANTITY
,      ACTUAL_WQ_ENTRY_CODE
,      ACTUAL_WQ_ENTRY_MEANING
,      PROG_ENTRY_ENABLE_FLAG
,      PERCENT_COMP_ENABLE_FLAG
,      REMAIN_EFFORT_ENABLE_FLAG
,      TASK_PROGRESS_ENTRY_PAGE_ID
,      PAGE_NAME
,      BASE_PERCENT_COMP_DERIV_CODE
,      BASE_PERCENT_COMP_DERIV_M
,      WQ_ENABLE_FLAG
,      PROG_ENTRY_REQ_FLAG
,      ESTIMATED_REMAINING_EFFORT
,      STRUCT_PUBLISHED_FLAG
,      ACTUAL_WORK_QUANTITY
,      VERSIONING_ENABLED_FLAG
,      PHASE_VERSION_ID
,      PHASE_NAME
,      SHORT_PHASE_NAME
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      LIFECYCLE_VERSION_ID
,      TASK_UNPUB_VER_STATUS_CODE
,      OPEN_ISSUES
,      OPEN_CHANGE_DOCUMENTS
,      CHILD_ELEMENT_FLAG
,      DAYS_UNTIL_SCHEDULED_FINISH
,      CURRENT_PHASE_NAME
,      OPEN_CHANGE_REQUESTS
,      OPEN_CHANGE_ORDERS
,      PLANNED_EQUIP_EFFORT
,      RAW_COST
,      BURDENED_COST
,      PLANNED_COST
,      ACTUAL_EFFORT
,      ACTUAL_EQUIP_EFFORT
,      PREDECESSORS
,      PERCENT_SPENT_EFFORT
,      PERCENT_SPENT_COST
,      PERCENT_COMPLETE_EFFORT
,      PERCENT_COMPLETE_COST
,      ACTUAL_DURATION
,      REMAINING_DURATION
,      CONSTRAINT_TYPE
,      CONSTRAINT_TYPE_CODE
,      CONSTRAINT_DATE
,      EARLY_START_DATE
,      EARLY_FINISH_DATE
,      LATE_START_DATE
,      LATE_FINISH_DATE
,      FREE_SLACK
,      TOTAL_SLACK
,      LOWEST_TASK
,      ESTIMATED_BASELINE_START
,      ESTIMATED_BASELINE_FINISH
,      PLANNED_BASELINE_START
,      PLANNED_BASELINE_FINISH
,      BASELINE_EFFORT
,      ETC_EFFORT
,      ESTIMATE_AT_COMPLETION_EFFORT
,      VARIANCE_AT_COMPLETION_EFFORT
,      EFFORT_VARIANCE
,      EFFORT_VARIANCE_PERCENT
,      ACTUAL_COST
,      BASELINE_COST
,      ESTIMATE_AT_COMPLETION_COST
,      COST_VARIANCE
,      COST_VARIANCE_PERCENT
,      ETC_WORK_QUANTITY
,      PLANNED_COST_PER_UNIT
,      ACTUAL_COST_PER_UNIT
,      WORK_QUANTITY_VARIANCE
,      WORK_QUANTITY_VARIANCE_PERCENT
,      EARNED_VALUE
,      SCHEDULE_VARIANCE
,      EARNED_VALUE_COST_VARIANCE
,      EARNED_VALUE_SCHEDULE_VARIANCE
,      VARIANCE_AT_COMPLETION_COST
,      TO_COMPLETE_PERFORMANCE_INDEX
,      BUDGETED_COST_OF_WORK_SCH
,      SCHEDULE_PERFORMANCE_INDEX
,      COST_PERFORMANCE_INDEX
,      MAPPED_FINANCIAL_TASK
,      DELIVERABLES
,      ETC_SOURCE_CODE
,      ETC_SOURCE_NAME
,      WF_ITEM_TYPE
,      WF_PROCESS
,      WF_START_LEAD_DAYS
,      ENABLE_WF_FLAG
,      MAPPED_FIN_TASK_NAME
,      ETC_COST
,      PROGRESS_ROLLUP_ID
,      EDIT_FLAG
,      CURRENT_WORKING_FLAG
,      CURRENT_FLAG
,      BASE_PERCENT_COMPLETE
,      PLANNED_BASELINE_EFFORT_VAR
,      PLANNED_BASELINE_COST_VAR
FROM PA.PA_STRUCTURES_TASKS_TMP;

Dependencies

[top of page]

PA.PA_STRUCTURES_TASKS_TMP does not reference any database object

PA.PA_STRUCTURES_TASKS_TMP is referenced by following:

SchemaAPPS
SynonymPA_STRUCTURES_TASKS_TMP