VIEW: APPS.PA_TEAM_TEMPLATES_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)