VIEW: APPS.PA_PROJECT_TEMPLATE_LIST_V

Source

View Text - Preformatted

SELECT PP.ORG_ID , PP.PROJECT_ID , PP.NAME , PP.SEGMENT1 , PP.DESCRIPTION , PP.PROJECT_TYPE , PP.CARRYING_OUT_ORGANIZATION_ID , HOU.NAME , PP.TEMPLATE_START_DATE_ACTIVE , PP.TEMPLATE_END_DATE_ACTIVE , pp.security_level , pp.long_name , PP.RECORD_VERSION_NUMBER FROM PA_PROJECTS PP, HR_ALL_ORGANIZATION_UNITS HOU WHERE PP.CARRYING_OUT_ORGANIZATION_ID = HOU.ORGANIZATION_ID AND PP.TEMPLATE_FLAG = 'Y'

View Text - HTML Formatted

SELECT PP.ORG_ID
, PP.PROJECT_ID
, PP.NAME
, PP.SEGMENT1
, PP.DESCRIPTION
, PP.PROJECT_TYPE
, PP.CARRYING_OUT_ORGANIZATION_ID
, HOU.NAME
, PP.TEMPLATE_START_DATE_ACTIVE
, PP.TEMPLATE_END_DATE_ACTIVE
, PP.SECURITY_LEVEL
, PP.LONG_NAME
, PP.RECORD_VERSION_NUMBER
FROM PA_PROJECTS PP
, HR_ALL_ORGANIZATION_UNITS HOU
WHERE PP.CARRYING_OUT_ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND PP.TEMPLATE_FLAG = 'Y'