View: PA_STRUCT_TASK_EDIT_V

View Text

SELECT DECODE( PPE.OBJECT_TYPE
, 'PA_TASKS'
, PPE.ELEMENT_NUMBER
, 'PA_STRUCTURES'
, TO_CHAR( PPVS.VERSION_NUMBER ) )
, DECODE( PPE.OBJECT_TYPE
, 'PA_TASKS'
, PPE.NAME
, 'PA_STRUCTURES'
, PPVS.NAME )
, PPE.DESCRIPTION
, PPE.OBJECT_TYPE
, PPV.ELEMENT_VERSION_ID
, PPE.PROJ_ELEMENT_ID
, PPE.PROJECT_ID
, PPV.DISPLAY_SEQUENCE
, PPVSCH.MILESTONE_FLAG
, FL1.MEANING
, PPVSCH.CRITICAL_FLAG
, FL2.MEANING
, POR.OBJECT_ID_FROM1
, POR.OBJECT_TYPE_FROM
, POR.RELATIONSHIP_TYPE
, POR.RELATIONSHIP_SUBTYPE
, DECODE( PPE.OBJECT_TYPE
, 'PA_STRUCTURES'
, 'Y'
, 'PA_TASKS'
, PA_PROJ_ELEMENTS_UTILS.IS_SUMMARY_TASK_OR_STRUCTURE( PPV.ELEMENT_VERSION_ID ) )
, PPVSCH.SCHEDULED_START_DATE
, PPVSCH.SCHEDULED_FINISH_DATE
, PPE.MANAGER_PERSON_ID
, PAPF.FULL_NAME
, PPV.PARENT_STRUCTURE_VERSION_ID
, PPV.WBS_LEVEL
, PPV.WBS_NUMBER
, PPE.RECORD_VERSION_NUMBER
, PPV.RECORD_VERSION_NUMBER
, PPVSCH.RECORD_VERSION_NUMBER
, PPV2.RECORD_VERSION_NUMBER
, PPE.STATUS_CODE
, PPS2.PROJECT_STATUS_NAME
, PPE.PRIORITY_CODE
, FL3.MEANING
, PPE.CARRYING_OUT_ORGANIZATION_ID
, HOU.NAME
, PPE.INC_PROJ_PROGRESS_FLAG
, POR.OBJECT_RELATIONSHIP_ID
, POR.RECORD_VERSION_NUMBER
, PPVSCH.PEV_SCHEDULE_ID
, PPVS.LATEST_EFF_PUBLISHED_FLAG
, PPA.SEGMENT1
, PPA.NAME
, PPV2.PROJ_ELEMENT_ID
, PST.STRUCTURE_TYPE_CLASS_CODE
, PPVS.PUBLISHED_DATE
, PPE.LINK_TASK_FLAG
, POR.OBJECT_ID_FROM1
, PA_PROJ_ELEMENTS_UTILS.CHECK_EDIT_TASK_OK(PPE.PROJECT_ID
, PPV.PARENT_STRUCTURE_VERSION_ID
, PA_PROJ_ELEMENTS_UTILS.GETGLOBALSTRUCVERID)
, PAPF.WORK_TELEPHONE
, LU1.MEANING
, PT.SERVICE_TYPE_CODE
, PWT.NAME
, PT.WORK_TYPE_ID
, FL4.MEANING
, PT.CHARGEABLE_FLAG
, FL5.MEANING
, PT.BILLABLE_FLAG
, FL6.MEANING
, PT.RECEIVE_PROJECT_INVOICE_FLAG
, PPVSCH.ESTIMATED_START_DATE
, PPVSCH.ESTIMATED_FINISH_DATE
, PPVSCH.ACTUAL_START_DATE
, PPVSCH.ACTUAL_FINISH_DATE
, PPE.BASELINE_START_DATE
, PPE.BASELINE_FINISH_DATE
, PT.START_DATE
, PT.COMPLETION_DATE
, PPVSCH.SCHEDULED_START_DATE - PPE.BASELINE_START_DATE
, PPVSCH.SCHEDULED_FINISH_DATE - PPE.BASELINE_FINISH_DATE
, PPVSCH.ESTIMATED_START_DATE - PPVSCH.SCHEDULED_START_DATE
, PPVSCH.ESTIMATED_FINISH_DATE - PPVSCH.SCHEDULED_FINISH_DATE
, PPVSCH.ACTUAL_START_DATE - PPVSCH.SCHEDULED_START_DATE
, PPVSCH.ACTUAL_FINISH_DATE - PPVSCH.SCHEDULED_FINISH_DATE
, PPC.DATE_COMPUTED
, PPC.PROGRESS_STATUS_CODE
, PPS.PROJECT_STATUS_NAME
, PPC.PROGRESS_COMMENT
, PPC.DESCRIPTION
, PPC.COMPLETED_PERCENTAGE
, TO_NUMBER(NULL)
, PPS.STATUS_ICON_ACTIVE_IND
, PPS.STATUS_ICON_IND
, PPC.PERCENT_COMPLETE_ID
, PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(PPE.PROJ_ELEMENT_ID)
, PPVSCH.PLANNED_EFFORT
, PPRU.ESTIMATED_REMAINING_EFFORT
, PPE.WQ_ITEM_CODE
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS'
, PPE.WQ_ITEM_CODE)
, PPE.WQ_UOM_CODE
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT'
, PPE.WQ_UOM_CODE)
, PPVSCH.WQ_PLANNED_QUANTITY
, PPRU.CUMULATIVE_WORK_QUANTITY
, POR.WEIGHTING_PERCENTAGE
, PPE.TYPE_ID
, PPE.PHASE_VERSION_ID
, PPE.PHASE_CODE
, PPS5.PROJECT_STATUS_NAME
, TT.PROG_ENTRY_ENABLE_FLAG
, TT.WQ_ENABLE_FLAG
, TT.PROG_ENTRY_REQ_FLAG
, TT.PERCENT_COMP_ENABLE_FLAG
, TT.REMAIN_EFFORT_ENABLE_FLAG
, PPV.TASK_UNPUB_VER_STATUS_CODE
, PA_CONTROL_ITEMS_UTILS.GET_OPEN_CONTROL_ITEMS(PPE.PROJECT_ID
, PPE.OBJECT_TYPE
, PPE.PROJ_ELEMENT_ID
, 'ISSUE')
, TO_NUMBER(NULL)
, PA_PROJ_ELEMENTS_UTILS.CHECK_CHILD_ELEMENT_EXIST(PPV.ELEMENT_VERSION_ID)
, PA_CONTROL_ITEMS_UTILS.GET_OPEN_CONTROL_ITEMS(PPE.PROJECT_ID
, PPE.OBJECT_TYPE
, PPE.PROJ_ELEMENT_ID
, 'CHANGE_REQUEST')
, PA_CONTROL_ITEMS_UTILS.GET_OPEN_CONTROL_ITEMS(PPE.PROJECT_ID
, PPE.OBJECT_TYPE
, PPE.PROJ_ELEMENT_ID
, 'CHANGE_ORDER')
FROM PA_PROJ_ELEM_VER_STRUCTURE PPVS
, PA_PROJ_ELEM_VER_SCHEDULE PPVSCH
, PA_PROJ_ELEMENTS PPE5
, PA_PROJ_ELEMENT_VERSIONS PPV5
, PER_ALL_PEOPLE_F PAPF
, PA_PROJECT_STATUSES PPS2
, PA_LOOKUPS FL3
, HR_ALL_ORGANIZATION_UNITS_TL HOU
, PA_PROJECTS_ALL PPA
, PA_PROJ_ELEMENT_VERSIONS PPV2
, PA_PROJ_STRUCTURE_TYPES PPST
, PA_STRUCTURE_TYPES PST
, FND_LOOKUPS FL1
, FND_LOOKUPS FL2
, FND_LOOKUPS FL4
, FND_LOOKUPS FL5
, FND_LOOKUPS FL6
, PA_LOOKUPS LU1
, PA_WORK_TYPES_TL PWT
, PA_PROGRESS_ROLLUP PPRU
, PA_PROJECT_STATUSES PPS
, PA_PERCENT_COMPLETES PPC
, PA_PROJECT_STATUSES PPS5
, PA_TASK_TYPES TT
, PA_TASKS PT
, PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPV
, PA_OBJECT_RELATIONSHIPS POR
WHERE PPE.PROJ_ELEMENT_ID = PPV.PROJ_ELEMENT_ID
AND PPE.PROJECT_ID = PPV.PROJECT_ID
AND PPV.ELEMENT_VERSION_ID = PPVS.ELEMENT_VERSION_ID (+)
AND PPV.PROJECT_ID = PPVS.PROJECT_ID (+)
AND PPV.ELEMENT_VERSION_ID = PPVSCH.ELEMENT_VERSION_ID (+)
AND PPV.PROJECT_ID = PPVSCH.PROJECT_ID (+)
AND PPV.ELEMENT_VERSION_ID = POR.OBJECT_ID_TO1
AND POR.OBJECT_TYPE_TO IN ('PA_STRUCTURES'
, 'PA_TASKS')
AND PPE.MANAGER_PERSON_ID = PAPF.PERSON_ID(+)
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE(+)
AND PAPF.EFFECTIVE_END_DATE (+)
AND PPE.STATUS_CODE = PPS2.PROJECT_STATUS_CODE(+)
AND PPE.PRIORITY_CODE = FL3.LOOKUP_CODE(+)
AND FL3.LOOKUP_TYPE(+) = 'PA_TASK_PRIORITY_CODE'
AND PPE.CARRYING_OUT_ORGANIZATION_ID = HOU.ORGANIZATION_ID (+)
AND USERENV('LANG') = HOU.LANGUAGE (+)
AND PPE.PROJECT_ID = PPA.PROJECT_ID
AND POR.OBJECT_TYPE_FROM IN ('PA_STRUCTURES'
, 'PA_TASKS')
AND POR.OBJECT_ID_FROM1 = PPV2.ELEMENT_VERSION_ID(+)
AND PPE.PROJ_ELEMENT_ID = PPST.PROJ_ELEMENT_ID(+)
AND PST.STRUCTURE_TYPE_ID(+) = PPST.STRUCTURE_TYPE_ID
AND POR.RELATIONSHIP_TYPE = 'S'
AND PPE.LINK_TASK_FLAG <> 'Y'
AND PPV.PROJ_ELEMENT_ID = PT.TASK_ID (+)
AND PT.WORK_TYPE_ID = PWT.WORK_TYPE_ID(+)
AND PWT.LANGUAGE (+) = USERENV('LANG')
AND NVL( PPVSCH.MILESTONE_FLAG
, 'N' ) = FL1.LOOKUP_CODE
AND FL1.LOOKUP_TYPE = 'YES_NO'
AND NVL( PPVSCH.CRITICAL_FLAG
, 'N' ) = FL2.LOOKUP_CODE
AND FL2.LOOKUP_TYPE = 'YES_NO'
AND PT.CHARGEABLE_FLAG = FL4.LOOKUP_CODE(+)
AND FL4.LOOKUP_TYPE(+) = 'YES_NO'
AND PT.BILLABLE_FLAG = FL5.LOOKUP_CODE(+)
AND FL5.LOOKUP_TYPE(+) = 'YES_NO'
AND PT.RECEIVE_PROJECT_INVOICE_FLAG = FL6.LOOKUP_CODE(+)
AND FL6.LOOKUP_TYPE(+) = 'YES_NO'
AND PT.SERVICE_TYPE_CODE = LU1.LOOKUP_CODE(+)
AND LU1.LOOKUP_TYPE (+) = 'SERVICE TYPE'
AND PPE.PROJECT_ID = PPC.PROJECT_ID(+)
AND PPE.PROJ_ELEMENT_ID = PPC.OBJECT_ID(+)
AND PPE.OBJECT_TYPE = PPC.OBJECT_TYPE (+)
AND NVL( PPC.CURRENT_FLAG(+)
, 'N' ) = 'Y'
AND PPC.PROGRESS_STATUS_CODE = PPS.PROJECT_STATUS_CODE(+)
AND PPC.PROJECT_ID = PPRU.PROJECT_ID (+)
AND 'PA_TASKS' = PPRU.OBJECT_TYPE (+)
AND PPC.OBJECT_ID = PPRU.OBJECT_ID(+)
AND PPC.DATE_COMPUTED = PPRU.AS_OF_DATE (+)
AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
AND PPE5.PHASE_CODE = PPS5.PROJECT_STATUS_CODE (+)
AND TT.TASK_TYPE_ID = PPE.TYPE_ID
AND PPE.PROJECT_ID <> 0

Columns