VIEW: APPS.PA_PERCENT_COMPLETES_FIN_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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