VIEW: APPS.PA_MAP_WP_TO_FIN_TASKS_V

Source

View Text - Preformatted

SELECT elemver.element_version_id , elemver.proj_element_id , elemver.object_type , projelem.element_number , projelem.name , elemver.project_id , DECODE(ppa.structure_sharing_code,'SHARE_FULL',elemver.element_version_id , 'SPLIT_NO_MAPPING' ,to_number(null), PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_VERSION_ID(elemver.element_version_id,ppa.structure_sharing_code)), DECODE(ppa.structure_sharing_code ,'SHARE_FULL',elemver.proj_element_id , 'SPLIT_NO_MAPPING' ,to_number(null), PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(elemver.element_version_id,ppa.structure_sharing_code)), DECODE(ppa.structure_sharing_code ,'SHARE_FULL',projelem.name , 'SPLIT_NO_MAPPING' ,to_char(null), PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(elemver.element_version_id,ppa.structure_sharing_code)) , por.object_id_from1 , DECODE(ppa.structure_sharing_code ,'SHARE_FULL',elemver.parent_structure_version_id , 'SPLIT_NO_MAPPING' ,to_number(null), PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_STRUCT_VER_ID(elemver.element_version_id,ppa.structure_sharing_code)) , elemver.parent_structure_version_id FROM pa_proj_element_versions elemver , pa_proj_elements projelem , pa_object_relationships por , pa_projects_all ppa WHERE projelem.project_id = elemver.project_id AND projelem.proj_element_id = elemver.proj_element_id AND elemver.object_type='PA_TASKS' AND projelem.object_type='PA_TASKS' AND por.object_id_to1 = elemver.element_version_id AND por.relationship_type = 'S' AND ppa.project_id = projelem.project_id AND ppa.structure_sharing_code in( 'SHARE_FULL' ,'SHARE_PARTIAL','SPLIT_MAPPING','SPLIT_NO_MAPPING') AND PA_PROJ_ELEMENTS_UTILS.CHECK_IS_WORKPLAN_TASK(elemver.project_id,elemver.proj_element_id) = 'Y'

View Text - HTML Formatted

SELECT ELEMVER.ELEMENT_VERSION_ID
, ELEMVER.PROJ_ELEMENT_ID
, ELEMVER.OBJECT_TYPE
, PROJELEM.ELEMENT_NUMBER
, PROJELEM.NAME
, ELEMVER.PROJECT_ID
, DECODE(PPA.STRUCTURE_SHARING_CODE
, 'SHARE_FULL'
, ELEMVER.ELEMENT_VERSION_ID
, 'SPLIT_NO_MAPPING'
, TO_NUMBER(NULL)
, PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_VERSION_ID(ELEMVER.ELEMENT_VERSION_ID
, PPA.STRUCTURE_SHARING_CODE))
, DECODE(PPA.STRUCTURE_SHARING_CODE
, 'SHARE_FULL'
, ELEMVER.PROJ_ELEMENT_ID
, 'SPLIT_NO_MAPPING'
, TO_NUMBER(NULL)
, PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ELEMVER.ELEMENT_VERSION_ID
, PPA.STRUCTURE_SHARING_CODE))
, DECODE(PPA.STRUCTURE_SHARING_CODE
, 'SHARE_FULL'
, PROJELEM.NAME
, 'SPLIT_NO_MAPPING'
, TO_CHAR(NULL)
, PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ELEMVER.ELEMENT_VERSION_ID
, PPA.STRUCTURE_SHARING_CODE))
, POR.OBJECT_ID_FROM1
, DECODE(PPA.STRUCTURE_SHARING_CODE
, 'SHARE_FULL'
, ELEMVER.PARENT_STRUCTURE_VERSION_ID
, 'SPLIT_NO_MAPPING'
, TO_NUMBER(NULL)
, PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_STRUCT_VER_ID(ELEMVER.ELEMENT_VERSION_ID
, PPA.STRUCTURE_SHARING_CODE))
, ELEMVER.PARENT_STRUCTURE_VERSION_ID
FROM PA_PROJ_ELEMENT_VERSIONS ELEMVER
, PA_PROJ_ELEMENTS PROJELEM
, PA_OBJECT_RELATIONSHIPS POR
, PA_PROJECTS_ALL PPA
WHERE PROJELEM.PROJECT_ID = ELEMVER.PROJECT_ID
AND PROJELEM.PROJ_ELEMENT_ID = ELEMVER.PROJ_ELEMENT_ID
AND ELEMVER.OBJECT_TYPE='PA_TASKS'
AND PROJELEM.OBJECT_TYPE='PA_TASKS'
AND POR.OBJECT_ID_TO1 = ELEMVER.ELEMENT_VERSION_ID
AND POR.RELATIONSHIP_TYPE = 'S'
AND PPA.PROJECT_ID = PROJELEM.PROJECT_ID
AND PPA.STRUCTURE_SHARING_CODE IN( 'SHARE_FULL'
, 'SHARE_PARTIAL'
, 'SPLIT_MAPPING'
, 'SPLIT_NO_MAPPING')
AND PA_PROJ_ELEMENTS_UTILS.CHECK_IS_WORKPLAN_TASK(ELEMVER.PROJECT_ID
, ELEMVER.PROJ_ELEMENT_ID) = 'Y'