View: PA_STRUCT_TASKS_AMG_V

Product:	PA - Projects
Description:	This view provides a list of structure versions
Implementation/DBA Data:	APPS.PA_STRUCT_TASKS_AMG_V

View Text

SELECT PEV.ROWID
, PE.PROJ_ELEMENT_ID
, PE.PROJECT_ID
, PE.ELEMENT_NUMBER
, PEV.CREATION_DATE
, PEV.CREATED_BY
, PEV.LAST_UPDATE_DATE
, PEV.LAST_UPDATED_BY
, TASK.LAST_UPDATE_LOGIN
, NVL(PE.NAME
, TASK.TASK_NAME)
, NVL(PE.NAME
, TASK.LONG_TASK_NAME)
, TASK.TOP_TASK_ID
, PEV.WBS_LEVEL
, TASK.READY_TO_BILL_FLAG
, TASK.READY_TO_DISTRIBUTE_FLAG
, NVL(PE.PARENT_STRUCTURE_ID
, TASK.PARENT_TASK_ID)
, NVL(PE.DESCRIPTION
, TASK.DESCRIPTION)
, PE.CARRYING_OUT_ORGANIZATION_ID
, TASK.SERVICE_TYPE_CODE
, NVL(PE.MANAGER_PERSON_ID
, TASK.TASK_MANAGER_PERSON_ID)
, TASK.CHARGEABLE_FLAG
, TASK.BILLABLE_FLAG
, TASK.LIMIT_TO_TXN_CONTROLS_FLAG
, TASK.START_DATE
, TASK.COMPLETION_DATE
, TASK.ADDRESS_ID
, TASK.LABOR_BILL_RATE_ORG_ID
, TASK.LABOR_STD_BILL_RATE_SCHDL
, TASK.LABOR_SCHEDULE_FIXED_DATE
, TASK.LABOR_SCHEDULE_DISCOUNT
, TASK.NON_LABOR_BILL_RATE_ORG_ID
, TASK.NON_LABOR_STD_BILL_RATE_SCHDL
, TASK.NON_LABOR_SCHEDULE_FIXED_DATE
, TASK.NON_LABOR_SCHEDULE_DISCOUNT
, TASK.LABOR_COST_MULTIPLIER_NAME
, NVL(PE.REQUEST_ID
, TASK.REQUEST_ID)
, NVL(PE.PROGRAM_APPLICATION_ID
, TASK.PROGRAM_APPLICATION_ID)
, NVL(PE.PROGRAM_ID
, TASK.PROGRAM_ID)
, NVL(PE.PROGRAM_UPDATE_DATE
, TASK.PROGRAM_UPDATE_DATE)
, NVL(PEV.ATTRIBUTE_CATEGORY
, TASK.ATTRIBUTE_CATEGORY)
, NVL(PEV.ATTRIBUTE1
, TASK.ATTRIBUTE1)
, NVL(PEV.ATTRIBUTE2
, TASK.ATTRIBUTE2)
, NVL(PEV.ATTRIBUTE3
, TASK.ATTRIBUTE3)
, NVL(PEV.ATTRIBUTE4
, TASK.ATTRIBUTE4)
, NVL(PEV.ATTRIBUTE5
, TASK.ATTRIBUTE5)
, NVL(PEV.ATTRIBUTE6
, TASK.ATTRIBUTE6)
, NVL(PEV.ATTRIBUTE7
, TASK.ATTRIBUTE7)
, NVL(PEV.ATTRIBUTE8
, TASK.ATTRIBUTE8)
, NVL(PEV.ATTRIBUTE9
, TASK.ATTRIBUTE9)
, NVL(PEV.ATTRIBUTE10
, TASK.ATTRIBUTE10)
, TASK.COST_IND_RATE_SCH_ID
, TASK.REV_IND_RATE_SCH_ID
, TASK.INV_IND_RATE_SCH_ID
, TASK.COST_IND_SCH_FIXED_DATE
, TASK.REV_IND_SCH_FIXED_DATE
, TASK.INV_IND_SCH_FIXED_DATE
, TASK.LABOR_SCH_TYPE
, TASK.NON_LABOR_SCH_TYPE
, NVL(PE.PM_SOURCE_REFERENCE
, TASK.PM_TASK_REFERENCE)
, NVL(PE.PM_SOURCE_CODE
, TASK.PM_PRODUCT_CODE)
, DECODE(PA_TASK_UTILS.CHECK_CHILD_EXISTS(TASK.TASK_ID)
, 1
, '+'
, 0
, ' ')
, NVL(PES.ACTUAL_START_DATE
, TASK.ACTUAL_START_DATE)
, NVL(PES.ACTUAL_FINISH_DATE
, TASK.ACTUAL_FINISH_DATE)
, NVL(PES.EARLY_START_DATE
, TASK.EARLY_START_DATE)
, NVL(PES.EARLY_FINISH_DATE
, TASK.EARLY_FINISH_DATE)
, NVL(PES.LATE_START_DATE
, TASK.LATE_START_DATE)
, NVL(PES.LATE_FINISH_DATE
, TASK.LATE_FINISH_DATE)
, NVL(PES.SCHEDULED_START_DATE
, TASK.SCHEDULED_START_DATE)
, NVL(PES.SCHEDULED_FINISH_DATE
, TASK.SCHEDULED_FINISH_DATE)
, PE.PRIORITY_CODE
, PEV.DISPLAY_SEQUENCE
, PEV.WBS_NUMBER
, PE.WQ_ITEM_CODE
, PE.WQ_UOM_CODE
, PE.WQ_ACTUAL_ENTRY_CODE
, PES.WQ_PLANNED_QUANTITY
, PE.TYPE_ID
, PES.MILESTONE_FLAG
, PES.CRITICAL_FLAG
, PE.STATUS_CODE
, PEV.ELEMENT_VERSION_ID
, PEV.PARENT_STRUCTURE_VERSION_ID
, TASK.WORK_TYPE_ID
, (NVL(PXPV.LABOR_EFFORT
, 0)+NVL(PXPV.EQUIPMENT_EFFORT
, 0))
, PAPF.FULL_NAME
, TT.TASK_TYPE
, PWT.NAME
, PA_PROJ_TASK_STRUC_PUB.PARSE_PREDECESSOR_EXPORT(PEV.ELEMENT_VERSION_ID
, '
, ') DEPENDENCIES
, PA_PROJ_ELEMENTS_UTILS.CONVERT_HR_TO_DAYS(PES.DURATION)
, PES.CONSTRAINT_DATE
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ( 'PA_SCHEDULE_CONSTRAINT_TYPE'
, PES.CONSTRAINT_TYPE_CODE ) CONSTRAINT_TYPE
, PES.CONSTRAINT_TYPE_CODE
, PES.FREE_SLACK
, PES.TOTAL_SLACK
, PA_PROJ_TASK_STRUC_PUB.PARSE_PREDECESSOR_EXPORT2(PEV.ELEMENT_VERSION_ID
, '
, ') PREDECESSORS
, PES.LEVEL_ASSIGNMENTS_FLAG
, PES.EFFORT_DRIVEN_FLAG
, PEV.FINANCIAL_TASK_FLAG
, PES.DEF_SCH_TOOL_TSK_TYPE_CODE
, PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID_AMG(PEV.ELEMENT_VERSION_ID
, PE.PROJECT_ID)
, PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME_AMG(PEV.ELEMENT_VERSION_ID
, PE.PROJECT_ID)
, NULL
, NULL
, STYPE.STRUCTURE_TYPE
, EXT_SCH_DURATION
, EXT_ACT_DURATION
, EXT_REMAIN_DURATION
, PEV.TASK_UNPUB_VER_STATUS_CODE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM PA_TASKS TASK
, PA_PROJ_ELEMENTS PE
, PA_PROJ_STRUCTURE_TYPES TYP
, PA_STRUCTURE_TYPES STYPE
, PA_PROJ_ELEMENT_VERSIONS PEV
, PA_PROJ_ELEM_VER_SCHEDULE PES
, PA_TASK_TYPES TT
, PA_WORK_TYPES_VL PWT
, PER_ALL_PEOPLE_F PAPF
, PJI_XBS_PLANS_PRJ_V PXPV
WHERE PE.PROJ_ELEMENT_ID = TASK.TASK_ID(+)
AND PE.OBJECT_TYPE = 'PA_TASKS'
AND PE.PROJ_ELEMENT_ID = PEV.PROJ_ELEMENT_ID
AND PE.LINK_TASK_FLAG = 'N'
AND PEV.ELEMENT_VERSION_ID = PES.ELEMENT_VERSION_ID(+)
AND PEV.PROJECT_ID = PES.PROJECT_ID (+)
AND PEV.PROJ_ELEMENT_ID = PES.PROJ_ELEMENT_ID (+)
AND PE.PROJECT_ID = PEV.PROJECT_ID
AND TASK.WORK_TYPE_ID = PWT.WORK_TYPE_ID(+)
AND PE.TYPE_ID = TT.TASK_TYPE_ID
AND TT.OBJECT_TYPE = 'PA_TASKS'
AND PE.MANAGER_PERSON_ID = PAPF.PERSON_ID(+)
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE(+)
AND PAPF.EFFECTIVE_END_DATE (+)
AND PEV.PROJECT_ID = PXPV.PROJECT_ID(+)
AND PEV.PROJ_ELEMENT_ID = PXPV.PROJ_ELEMENT_ID(+)
AND PEV.PARENT_STRUCTURE_VERSION_ID = PXPV.STRUCTURE_VERSION_ID(+)
AND STYPE.STRUCTURE_TYPE_ID = TYP.STRUCTURE_TYPE_ID
AND PE.PARENT_STRUCTURE_ID = TYP.PROJ_ELEMENT_ID
AND ( STYPE.STRUCTURE_TYPE = 'WORKPLAN'
AND (PXPV.STRUCTURE_TYPE(+) = 'WORKPLAN')
AND NOT EXISTS ( SELECT /*+ INDEX(PPR2
, PA_PROGRESS_ROLLUP_U2) */ 1
FROM PA_PROGRESS_ROLLUP PPR2
WHERE PPR2.PROJECT_ID = PEV.PROJECT_ID
AND PPR2.PROJ_ELEMENT_ID = PEV.PROJ_ELEMENT_ID
AND PPR2.OBJECT_VERSION_ID = PEV.ELEMENT_VERSION_ID
AND PPR2.OBJECT_ID = PEV.PROJ_ELEMENT_ID
AND PPR2.STRUCTURE_TYPE ='WORKPLAN'
AND PPR2.OBJECT_TYPE = 'PA_TASKS'
AND PPR2.STRUCTURE_VERSION_ID = PEV.PARENT_STRUCTURE_VERSION_ID ) ) UNION ALL SELECT PEV.ROWID
, PE.PROJ_ELEMENT_ID
, PE.PROJECT_ID
, PE.ELEMENT_NUMBER
, PEV.CREATION_DATE
, PEV.CREATED_BY
, PEV.LAST_UPDATE_DATE
, PEV.LAST_UPDATED_BY
, TASK.LAST_UPDATE_LOGIN
, NVL(PE.NAME
, TASK.TASK_NAME)
, NVL(PE.NAME
, TASK.LONG_TASK_NAME)
, TASK.TOP_TASK_ID
, PEV.WBS_LEVEL
, TASK.READY_TO_BILL_FLAG
, TASK.READY_TO_DISTRIBUTE_FLAG
, NVL(PE.PARENT_STRUCTURE_ID
, TASK.PARENT_TASK_ID)
, NVL(PE.DESCRIPTION
, TASK.DESCRIPTION)
, PE.CARRYING_OUT_ORGANIZATION_ID
, TASK.SERVICE_TYPE_CODE
, NVL(PE.MANAGER_PERSON_ID
, TASK.TASK_MANAGER_PERSON_ID)
, TASK.CHARGEABLE_FLAG
, TASK.BILLABLE_FLAG
, TASK.LIMIT_TO_TXN_CONTROLS_FLAG
, TASK.START_DATE
, TASK.COMPLETION_DATE
, TASK.ADDRESS_ID
, TASK.LABOR_BILL_RATE_ORG_ID
, TASK.LABOR_STD_BILL_RATE_SCHDL
, TASK.LABOR_SCHEDULE_FIXED_DATE
, TASK.LABOR_SCHEDULE_DISCOUNT
, TASK.NON_LABOR_BILL_RATE_ORG_ID
, TASK.NON_LABOR_STD_BILL_RATE_SCHDL
, TASK.NON_LABOR_SCHEDULE_FIXED_DATE
, TASK.NON_LABOR_SCHEDULE_DISCOUNT
, TASK.LABOR_COST_MULTIPLIER_NAME
, NVL(PE.REQUEST_ID
, TASK.REQUEST_ID)
, NVL(PE.PROGRAM_APPLICATION_ID
, TASK.PROGRAM_APPLICATION_ID)
, NVL(PE.PROGRAM_ID
, TASK.PROGRAM_ID)
, NVL(PE.PROGRAM_UPDATE_DATE
, TASK.PROGRAM_UPDATE_DATE)
, NVL(PEV.ATTRIBUTE_CATEGORY
, TASK.ATTRIBUTE_CATEGORY)
, NVL(PEV.ATTRIBUTE1
, TASK.ATTRIBUTE1)
, NVL(PEV.ATTRIBUTE2
, TASK.ATTRIBUTE2)
, NVL(PEV.ATTRIBUTE3
, TASK.ATTRIBUTE3)
, NVL(PEV.ATTRIBUTE4
, TASK.ATTRIBUTE4)
, NVL(PEV.ATTRIBUTE5
, TASK.ATTRIBUTE5)
, NVL(PEV.ATTRIBUTE6
, TASK.ATTRIBUTE6)
, NVL(PEV.ATTRIBUTE7
, TASK.ATTRIBUTE7)
, NVL(PEV.ATTRIBUTE8
, TASK.ATTRIBUTE8)
, NVL(PEV.ATTRIBUTE9
, TASK.ATTRIBUTE9)
, NVL(PEV.ATTRIBUTE10
, TASK.ATTRIBUTE10)
, TASK.COST_IND_RATE_SCH_ID
, TASK.REV_IND_RATE_SCH_ID
, TASK.INV_IND_RATE_SCH_ID
, TASK.COST_IND_SCH_FIXED_DATE
, TASK.REV_IND_SCH_FIXED_DATE
, TASK.INV_IND_SCH_FIXED_DATE
, TASK.LABOR_SCH_TYPE
, TASK.NON_LABOR_SCH_TYPE
, NVL(PE.PM_SOURCE_REFERENCE
, TASK.PM_TASK_REFERENCE)
, NVL(PE.PM_SOURCE_CODE
, TASK.PM_PRODUCT_CODE)
, DECODE(PA_TASK_UTILS.CHECK_CHILD_EXISTS(TASK.TASK_ID)
, 1
, '+'
, 0
, ' ')
, NVL(PES.ACTUAL_START_DATE
, TASK.ACTUAL_START_DATE)
, NVL(PES.ACTUAL_FINISH_DATE
, TASK.ACTUAL_FINISH_DATE)
, NVL(PES.EARLY_START_DATE
, TASK.EARLY_START_DATE)
, NVL(PES.EARLY_FINISH_DATE
, TASK.EARLY_FINISH_DATE)
, NVL(PES.LATE_START_DATE
, TASK.LATE_START_DATE)
, NVL(PES.LATE_FINISH_DATE
, TASK.LATE_FINISH_DATE)
, NVL(PES.SCHEDULED_START_DATE
, TASK.SCHEDULED_START_DATE)
, NVL(PES.SCHEDULED_FINISH_DATE
, TASK.SCHEDULED_FINISH_DATE)
, PE.PRIORITY_CODE
, PEV.DISPLAY_SEQUENCE
, PEV.WBS_NUMBER
, PE.WQ_ITEM_CODE
, PE.WQ_UOM_CODE
, PE.WQ_ACTUAL_ENTRY_CODE
, PES.WQ_PLANNED_QUANTITY
, PE.TYPE_ID
, PES.MILESTONE_FLAG
, PES.CRITICAL_FLAG
, PE.STATUS_CODE
, PEV.ELEMENT_VERSION_ID
, PEV.PARENT_STRUCTURE_VERSION_ID
, TASK.WORK_TYPE_ID
, NULL
, PAPF.FULL_NAME
, TT.TASK_TYPE
, PWT.NAME
, PA_PROJ_TASK_STRUC_PUB.PARSE_PREDECESSOR_EXPORT(PEV.ELEMENT_VERSION_ID
, '
, ') DEPENDENCIES
, PA_PROJ_ELEMENTS_UTILS.CONVERT_HR_TO_DAYS(PES.DURATION)
, PES.CONSTRAINT_DATE
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ( 'PA_SCHEDULE_CONSTRAINT_TYPE'
, PES.CONSTRAINT_TYPE_CODE ) CONSTRAINT_TYPE
, PES.CONSTRAINT_TYPE_CODE
, PES.FREE_SLACK
, PES.TOTAL_SLACK
, PA_PROJ_TASK_STRUC_PUB.PARSE_PREDECESSOR_EXPORT2(PEV.ELEMENT_VERSION_ID
, '
, ') PREDECESSORS
, PES.LEVEL_ASSIGNMENTS_FLAG
, PES.EFFORT_DRIVEN_FLAG
, PEV.FINANCIAL_TASK_FLAG
, PES.DEF_SCH_TOOL_TSK_TYPE_CODE
, NULL
, NULL
, PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_WKP_TASK_IDS(PEV.ELEMENT_VERSION_ID
, PE.PROJECT_ID)
, PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_WKP_TASK_NAMES(PEV.ELEMENT_VERSION_ID
, PE.PROJECT_ID)
, STYPE.STRUCTURE_TYPE
, EXT_SCH_DURATION
, EXT_ACT_DURATION
, EXT_REMAIN_DURATION
, PEV.TASK_UNPUB_VER_STATUS_CODE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM PA_TASKS TASK
, PA_PROJ_ELEMENTS PE
, PA_PROJ_STRUCTURE_TYPES TYP
, PA_STRUCTURE_TYPES STYPE
, PA_PROJ_ELEMENT_VERSIONS PEV
, PA_PROJ_ELEM_VER_SCHEDULE PES
, PA_TASK_TYPES TT
, PA_WORK_TYPES_VL PWT
, PER_ALL_PEOPLE_F PAPF
WHERE PE.PROJ_ELEMENT_ID = TASK.TASK_ID(+)
AND PE.OBJECT_TYPE = 'PA_TASKS'
AND PE.PROJ_ELEMENT_ID = PEV.PROJ_ELEMENT_ID
AND PE.LINK_TASK_FLAG = 'N'
AND PEV.ELEMENT_VERSION_ID = PES.ELEMENT_VERSION_ID(+)
AND PEV.PROJECT_ID = PES.PROJECT_ID (+)
AND PEV.PROJ_ELEMENT_ID = PES.PROJ_ELEMENT_ID (+)
AND PE.PROJECT_ID = PEV.PROJECT_ID
AND TASK.WORK_TYPE_ID = PWT.WORK_TYPE_ID(+)
AND PE.TYPE_ID = TT.TASK_TYPE_ID
AND TT.OBJECT_TYPE = 'PA_TASKS'
AND PE.MANAGER_PERSON_ID = PAPF.PERSON_ID(+)
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE(+)
AND PAPF.EFFECTIVE_END_DATE (+)
AND STYPE.STRUCTURE_TYPE_ID = TYP.STRUCTURE_TYPE_ID
AND PE.PARENT_STRUCTURE_ID = TYP.PROJ_ELEMENT_ID
AND STYPE.STRUCTURE_TYPE = 'FINANCIAL' UNION ALL SELECT PEV.ROWID
, PE.PROJ_ELEMENT_ID
, PE.PROJECT_ID
, PE.ELEMENT_NUMBER
, PEV.CREATION_DATE
, PEV.CREATED_BY
, PEV.LAST_UPDATE_DATE
, PEV.LAST_UPDATED_BY
, TASK.LAST_UPDATE_LOGIN
, NVL(PE.NAME
, TASK.TASK_NAME)
, NVL(PE.NAME
, TASK.LONG_TASK_NAME)
, TASK.TOP_TASK_ID
, PEV.WBS_LEVEL
, TASK.READY_TO_BILL_FLAG
, TASK.READY_TO_DISTRIBUTE_FLAG
, NVL(PE.PARENT_STRUCTURE_ID
, TASK.PARENT_TASK_ID)
, NVL(PE.DESCRIPTION
, TASK.DESCRIPTION)
, PE.CARRYING_OUT_ORGANIZATION_ID
, TASK.SERVICE_TYPE_CODE
, NVL(PE.MANAGER_PERSON_ID
, TASK.TASK_MANAGER_PERSON_ID)
, TASK.CHARGEABLE_FLAG
, TASK.BILLABLE_FLAG
, TASK.LIMIT_TO_TXN_CONTROLS_FLAG
, TASK.START_DATE
, TASK.COMPLETION_DATE
, TASK.ADDRESS_ID
, TASK.LABOR_BILL_RATE_ORG_ID
, TASK.LABOR_STD_BILL_RATE_SCHDL
, TASK.LABOR_SCHEDULE_FIXED_DATE
, TASK.LABOR_SCHEDULE_DISCOUNT
, TASK.NON_LABOR_BILL_RATE_ORG_ID
, TASK.NON_LABOR_STD_BILL_RATE_SCHDL
, TASK.NON_LABOR_SCHEDULE_FIXED_DATE
, TASK.NON_LABOR_SCHEDULE_DISCOUNT
, TASK.LABOR_COST_MULTIPLIER_NAME
, NVL(PE.REQUEST_ID
, TASK.REQUEST_ID)
, NVL(PE.PROGRAM_APPLICATION_ID
, TASK.PROGRAM_APPLICATION_ID)
, NVL(PE.PROGRAM_ID
, TASK.PROGRAM_ID)
, NVL(PE.PROGRAM_UPDATE_DATE
, TASK.PROGRAM_UPDATE_DATE)
, NVL(PEV.ATTRIBUTE_CATEGORY
, TASK.ATTRIBUTE_CATEGORY)
, NVL(PEV.ATTRIBUTE1
, TASK.ATTRIBUTE1)
, NVL(PEV.ATTRIBUTE2
, TASK.ATTRIBUTE2)
, NVL(PEV.ATTRIBUTE3
, TASK.ATTRIBUTE3)
, NVL(PEV.ATTRIBUTE4
, TASK.ATTRIBUTE4)
, NVL(PEV.ATTRIBUTE5
, TASK.ATTRIBUTE5)
, NVL(PEV.ATTRIBUTE6
, TASK.ATTRIBUTE6)
, NVL(PEV.ATTRIBUTE7
, TASK.ATTRIBUTE7)
, NVL(PEV.ATTRIBUTE8
, TASK.ATTRIBUTE8)
, NVL(PEV.ATTRIBUTE9
, TASK.ATTRIBUTE9)
, NVL(PEV.ATTRIBUTE10
, TASK.ATTRIBUTE10)
, TASK.COST_IND_RATE_SCH_ID
, TASK.REV_IND_RATE_SCH_ID
, TASK.INV_IND_RATE_SCH_ID
, TASK.COST_IND_SCH_FIXED_DATE
, TASK.REV_IND_SCH_FIXED_DATE
, TASK.INV_IND_SCH_FIXED_DATE
, TASK.LABOR_SCH_TYPE
, TASK.NON_LABOR_SCH_TYPE
, NVL(PE.PM_SOURCE_REFERENCE
, TASK.PM_TASK_REFERENCE)
, NVL(PE.PM_SOURCE_CODE
, TASK.PM_PRODUCT_CODE)
, DECODE(PA_TASK_UTILS.CHECK_CHILD_EXISTS(TASK.TASK_ID)
, 1
, '+'
, 0
, ' ')
, NVL(PES.ACTUAL_START_DATE
, TASK.ACTUAL_START_DATE)
, NVL(PES.ACTUAL_FINISH_DATE
, TASK.ACTUAL_FINISH_DATE)
, NVL(PES.EARLY_START_DATE
, TASK.EARLY_START_DATE)
, NVL(PES.EARLY_FINISH_DATE
, TASK.EARLY_FINISH_DATE)
, NVL(PES.LATE_START_DATE
, TASK.LATE_START_DATE)
, NVL(PES.LATE_FINISH_DATE
, TASK.LATE_FINISH_DATE)
, NVL(PES.SCHEDULED_START_DATE
, TASK.SCHEDULED_START_DATE)
, NVL(PES.SCHEDULED_FINISH_DATE
, TASK.SCHEDULED_FINISH_DATE)
, PE.PRIORITY_CODE
, PEV.DISPLAY_SEQUENCE
, PEV.WBS_NUMBER
, PE.WQ_ITEM_CODE
, PE.WQ_UOM_CODE
, PE.WQ_ACTUAL_ENTRY_CODE
, PES.WQ_PLANNED_QUANTITY
, PE.TYPE_ID
, PES.MILESTONE_FLAG
, PES.CRITICAL_FLAG
, PE.STATUS_CODE
, PEV.ELEMENT_VERSION_ID
, PEV.PARENT_STRUCTURE_VERSION_ID
, TASK.WORK_TYPE_ID
, (NVL(PXPV.LABOR_EFFORT
, 0)+NVL(PXPV.EQUIPMENT_EFFORT
, 0))
, PAPF.FULL_NAME
, TT.TASK_TYPE
, PWT.NAME
, PA_PROJ_TASK_STRUC_PUB.PARSE_PREDECESSOR_EXPORT(PEV.ELEMENT_VERSION_ID
, '
, ') DEPENDENCIES
, PA_PROJ_ELEMENTS_UTILS.CONVERT_HR_TO_DAYS(PES.DURATION)
, PES.CONSTRAINT_DATE
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ( 'PA_SCHEDULE_CONSTRAINT_TYPE'
, PES.CONSTRAINT_TYPE_CODE ) CONSTRAINT_TYPE
, PES.CONSTRAINT_TYPE_CODE
, PES.FREE_SLACK
, PES.TOTAL_SLACK
, PA_PROJ_TASK_STRUC_PUB.PARSE_PREDECESSOR_EXPORT2(PEV.ELEMENT_VERSION_ID
, '
, ') PREDECESSORS
, PES.LEVEL_ASSIGNMENTS_FLAG
, PES.EFFORT_DRIVEN_FLAG
, PEV.FINANCIAL_TASK_FLAG
, PES.DEF_SCH_TOOL_TSK_TYPE_CODE
, PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID_AMG(PEV.ELEMENT_VERSION_ID
, PE.PROJECT_ID)
, PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME_AMG(PEV.ELEMENT_VERSION_ID
, PE.PROJECT_ID)
, NULL
, NULL
, NVL( PXPV.STRUCTURE_TYPE
, STYPE.STRUCTURE_TYPE )
, EXT_SCH_DURATION
, EXT_ACT_DURATION
, EXT_REMAIN_DURATION
, PEV.TASK_UNPUB_VER_STATUS_CODE
, NVL (PPR.COMPLETED_PERCENTAGE
, NVL(PPR.BASE_PERCENT_COMPLETE
, PPR.EFF_ROLLUP_PERCENT_COMP)) PERCENT_COMPLETE
, PXPV.ETC_LABOR_HRS ETC_EFFORT
FROM PA_TASKS TASK
, PA_PROJ_ELEMENTS PE
, PA_PROJ_STRUCTURE_TYPES TYP
, PA_STRUCTURE_TYPES STYPE
, PA_PROJ_ELEMENT_VERSIONS PEV
, PA_PROJ_ELEM_VER_SCHEDULE PES
, PA_TASK_TYPES TT
, PA_WORK_TYPES_VL PWT
, PER_ALL_PEOPLE_F PAPF
, PJI_XBS_PLANS_PRJ_V PXPV
, PA_PROGRESS_ROLLUP PPR
WHERE PE.PROJ_ELEMENT_ID = TASK.TASK_ID(+)
AND PE.OBJECT_TYPE = 'PA_TASKS'
AND PE.PROJ_ELEMENT_ID = PEV.PROJ_ELEMENT_ID
AND PE.LINK_TASK_FLAG = 'N'
AND PEV.ELEMENT_VERSION_ID = PES.ELEMENT_VERSION_ID(+)
AND PEV.PROJECT_ID = PES.PROJECT_ID (+)
AND PEV.PROJ_ELEMENT_ID = PES.PROJ_ELEMENT_ID (+)
AND PE.PROJECT_ID = PEV.PROJECT_ID
AND TASK.WORK_TYPE_ID = PWT.WORK_TYPE_ID(+)
AND PE.TYPE_ID = TT.TASK_TYPE_ID
AND TT.OBJECT_TYPE = 'PA_TASKS'
AND PE.MANAGER_PERSON_ID = PAPF.PERSON_ID(+)
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE(+)
AND PAPF.EFFECTIVE_END_DATE (+)
AND PEV.PROJECT_ID = PXPV.PROJECT_ID(+)
AND PEV.PROJ_ELEMENT_ID = PXPV.PROJ_ELEMENT_ID(+)
AND PEV.PARENT_STRUCTURE_VERSION_ID = PXPV.STRUCTURE_VERSION_ID(+)
AND STYPE.STRUCTURE_TYPE = 'WORKPLAN'
AND PXPV.STRUCTURE_TYPE(+)= 'WORKPLAN'
AND STYPE.STRUCTURE_TYPE_ID = TYP.STRUCTURE_TYPE_ID
AND PE.PARENT_STRUCTURE_ID = TYP.PROJ_ELEMENT_ID
AND PPR.OBJECT_ID = PEV.PROJ_ELEMENT_ID
AND PPR.PROJ_ELEMENT_ID = PEV.PROJ_ELEMENT_ID
AND PPR.OBJECT_TYPE = 'PA_TASKS'
AND PPR.PROJECT_ID = PEV.PROJECT_ID
AND PPR.STRUCTURE_TYPE = 'WORKPLAN'
AND PPR.STRUCTURE_VERSION_ID = PEV.PARENT_STRUCTURE_VERSION_ID

Columns