VIEW: APPS.PA_PROJECT_LISTS_V

Source

View Text - Preformatted

SELECT PPA.PROJECT_ID , PPA.NAME , PPA.SEGMENT1 , PPA.PROJECT_TYPE , PPA.CARRYING_OUT_ORGANIZATION_ID , HOU.NAME , PUBLIC_SECTOR_FLAG , FL.MEANING , PPA.PROJECT_STATUS_CODE , PPS.PROJECT_STATUS_NAME , PPA.DESCRIPTION , PPA.START_DATE , PPA.COMPLETION_DATE , PPA.CLOSED_DATE , PPA.DISTRIBUTION_RULE , PPA.TEMPLATE_FLAG , PPA.CREATED_FROM_PROJECT_ID , PPA.TEMPLATE_START_DATE_ACTIVE , PPA.TEMPLATE_END_DATE_ACTIVE , PPA.SUMMARY_FLAG , PPA.ENABLED_FLAG , PPA.ORG_ID , PPA.PROJECT_CURRENCY_CODE , PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER (PPA.PROJECT_ID) , PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER_NAME (PPA.PROJECT_ID) , NULL , PA_PROJECTS_MAINT_UTILS.GET_PRIMARY_CUSTOMER_NAME(PPA.PROJECT_ID) , NULL , PPA.pm_product_code , PPA.pm_project_reference , PPA.actual_start_date , PPA.actual_finish_date , PPA.early_start_date , PPA.early_finish_date , PPA.late_start_date , PPA.late_finish_date , PPA.scheduled_start_date , PPA.scheduled_finish_date , PPA.location_id , PL.country_code , FTV.territory_short_name , PL.region , PL.city , PPA.probability_member_id , PRO.probability_percentage , PPA.expected_approval_date , PPA.project_value , PPT.service_type_code , PR.PROGRESS_STATUS_CODE , PR.PROGRESS_STATUS_NAME , PR.STATUS_ICON_IND , PR.STATUS_ICON_ACTIVE_IND , PR.REPORT_END_DATE , PPA.record_version_number , 'Y' , NULL , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , to_number(NULL) , ppoa.opportunity_value , ppoa.opp_value_currency_code , ppoa.projfunc_opp_value , ppa.projfunc_currency_code , ppoa.project_opp_value , pr.report_type_name , pr.report_type_id , ppa.security_level , pal.meaning , ppa.long_name , PA_PROJECT_DATES_UTILS.get_project_start_date(PPA.PROJECT_ID) , PA_PROJECT_DATES_UTILS.get_project_finish_date(PPA.PROJECT_ID) , ppa.baseline_start_date , ppa.baseline_finish_date , ppa.target_start_date , ppa.target_finish_date , priority.meaning FROM PA_PROJECTS_ALL PPA, HR_ALL_ORGANIZATION_UNITS HOU , PA_PROJECT_STATUSES PPS , PA_PROBABILITY_MEMBERS PRO , PA_LOCATIONS PL , FND_TERRITORIES_VL FTV , PA_PROJECT_TYPES_ALL PPT, FND_LOOKUPS FL , PA_PROJ_CURR_STATUS_REP_V pr, pa_project_opp_attrs ppoa, pa_lookups PAL, pa_lookups priority WHERE PPA.TEMPLATE_FLAG = 'N' AND PPA.CARRYING_OUT_ORGANIZATION_ID = HOU.ORGANIZATION_ID AND PPA.PROJECT_STATUS_CODE = PPS.PROJECT_STATUS_CODE AND PPA.PROBABILITY_MEMBER_ID = PRO.PROBABILITY_MEMBER_ID (+) AND PPA.LOCATION_ID = PL.LOCATION_ID (+) AND PL.COUNTRY_CODE = FTV.TERRITORY_CODE (+) AND PPA.PROJECT_TYPE = PPT.project_type AND PPA.ORG_ID = PPT.ORG_ID AND PPA.PUBLIC_SECTOR_FLAG = FL.LOOKUP_CODE AND FL.LOOKUP_TYPE = 'YES_NO' AND PPA.PROJECT_ID = PR.PROJECT_ID (+) and ppa.project_id = ppoa.project_id AND PAL.lookup_type = 'PA_PROJECT_ACCESS_LEVEL' AND PAL.lookup_code = to_char(ppa.security_level) AND priority.lookup_type (+) = 'PA_PROJECT_PRIORITY_CODE' AND priority.lookup_code (+) = ppa.priority_code

View Text - HTML Formatted

SELECT PPA.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PPA.PROJECT_TYPE
, PPA.CARRYING_OUT_ORGANIZATION_ID
, HOU.NAME
, PUBLIC_SECTOR_FLAG
, FL.MEANING
, PPA.PROJECT_STATUS_CODE
, PPS.PROJECT_STATUS_NAME
, PPA.DESCRIPTION
, PPA.START_DATE
, PPA.COMPLETION_DATE
, PPA.CLOSED_DATE
, PPA.DISTRIBUTION_RULE
, PPA.TEMPLATE_FLAG
, PPA.CREATED_FROM_PROJECT_ID
, PPA.TEMPLATE_START_DATE_ACTIVE
, PPA.TEMPLATE_END_DATE_ACTIVE
, PPA.SUMMARY_FLAG
, PPA.ENABLED_FLAG
, PPA.ORG_ID
, PPA.PROJECT_CURRENCY_CODE
, PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER (PPA.PROJECT_ID)
, PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER_NAME (PPA.PROJECT_ID)
, NULL
, PA_PROJECTS_MAINT_UTILS.GET_PRIMARY_CUSTOMER_NAME(PPA.PROJECT_ID)
, NULL
, PPA.PM_PRODUCT_CODE
, PPA.PM_PROJECT_REFERENCE
, PPA.ACTUAL_START_DATE
, PPA.ACTUAL_FINISH_DATE
, PPA.EARLY_START_DATE
, PPA.EARLY_FINISH_DATE
, PPA.LATE_START_DATE
, PPA.LATE_FINISH_DATE
, PPA.SCHEDULED_START_DATE
, PPA.SCHEDULED_FINISH_DATE
, PPA.LOCATION_ID
, PL.COUNTRY_CODE
, FTV.TERRITORY_SHORT_NAME
, PL.REGION
, PL.CITY
, PPA.PROBABILITY_MEMBER_ID
, PRO.PROBABILITY_PERCENTAGE
, PPA.EXPECTED_APPROVAL_DATE
, PPA.PROJECT_VALUE
, PPT.SERVICE_TYPE_CODE
, PR.PROGRESS_STATUS_CODE
, PR.PROGRESS_STATUS_NAME
, PR.STATUS_ICON_IND
, PR.STATUS_ICON_ACTIVE_IND
, PR.REPORT_END_DATE
, PPA.RECORD_VERSION_NUMBER
, 'Y'
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, PPOA.OPPORTUNITY_VALUE
, PPOA.OPP_VALUE_CURRENCY_CODE
, PPOA.PROJFUNC_OPP_VALUE
, PPA.PROJFUNC_CURRENCY_CODE
, PPOA.PROJECT_OPP_VALUE
, PR.REPORT_TYPE_NAME
, PR.REPORT_TYPE_ID
, PPA.SECURITY_LEVEL
, PAL.MEANING
, PPA.LONG_NAME
, PA_PROJECT_DATES_UTILS.GET_PROJECT_START_DATE(PPA.PROJECT_ID)
, PA_PROJECT_DATES_UTILS.GET_PROJECT_FINISH_DATE(PPA.PROJECT_ID)
, PPA.BASELINE_START_DATE
, PPA.BASELINE_FINISH_DATE
, PPA.TARGET_START_DATE
, PPA.TARGET_FINISH_DATE
, PRIORITY.MEANING
FROM PA_PROJECTS_ALL PPA
, HR_ALL_ORGANIZATION_UNITS HOU
, PA_PROJECT_STATUSES PPS
, PA_PROBABILITY_MEMBERS PRO
, PA_LOCATIONS PL
, FND_TERRITORIES_VL FTV
, PA_PROJECT_TYPES_ALL PPT
, FND_LOOKUPS FL
, PA_PROJ_CURR_STATUS_REP_V PR
, PA_PROJECT_OPP_ATTRS PPOA
, PA_LOOKUPS PAL
, PA_LOOKUPS PRIORITY
WHERE PPA.TEMPLATE_FLAG = 'N'
AND PPA.CARRYING_OUT_ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND PPA.PROJECT_STATUS_CODE = PPS.PROJECT_STATUS_CODE
AND PPA.PROBABILITY_MEMBER_ID = PRO.PROBABILITY_MEMBER_ID (+)
AND PPA.LOCATION_ID = PL.LOCATION_ID (+)
AND PL.COUNTRY_CODE = FTV.TERRITORY_CODE (+)
AND PPA.PROJECT_TYPE = PPT.PROJECT_TYPE
AND PPA.ORG_ID = PPT.ORG_ID
AND PPA.PUBLIC_SECTOR_FLAG = FL.LOOKUP_CODE
AND FL.LOOKUP_TYPE = 'YES_NO'
AND PPA.PROJECT_ID = PR.PROJECT_ID (+)
AND PPA.PROJECT_ID = PPOA.PROJECT_ID
AND PAL.LOOKUP_TYPE = 'PA_PROJECT_ACCESS_LEVEL'
AND PAL.LOOKUP_CODE = TO_CHAR(PPA.SECURITY_LEVEL)
AND PRIORITY.LOOKUP_TYPE (+) = 'PA_PROJECT_PRIORITY_CODE'
AND PRIORITY.LOOKUP_CODE (+) = PPA.PRIORITY_CODE