View: PA_MAP_WP_TO_FIN_TASKS_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_MAP_WP_TO_FIN_TASKS_V

View Text

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'

Columns