View: PA_DELIV_ONLY_PROG_HIST_V

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

View Text

SELECT PPA.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PPA.LONG_NAME
, DELPPE.OBJECT_TYPE DEL_OBJECT_TYPE
, DELPPEV.ELEMENT_VERSION_ID DEL_ELEMENT_VERSION_ID
, DELPPEV.PROJ_ELEMENT_ID DEL_ID
, DELPPE.NAME DEL_NAME
, DELPPE.ELEMENT_NUMBER DEL_NUMBER
, DELPPE.MANAGER_PERSON_ID DEL_MANAGER_ID
, PAPF.FULL_NAME DEL_MANAGER_NAME
, DELPPE.STATUS_CODE DEL_STATUS_CODE
, PPS3.PROJECT_STATUS_NAME DEL_STATUS_NAME
, PPS3.PROJECT_SYSTEM_STATUS_CODE DEL_SYSTEM_STATUS_CODE
, PPC.DATE_COMPUTED
, PPC.PERCENT_COMPLETE_ID
, PPC.COMPLETED_PERCENTAGE
, PPS.PROJECT_STATUS_CODE PROGRESS_STATUS_CODE
, PPS.PROJECT_STATUS_NAME PROGRESS_STATUS_NAME
, PPS.PROJECT_SYSTEM_STATUS_CODE PROGRESS_SYSTEM_STATUS_CODE
, PPS.STATUS_ICON_IND
, PPS.STATUS_ICON_ACTIVE_IND
, PPVSCH.SCHEDULED_START_DATE
, PPVSCH.SCHEDULED_FINISH_DATE
, PPR.ACTUAL_START_DATE
, PPR.ACTUAL_FINISH_DATE
, PPR.BASE_PERCENT_COMPLETE
, PPR.EFF_ROLLUP_PERCENT_COMP
, PPC.PUBLISHED_BY_PARTY_ID
, PPC.PROGRESS_COMMENT
, PPC.DESCRIPTION
, PPC.LAST_UPDATE_DATE
, PPC.PUBLISHED_FLAG
, PPC.CURRENT_FLAG
, PPC.RECORD_VERSION_NUMBER PERCOMP_RECORD_VERSION_NUMBER
, PPR.RECORD_VERSION_NUMBER ROLLUP_RECORD_VERSION_NUMBER
, PPR.BASE_PROGRESS_STATUS_CODE
, PPS1.PROJECT_STATUS_NAME BASE_PROGRESS_STATUS_NAME
, DELPPE.LAST_UPDATE_DATE DEL_LAST_UPDATE_DATE
, PPVSCH.LAST_UPDATE_DATE DEL_SCH_LAST_UPDATE_DATE
, PPR.EFF_ROLLUP_PROG_STAT_CODE
, PPS2.PROJECT_STATUS_NAME EFF_ROLLUP_STATUS_NAME
, PPS2.STATUS_ICON_IND EFF_ROLLUP_STATUS_ICON_IND
, DELPPE.PROGRESS_OUTDATED_FLAG
, PPR.STRUCTURE_TYPE
, PPR.PROJ_ELEMENT_ID
, PPR.STRUCTURE_VERSION_ID
, PPR.TASK_WT_BASIS_CODE
, PPR.PERCENT_COMPLETE_ID
, PPC.STRUCTURE_TYPE
FROM PA_PROJECTS_ALL PPA
, PA_PROJ_ELEMENTS DELPPE
, /*DELIVERABLE*/ PA_PROJ_ELEMENT_VERSIONS DELPPEV
, /*DELIVERABLE*/ PA_PROJ_ELEM_VER_SCHEDULE PPVSCH
, /*DELIVERABLE SCHEDULE*/ PA_PERCENT_COMPLETES PPC
, PA_PROGRESS_ROLLUP PPR
, PA_PROJECT_STATUSES PPS
, /*PROGRESS STATUS CODE*/ PA_PROJECT_STATUSES PPS1
, /* BASE PROGRESS STATUS*/ PA_PROJECT_STATUSES PPS2
, /* EFF ROLLUP STATUS*/ PA_PROJECT_STATUSES PPS3
, /* DELIVERABLE STATUS*/ PER_ALL_PEOPLE_F PAPF /* FOR DELIVERABLE MANAGER NAME*/
WHERE PPA.PROJECT_ID = DELPPE.PROJECT_ID
AND DELPPEV.PROJ_ELEMENT_ID = DELPPE.PROJ_ELEMENT_ID
AND DELPPEV.PROJECT_ID = DELPPE.PROJECT_ID
AND DELPPE.OBJECT_TYPE = 'PA_DELIVERABLES'
AND DELPPE.OBJECT_TYPE = DELPPEV.OBJECT_TYPE
AND NVL(DELPPE.STATUS_CODE
, 'X') = PPS3.PROJECT_STATUS_CODE(+)
AND PPA.PROJECT_ID = PPVSCH.PROJECT_ID
AND PPVSCH.PROJ_ELEMENT_ID = DELPPE.PROJ_ELEMENT_ID
AND DELPPE.PROJECT_ID = PPC.PROJECT_ID
AND DELPPE.PROJ_ELEMENT_ID = PPC.OBJECT_ID
AND DELPPE.OBJECT_TYPE = PPC.OBJECT_TYPE
AND PPC.PROJECT_ID = PPR.PROJECT_ID
AND PPC.OBJECT_ID = PPR.OBJECT_ID
AND PPR.CURRENT_FLAG <> 'W'
AND PPC.OBJECT_TYPE = PPR.OBJECT_TYPE
AND PPC.PUBLISHED_FLAG = 'Y'
AND TRUNC(PPC.DATE_COMPUTED) = TRUNC(PPR.AS_OF_DATE)
AND PPS.PROJECT_STATUS_CODE (+)= PPC.PROGRESS_STATUS_CODE
AND PPS1.PROJECT_STATUS_CODE (+)= PPR.BASE_PROGRESS_STATUS_CODE
AND PPS2.PROJECT_STATUS_CODE (+)= PPR.EFF_ROLLUP_PROG_STAT_CODE
AND PPC.STRUCTURE_TYPE = 'WORKPLAN'
AND PPR.STRUCTURE_TYPE = PPC.STRUCTURE_TYPE
AND PPR.STRUCTURE_VERSION_ID IS NULL
AND PAPF.PERSON_ID(+) = DELPPE.MANAGER_PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE(+)
AND PAPF.EFFECTIVE_END_DATE(+)

Columns