PSC_COM_MEET_TEMPLATE

Details

Schema: FUSION
Object owner: PSC_CC
Object type: VIEW

Columns

Name
AGENCY_ID MEET_TEMPLATE_ID ENABLED_FLAG NAME DESCRIPTION APPLICANT_SCHEDULE APPLICANT_RESCHEDULE USE_SCHEDULE_AGENCY USE_SCHEDULE_PLANNER MEETING_DURATION_HOURS START_OF_WINDOW SCHEDULE_UPTO_DAYS MEETING_WORKSCHEDULE MAX_MEETING_CONCURRENCY INCLUDE_AGENDA INCLUDE_VENUE INCLUDE_SUBJECT MEETING_AGENDA_TEXT MEETING_AGENDA_PLAIN_TEXT MEETING_VENUE MEETING_SUBJECT OBJECT_VERSION_NUMBER LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE

Name

AGENCY_ID

MEET_TEMPLATE_ID

ENABLED_FLAG

NAME

DESCRIPTION

APPLICANT_SCHEDULE

APPLICANT_RESCHEDULE

USE_SCHEDULE_AGENCY

USE_SCHEDULE_PLANNER

MEETING_DURATION_HOURS

START_OF_WINDOW

SCHEDULE_UPTO_DAYS

MEETING_WORKSCHEDULE

MAX_MEETING_CONCURRENCY

INCLUDE_AGENDA

INCLUDE_VENUE

INCLUDE_SUBJECT

MEETING_AGENDA_TEXT

MEETING_AGENDA_PLAIN_TEXT

MEETING_VENUE

MEETING_SUBJECT

OBJECT_VERSION_NUMBER

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

CREATED_BY

CREATION_DATE

Query

SQL_Statement
SELECT B.AGENCY_ID, B.MEET_TEMPLATE_ID, B.ENABLED_FLAG, L.NAME, L.DESCRIPTION, B.APPLICANT_SCHEDULE, B.APPLICANT_RESCHEDULE, B.USE_SCHEDULE_AGENCY, B.USE_SCHEDULE_PLANNER, B.MEETING_DURATION_HOURS, B.START_OF_WINDOW, B.SCHEDULE_UPTO_DAYS, B.MEETING_WORKSCHEDULE, B.MAX_MEETING_CONCURRENCY, B.INCLUDE_AGENDA, B.INCLUDE_VENUE, B.INCLUDE_SUBJECT, L.MEETING_AGENDA_TEXT, L.MEETING_AGENDA_PLAIN_TEXT, L.MEETING_VENUE, L.MEETING_SUBJECT, B.OBJECT_VERSION_NUMBER, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.CREATED_BY, B.CREATION_DATE FROM PSC_COM_MEET_TEMPLATE_B B,PSC_COM_MEET_TEMPLATE_TL L WHERE B.AGENCY_ID = L.AGENCY_ID AND B.MEET_TEMPLATE_ID = L.MEET_TEMPLATE_ID AND L.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.AGENCY_ID,

B.MEET_TEMPLATE_ID,

B.ENABLED_FLAG,

L.NAME,

L.DESCRIPTION,

B.APPLICANT_SCHEDULE,

B.APPLICANT_RESCHEDULE,

B.USE_SCHEDULE_AGENCY,

B.USE_SCHEDULE_PLANNER,

B.MEETING_DURATION_HOURS,

B.START_OF_WINDOW,

B.SCHEDULE_UPTO_DAYS,

B.MEETING_WORKSCHEDULE,

B.MAX_MEETING_CONCURRENCY,

B.INCLUDE_AGENDA,

B.INCLUDE_VENUE,

B.INCLUDE_SUBJECT,

L.MEETING_AGENDA_TEXT,

L.MEETING_AGENDA_PLAIN_TEXT,

L.MEETING_VENUE,

L.MEETING_SUBJECT,

B.OBJECT_VERSION_NUMBER,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

B.CREATED_BY,

B.CREATION_DATE

FROM PSC_COM_MEET_TEMPLATE_B B,PSC_COM_MEET_TEMPLATE_TL L

WHERE B.AGENCY_ID = L.AGENCY_ID AND B.MEET_TEMPLATE_ID = L.MEET_TEMPLATE_ID AND L.LANGUAGE = USERENV('LANG')