VIEW: APPS.PA_RPT_PROJECT_ATTRIBUTES

Source

View Text - Preformatted

SELECT ppa.project_id , pps.project_status_name , ppa.name , ppa.segment1 , ppa.start_date , ppa.completion_date , ppa.closed_date , ppa.pm_product_code , ppa.pm_project_reference , ppa.carrying_out_organization_id , pou1.name , ppa.project_type , ppt.project_type_class_code , ppa.org_id , pou2.name , pa_rpt_utils.get_rpt_class_category(1) , pa_rpt_utils.project_rpt_class( ppa.project_id, pa_rpt_utils.get_rpt_class_category(1)) , pa_rpt_utils.get_rpt_class_category(2) , pa_rpt_utils.project_rpt_class( ppa.project_id, pa_rpt_utils.get_rpt_class_category(2)) , pa_rpt_utils.get_rpt_class_category(3) , pa_rpt_utils.project_rpt_class( ppa.project_id, pa_rpt_utils.get_rpt_class_category(3)) , pa_rpt_utils.get_rpt_role_type(1) , pa_rpt_utils.project_rpt_keymember(ppa.project_id, pa_rpt_utils.get_rpt_role_type(1)) , pa_rpt_utils.get_rpt_role_type(2) , pa_rpt_utils.project_rpt_keymember(ppa.project_id, pa_rpt_utils.get_rpt_role_type(2)) , pa_rpt_utils.get_rpt_role_type(3) , pa_rpt_utils.project_rpt_keymember(ppa.project_id, pa_rpt_utils.get_rpt_role_type(3)) , ppsc.ENABLED_FLAG FROM pa_projects_all ppa , pa_project_types ppt , hr_organization_units pou1 , hr_all_organization_units pou2 , pa_project_statuses pps , pa_project_status_controls ppsc WHERE ppa.project_type = ppt.project_type and ppa.project_status_code = pps.project_status_code and ppa.carrying_out_organization_id = pou1.organization_id and ppa.org_id=pou2.organization_id(+) and ppa.template_flag = 'N' and PA_SECURITY.ALLOW_QUERY(ppa.PROJECT_ID) = 'Y' and pps.project_status_code = ppsc.project_status_code and ppsc.action_code = 'STATUS_REPORTING' and ppa.org_id = ppt.org_id

View Text - HTML Formatted

SELECT PPA.PROJECT_ID
, PPS.PROJECT_STATUS_NAME
, PPA.NAME
, PPA.SEGMENT1
, PPA.START_DATE
, PPA.COMPLETION_DATE
, PPA.CLOSED_DATE
, PPA.PM_PRODUCT_CODE
, PPA.PM_PROJECT_REFERENCE
, PPA.CARRYING_OUT_ORGANIZATION_ID
, POU1.NAME
, PPA.PROJECT_TYPE
, PPT.PROJECT_TYPE_CLASS_CODE
, PPA.ORG_ID
, POU2.NAME
, PA_RPT_UTILS.GET_RPT_CLASS_CATEGORY(1)
, PA_RPT_UTILS.PROJECT_RPT_CLASS( PPA.PROJECT_ID
, PA_RPT_UTILS.GET_RPT_CLASS_CATEGORY(1))
, PA_RPT_UTILS.GET_RPT_CLASS_CATEGORY(2)
, PA_RPT_UTILS.PROJECT_RPT_CLASS( PPA.PROJECT_ID
, PA_RPT_UTILS.GET_RPT_CLASS_CATEGORY(2))
, PA_RPT_UTILS.GET_RPT_CLASS_CATEGORY(3)
, PA_RPT_UTILS.PROJECT_RPT_CLASS( PPA.PROJECT_ID
, PA_RPT_UTILS.GET_RPT_CLASS_CATEGORY(3))
, PA_RPT_UTILS.GET_RPT_ROLE_TYPE(1)
, PA_RPT_UTILS.PROJECT_RPT_KEYMEMBER(PPA.PROJECT_ID
, PA_RPT_UTILS.GET_RPT_ROLE_TYPE(1))
, PA_RPT_UTILS.GET_RPT_ROLE_TYPE(2)
, PA_RPT_UTILS.PROJECT_RPT_KEYMEMBER(PPA.PROJECT_ID
, PA_RPT_UTILS.GET_RPT_ROLE_TYPE(2))
, PA_RPT_UTILS.GET_RPT_ROLE_TYPE(3)
, PA_RPT_UTILS.PROJECT_RPT_KEYMEMBER(PPA.PROJECT_ID
, PA_RPT_UTILS.GET_RPT_ROLE_TYPE(3))
, PPSC.ENABLED_FLAG
FROM PA_PROJECTS_ALL PPA
, PA_PROJECT_TYPES PPT
, HR_ORGANIZATION_UNITS POU1
, HR_ALL_ORGANIZATION_UNITS POU2
, PA_PROJECT_STATUSES PPS
, PA_PROJECT_STATUS_CONTROLS PPSC
WHERE PPA.PROJECT_TYPE = PPT.PROJECT_TYPE
AND PPA.PROJECT_STATUS_CODE = PPS.PROJECT_STATUS_CODE
AND PPA.CARRYING_OUT_ORGANIZATION_ID = POU1.ORGANIZATION_ID
AND PPA.ORG_ID=POU2.ORGANIZATION_ID(+)
AND PPA.TEMPLATE_FLAG = 'N'
AND PA_SECURITY.ALLOW_QUERY(PPA.PROJECT_ID) = 'Y'
AND PPS.PROJECT_STATUS_CODE = PPSC.PROJECT_STATUS_CODE
AND PPSC.ACTION_CODE = 'STATUS_REPORTING'
AND PPA.ORG_ID = PPT.ORG_ID