View: PA_PROJECTS_LOV_V

Product:	PA - Projects
Description:	Single-Org
Implementation/DBA Data:	APPS.PA_PROJECTS_LOV_V

View Text

SELECT PPA.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PPA.PROJECT_TYPE
, PPA.CARRYING_OUT_ORGANIZATION_ID
, HOU.NAME
, PPA.DESCRIPTION
, PPA.START_DATE
, PPA.COMPLETION_DATE
, PPA.TEMPLATE_FLAG
, PPA.CREATED_FROM_PROJECT_ID
, PPA.PROJECT_CURRENCY_CODE
, PPA.WORK_TYPE_ID
, PWT.NAME
, PPA.CALENDAR_ID
, JCV.CALENDAR_NAME
, FTV.TERRITORY_SHORT_NAME
, PL.REGION
, PL.CITY
, PPT.ADMINISTRATIVE_FLAG
, PPA.RECORD_VERSION_NUMBER
, PPT.UNASSIGNED_TIME
FROM PA_PROJECTS_ALL PPA
, HR_ALL_ORGANIZATION_UNITS_TL HOU
, PA_PROJECT_TYPES_ALL PPT
, FND_TERRITORIES_VL FTV
, PA_WORK_TYPES_VL PWT
, PA_LOCATIONS PL
, JTF_CALENDARS_VL JCV
WHERE PA_SECURITY.ALLOW_QUERY(PPA.PROJECT_ID) = 'Y'
AND PPA.CARRYING_OUT_ORGANIZATION_ID = HOU.ORGANIZATION_ID (+)
AND USERENV('LANG') = HOU.LANGUAGE (+)
AND PPA.WORK_TYPE_ID = PWT.WORK_TYPE_ID (+)
AND PPA.CALENDAR_ID = JCV.CALENDAR_ID (+)
AND PPA.LOCATION_ID = PL.LOCATION_ID (+)
AND PL.COUNTRY_CODE = FTV.TERRITORY_CODE (+)
AND PPA.PROJECT_TYPE = PPT.PROJECT_TYPE
AND NVL(PPA.ORG_ID
, -1) = NVL(PPT.ORG_ID
, -1)

Columns