Product: | PA - Projects |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PA_PERCENT_COMPLETES_FIN_V |
SELECT DECODE(PPR.OBJECT_TYPE
, 'PA_TASKS'
, PPR.OBJECT_ID
, 0)
, PPR.AS_OF_DATE
, PPR.LAST_UPDATE_DATE
, PPR.LAST_UPDATED_BY
, PPR.CREATION_DATE
, PPR.CREATED_BY
, PPR.LAST_UPDATE_LOGIN
, NVL(PPR.COMPLETED_PERCENTAGE
, PPR.EFF_ROLLUP_PERCENT_COMP )
, PC.DESCRIPTION
, PPR.PROJECT_ID
, PC.PM_PRODUCT_CODE
, PPR.CURRENT_FLAG
, NVL(PC.PERCENT_COMPLETE_ID
, PPR.PROGRESS_ROLLUP_ID)
, PPR.PROGRESS_STATUS_CODE
, PPR.ACTUAL_START_DATE
, PPR.ACTUAL_FINISH_DATE
, PPR.ESTIMATED_START_DATE
, PPR.ESTIMATED_FINISH_DATE
, PPR.RECORD_VERSION_NUMBER
, PC.PROGRESS_COMMENT
, PPR.OBJECT_ID
, PPR.OBJECT_TYPE
, PPR.OBJECT_VERSION_ID
, PC.PUBLISHED_FLAG
, PC.PUBLISHED_BY_PARTY_ID
, PC.HISTORY_FLAG
, PC.ATTRIBUTE_CATEGORY
, PC.ATTRIBUTE1
, PC.ATTRIBUTE2
, PC.ATTRIBUTE3
, PC.ATTRIBUTE4
, PC.ATTRIBUTE5
, PC.ATTRIBUTE6
, PC.ATTRIBUTE7
, PC.ATTRIBUTE8
, PC.ATTRIBUTE9
, PC.ATTRIBUTE10
, PC.ATTRIBUTE11
, PC.ATTRIBUTE12
, PC.ATTRIBUTE13
, PC.ATTRIBUTE14
, PC.ATTRIBUTE15
FROM PA_PERCENT_COMPLETES PC
, PA_PROGRESS_ROLLUP PPR
WHERE PPR.STRUCTURE_TYPE = 'FINANCIAL'
AND PPR.OBJECT_TYPE IN ('PA_STRUCTURES'
, 'PA_TASKS')
AND NVL(PPR.COMPLETED_PERCENTAGE
, PPR.EFF_ROLLUP_PERCENT_COMP ) IS NOT NULL
AND PC.PROJECT_ID (+) = PPR.PROJECT_ID
AND PC.OBJECT_ID (+) = PPR.OBJECT_ID
AND PC.STRUCTURE_TYPE (+) = 'FINANCIAL'
AND PC.OBJECT_TYPE (+) = PPR.OBJECT_TYPE
AND PC.DATE_COMPUTED (+) = PPR.AS_OF_DATE