View: PA_FIN_PERCENT_COMP_HIST_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_FIN_PERCENT_COMP_HIST_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.OBJECT_TYPE
, PPV.ELEMENT_VERSION_ID
, PPE.PROJ_ELEMENT_ID
, PPE.PROJECT_ID
, PPV.PARENT_STRUCTURE_VERSION_ID
, PPE.RECORD_VERSION_NUMBER
, PPV.RECORD_VERSION_NUMBER
, PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(PPE.PROJ_ELEMENT_ID)
, PPC.PERCENT_COMPLETE_ID PERCENT_COMPLETE_ID
, PPR.PROGRESS_ROLLUP_ID PROGRESS_ROLLUP_ID
, NVL(PPC.DATE_COMPUTED
, PPR.AS_OF_DATE) AS_OF_DATE
, NVL(PPC.COMPLETED_PERCENTAGE
, NVL(PPR.COMPLETED_PERCENTAGE
, PPR.EFF_ROLLUP_PERCENT_COMP)) COMPLETED_PERCENTAGE
, NVL(PPC.CURRENT_FLAG
, DECODE(PPR.CURRENT_FLAG
, 'Y'
, 'Y'
, 'N')) CURRENT_FLAG
, NVL(PPC.PUBLISHED_FLAG
, DECODE(PPR.STRUCTURE_VERSION_ID
, NULL
, 'Y'
, 'N')) PUBLISHED_FLAG
, PPC.DESCRIPTION
, PPC.PROGRESS_COMMENT
FROM PA_PROJ_ELEM_VER_STRUCTURE PPVS
, PA_PROJ_STRUCTURE_TYPES PPST
, PA_STRUCTURE_TYPES PST
, PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPV
, PA_PERCENT_COMPLETES PPC
, PA_PROGRESS_ROLLUP PPR
WHERE PPE.PROJ_ELEMENT_ID = PPV.PROJ_ELEMENT_ID
AND PPE.PROJECT_ID = PPV.PROJECT_ID
AND PPE.OBJECT_TYPE IN ('PA_STRUCTURES'
, 'PA_TASKS')
AND PPV.PROJECT_ID = PPVS.PROJECT_ID
AND PPV.PARENT_STRUCTURE_VERSION_ID = PPVS.ELEMENT_VERSION_ID
AND ( (PPVS.STATUS_CODE = 'STRUCTURE_PUBLISHED'
AND PPVS.LATEST_EFF_PUBLISHED_FLAG = 'Y' ) OR ( PPVS.STATUS_CODE = 'STRUCTURE_WORKING'
AND PPVS.CURRENT_WORKING_FLAG = 'Y'
AND NOT EXISTS (SELECT 1
FROM PA_PROJ_ELEM_VER_STRUCTURE STR2
WHERE STR2.PROJECT_ID = PPVS.PROJECT_ID
AND STR2.PROJ_ELEMENT_ID = PPVS.PROJ_ELEMENT_ID
AND STR2.STATUS_CODE = 'STRUCTURE_PUBLISHED' ) ) )
AND PPVS.PROJ_ELEMENT_ID = PPST.PROJ_ELEMENT_ID
AND PST.STRUCTURE_TYPE_ID = PPST.STRUCTURE_TYPE_ID
AND PST.STRUCTURE_TYPE_ID = 6
AND PPE.LINK_TASK_FLAG <> 'Y'
AND PPE.PROJECT_ID <> 0
AND PPR.PROJECT_ID = PPE.PROJECT_ID
AND PPR.OBJECT_ID = PPE.PROJ_ELEMENT_ID
AND PPR.OBJECT_TYPE = PPE.OBJECT_TYPE
AND PPR.STRUCTURE_TYPE = 'FINANCIAL'
AND PPR.PROJECT_ID = PPC.PROJECT_ID (+)
AND PPR.OBJECT_ID = PPC.OBJECT_ID (+)
AND PPR.OBJECT_VERSION_ID = PPC.OBJECT_VERSION_ID (+)
AND PPR.OBJECT_TYPE = PPC.OBJECT_TYPE (+)
AND PPR.STRUCTURE_TYPE = PPC.STRUCTURE_TYPE (+)
AND PPR.AS_OF_DATE = PPC.DATE_COMPUTED (+)
AND DECODE(PPR.CURRENT_FLAG
, 'W'
, 'N'
, PPR.CURRENT_FLAG) = PPC.CURRENT_FLAG (+)

Columns