VIEW: APPS.PA_PROJECTS_LOV_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)