VIEW: APPS.PA_CURR_PROJ_TASK_PROG_V

Source

View Text - Preformatted

SELECT ppc.project_id, ppc.percent_complete_id, ppc.task_id task_id, ppc.object_id, ppc.object_version_id, ppc.object_type, pps.project_status_code, pps.project_status_name, pps.status_icon_ind, pps.status_icon_active_ind, ppc.date_computed as_of_date, ppc.actual_start_date, ppc.actual_finish_date, ppc.estimated_start_date, ppc.estimated_finish_date, ppc.completed_percentage, ppr.base_percent_complete, ppr.incremental_work_quantity, ppr.cumulative_work_quantity, ppr.estimated_remaining_effort, ppc.last_update_date, ppc.published_by_party_id, hzp.party_name, ppc.progress_comment, ppc.description, ppc.published_flag, ppc.current_flag, ppc.record_version_number From pa_percent_completes ppc, pa_progress_rollup ppr, hz_parties hzp, pa_project_statuses pps WHERE ppc.progress_status_code = pps.project_status_code and ppc.published_flag = 'Y' and ppc.current_flag = 'Y' and ppc.object_id = ppr.object_id and ppc.object_type = ppr.object_type and trunc(ppc.date_computed) = trunc(ppr.as_of_date) and ppc.published_by_party_id = hzp.party_id(+)

View Text - HTML Formatted

SELECT PPC.PROJECT_ID
, PPC.PERCENT_COMPLETE_ID
, PPC.TASK_ID TASK_ID
, PPC.OBJECT_ID
, PPC.OBJECT_VERSION_ID
, PPC.OBJECT_TYPE
, PPS.PROJECT_STATUS_CODE
, PPS.PROJECT_STATUS_NAME
, PPS.STATUS_ICON_IND
, PPS.STATUS_ICON_ACTIVE_IND
, PPC.DATE_COMPUTED AS_OF_DATE
, PPC.ACTUAL_START_DATE
, PPC.ACTUAL_FINISH_DATE
, PPC.ESTIMATED_START_DATE
, PPC.ESTIMATED_FINISH_DATE
, PPC.COMPLETED_PERCENTAGE
, PPR.BASE_PERCENT_COMPLETE
, PPR.INCREMENTAL_WORK_QUANTITY
, PPR.CUMULATIVE_WORK_QUANTITY
, PPR.ESTIMATED_REMAINING_EFFORT
, PPC.LAST_UPDATE_DATE
, PPC.PUBLISHED_BY_PARTY_ID
, HZP.PARTY_NAME
, PPC.PROGRESS_COMMENT
, PPC.DESCRIPTION
, PPC.PUBLISHED_FLAG
, PPC.CURRENT_FLAG
, PPC.RECORD_VERSION_NUMBER
FROM PA_PERCENT_COMPLETES PPC
, PA_PROGRESS_ROLLUP PPR
, HZ_PARTIES HZP
, PA_PROJECT_STATUSES PPS
WHERE PPC.PROGRESS_STATUS_CODE = PPS.PROJECT_STATUS_CODE
AND PPC.PUBLISHED_FLAG = 'Y'
AND PPC.CURRENT_FLAG = 'Y'
AND PPC.OBJECT_ID = PPR.OBJECT_ID
AND PPC.OBJECT_TYPE = PPR.OBJECT_TYPE
AND TRUNC(PPC.DATE_COMPUTED) = TRUNC(PPR.AS_OF_DATE)
AND PPC.PUBLISHED_BY_PARTY_ID = HZP.PARTY_ID(+)