[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 |
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 |
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:
|
|
|