[Home] [Help]
3172: elemver.project_id AS PROJECT_ID
3173: , elemver.element_version_id AS ELEMENT_VERSION_ID
3174: , elemver.parent_structure_version_id AS PARENT_STRUCTRE_VERSION_ID
3175: , null AS PARENT_ELEMENT_VERSION_ID
3176: , PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(elemver.element_version_id) AS CHILD_ELEMENT_FLAG
3177: , elem.name AS TASK_NAME
3178: --, elem.element_number AS TASK_NUMBER -- Commented for Bug 5438975
3179: , verstruct.version_number as TASK_NUMBER -- Added for Bug 5438975
3180: , elem.object_type AS OBJECT_TYPE
3182: , elemver.wbs_number AS WBS_NUMBER
3183: , elem.proj_element_id AS PROJ_ELEMENT_ID
3184: , elemver.financial_task_flag AS FINANCIAL_TASK_FLAG
3185: FROM
3186: pa_proj_elements elem
3187: , pa_proj_element_versions elemver
3188: , pa_proj_elem_ver_structure verstruct -- Added for Bug 5438975
3189: WHERE elem.proj_element_id = elemver.proj_element_id
3190: AND elem.project_id = elemver.project_id
3202: elemver.project_id AS PROJECT_ID
3203: , elemver.element_version_id AS ELEMENT_VERSION_ID
3204: , elemver.parent_structure_version_id AS PARENT_STRUCTRE_VERSION_ID
3205: , por.object_id_from1 AS PARENT_ELEMENT_VERSION_ID
3206: , PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(elemver.element_version_id) AS CHILD_ELEMENT_FLAG
3207: , projelem.name AS TASK_NAME
3208: , projelem.element_number AS TASK_NUMBER
3209: , elemver.object_type AS OBJECT_TYPE
3210: , elemver.display_sequence AS DISPLAY_SEQUENCE
3212: , elemver.proj_element_id AS PROJ_ELEMENT_ID
3213: , elemver.financial_task_flag AS FINANCIAL_TASK_FLAG
3214: FROM
3215: pa_proj_element_versions elemver
3216: , pa_proj_elements projelem
3217: , pa_object_relationships por
3218: WHERE
3219: projelem.project_id = elemver.project_id
3220: AND projelem.proj_element_id = elemver.proj_element_id