[Home] [Help]
View: PA_PROJECT_TEMPLATE_LIST_V
View Text
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'
Columns
Name |
ORG_ID |
PROJECT_ID |
NAME |
SEGMENT1 |
DESCRIPTION |
PROJECT_TYPE |
CARRYING_OUT_ORGANIZATION_ID |
CARRYING_OUT_ORGANIZATION_NAME |
TEMPLATE_START_DATE_ACTIVE |
TEMPLATE_END_DATE_ACTIVE |
SECURITY_LEVEL |
LONG_NAME |
RECORD_VERSION_NUMBER |