[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_STRUCTURES_TASKS_TMP |
|---|---|
| Object Type: | TABLE |
| Owner: | PA |
| FND Design Data: |  PA.PA_STRUCTURES_TASKS_TMP
|
| Subobject Name: | |
| Status: | VALID |
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.
| Tablespace: |  |
|---|---|
| PCT Free: | 10 |
| PCT Used: | 40 |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PA_STRUCTURES_TASKS_TMP_N1 | NORMAL | NONUNIQUE |
|
 PARENT_PROJECT_ID
|
| PA_STRUCTURES_TASKS_TMP_N2 | NORMAL | NONUNIQUE |
|
PROJECT_ID
PROJ_ELEMENT_ID
ELEMENT_VERSION_ID
|
| PA_STRUCTURES_TASKS_TMP_N3 | NORMAL | NONUNIQUE |
|
PARENT_ELEMENT_VERSION_ID
|
| PA_STRUCTURES_TASKS_TMP_N4 | NORMAL | NONUNIQUE |
|
ELEMENT_VERSION_ID
|
| PA_STRUCTURES_TASKS_TMP_N5 | NORMAL | NONUNIQUE |
|
PARENT_STRUCTURE_VERSION_ID
|
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;
PA.PA_STRUCTURES_TASKS_TMP does not reference any database object
PA.PA_STRUCTURES_TASKS_TMP is referenced by following:
APPS
PA_STRUCTURES_TASKS_TMP
|
|
|
|