Product: | PA - Projects |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PA_TEAM_TEMPLATES_V |
SELECT TT.TEAM_TEMPLATE_ID
, TT.RECORD_VERSION_NUMBER
, TT.TEAM_TEMPLATE_NAME
, TT.START_DATE_ACTIVE
, TT.END_DATE_ACTIVE
, TT.DESCRIPTION
, ROLE.NAME
, TT.ROLE_LIST_ID
, CALTL.CALENDAR_NAME
, TT.CALENDAR_ID
, WT.NAME
, TT.WORK_TYPE_ID
, TT.TEAM_START_DATE
FROM PA_TEAM_TEMPLATES TT
, JTF_CALENDARS_TL CALTL
, JTF_CALENDARS_B CALB
, PA_ROLE_LISTS ROLE
, PA_WORK_TYPES_V WT
WHERE TT.CALENDAR_ID = CALB.CALENDAR_ID(+)
AND CALB.CALENDAR_ID = CALTL.CALENDAR_ID(+)
AND CALTL.LANGUAGE(+) = USERENV('LANG')
AND TT.WORK_TYPE_ID = WT.WORK_TYPE_ID(+)
AND TT.ROLE_LIST_ID = ROLE.ROLE_LIST_ID(+)