View: PA_PROJECT_LISTS_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_PROJECT_LISTS_V

View Text

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

Columns