HWR_VLTR_PROJECT_VL

Details

• Schema: FUSION

• Object owner: HHR

• Object type: VIEW

Columns

Name

PROJECT_ID SOURCE_ID CONVERSATION_ID STATE START_DATE END_DATE START_TIME END_TIME REGISTRATION_DEADLINE REG_DEADLINE PROJECT_INITIATIVE VOLUNTEER_JOB IS_SAME_SCH_SELECTED_DAYS MON_START_TIME TUE_START_TIME WED_START_TIME THU_START_TIME FRI_START_TIME SAT_START_TIME SUN_START_TIME MON_END_TIME TUE_END_TIME WED_END_TIME THU_END_TIME FRI_END_TIME SAT_END_TIME SUN_END_TIME SHIFTS MINIMUM_PARTICIPANT_NUMBER MAXIMUM_PARTICIPANT_NUMBER MAXIMUM_GUEST_NUMBER MINIMUM_AGE_REQUIREMENT PROJECT_LEAD_ID INVITE_PROJECT_LEADERS ORGANIZATION_ID LOGO_FILE_ID PROJECT_NAME PROJECT_DESCRIPTION FOCUS_AREA PARTICIPANT_SKILL_REQUIREMENTS ITEMS_TO_BE_BROUGHT ITEMS_TO_BE_SUPPLIED PARTICIPANT_BENEFITS OTHER_PARTICIPANT_BENEFITS CREATED_BY CREATOR_PERSON_ID CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN AREAS_OF_INTEREST ORGANIZATION_NAME CONTACT_PHONE CONTACT_EMAIL WEBSITE CONTACT_FIRST_NAME CONTACT_LAST_NAME CONTACT_FAX CONTACT_TITLE ADDITIONAL_PROJECT_DETAILS DIRECTIONS_TO_WORK_SITE STATUS LOCATION_ID PROJECT_ADDRESS_ID RECURRENCE_TYPE RECURRENCE_COUNT RECURRENCE_GAP DAYS_OF_WEEK ORGANIZATION_STATE CONTACT_LOCATION_ID CONTACT_ADDRESS_TYPE SUBMITTED_BY PROJECT_LEAD_PERSON_ID PROJECT_START_DATE PROJECT_END_DATE LONGITUDE LATITUDE ENROLLMENT_CHOICE ABSENCE_TYPE_ID COUNTRY_CODE_NUMBER START_DATE_LOC_ZONE END_DATE_LOC_ZONE CT_ACTIVITY_ID PROJECT_TYPE COUNTRY CITY

Query

SQL_Statement

SELECT A.PROJECT_ID PROJECT_ID, A.SOURCE_ID SOURCE_ID, A.CONVERSATION_ID CONVERSATION_ID, A.STATE STATE, A.START_DATE START_DATE, A.END_DATE END_DATE, A.START_TIME START_TIME, A.END_TIME END_TIME, A.REGISTRATION_DEADLINE REGISTRATION_DEADLINE, A.REG_DEADLINE REG_DEADLINE, A.PROJECT_INITIATIVE PROJECT_INITIATIVE, A.VOLUNTEER_JOB VOLUNTEER_JOB, A.IS_SAME_SCH_SELECTED_DAYS IS_SAME_SCH_SELECTED_DAYS, A.MON_START_TIME, A.TUE_START_TIME, A.WED_START_TIME, A.THU_START_TIME, A.FRI_START_TIME, A.SAT_START_TIME, A.SUN_START_TIME, A.MON_END_TIME, A.TUE_END_TIME, A.WED_END_TIME, A.THU_END_TIME, A.FRI_END_TIME, A.SAT_END_TIME, A.SUN_END_TIME, A.SHIFTS SHIFTS, A.MINIMUM_PARTICIPANT_NUMBER MINIMUM_PARTICIPANT_NUMBER, A.MAXIMUM_PARTICIPANT_NUMBER MAXIMUM_PARTICIPANT_NUMBER, A.MAXIMUM_GUEST_NUMBER MAXIMUM_GUEST_NUMBER, A.MINIMUM_AGE_REQUIREMENT MINIMUM_AGE_REQUIREMENT, A.PROJECT_LEAD_ID PROJECT_LEAD_ID, A.INVITE_PROJECT_LEADERS INVITE_PROJECT_LEADERS, A.ORGANIZATION_ID ORGANIZATION_ID, A.LOGO_FILE_ID LOGO_FILE_ID, B.PROJECT_NAME PROJECT_NAME, B.PROJECT_DESCRIPTION PROJECT_DESCRIPTION, B.FOCUS_AREA FOCUS_AREA, B.PARTICIPANT_SKILL_REQUIREMENTS PARTICIPANT_SKILL_REQUIREMENTS, B.ITEMS_TO_BE_BROUGHT ITEMS_TO_BE_BROUGHT, B.ITEMS_TO_BE_SUPPLIED ITEMS_TO_BE_SUPPLIED, B.PARTICIPANT_BENEFITS PARTICIPANT_BENEFITS, B.OTHER_PARTICIPANT_BENEFITS OTHER_PARTICIPANT_BENEFITS, A.CREATED_BY CREATED_BY, A.CREATOR_PERSON_ID CREATOR_PERSON_ID, A.CREATION_DATE CREATION_DATE, A.LAST_UPDATED_BY LAST_UPDATED_BY, A.LAST_UPDATE_DATE LAST_UPDATE_DATE, A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, A.AREAS_OF_INTEREST AREAS_OF_INTEREST, C.NAME ORGANIZATION_NAME, A.CONTACT_PHONE CONTACT_PHONE, A.CONTACT_EMAIL CONTACT_EMAIL, A.WEBSITE WEBSITE, B.CONTACT_FIRST_NAME CONTACT_FIRST_NAME, B.CONTACT_LAST_NAME CONTACT_LAST_NAME, A.CONTACT_FAX CONTACT_FAX, B.CONTACT_TITLE CONTACT_TITLE, B.ADDITIONAL_PROJECT_DETAILS ADDITIONAL_PROJECT_DETAILS, B.DIRECTIONS_TO_WORK_SITE DIRECTIONS_TO_WORK_SITE, A.STATUS STATUS, A.LOCATION_ID LOCATION_ID, A.PROJECT_ADDRESS_ID, A.RECURRENCE_TYPE, A.RECURRENCE_COUNT, A.RECURRENCE_GAP, A.DAYS_OF_WEEK, C.STATE ORGANIZATION_STATE, A.CONTACT_LOCATION_ID CONTACT_LOCATION_ID, B.CONTACT_ADDRESS_TYPE CONTACT_ADDRESS_TYPE, A.SUBMITTED_BY SUBMITTED_BY, A.PROJECT_LEAD_PERSON_ID PROJECT_LEAD_PERSON_ID, A.PROJECT_START_DATE PROJECT_START_DATE, A.PROJECT_END_DATE PROJECT_END_DATE, A.LONGITUDE, A.LATITUDE, A.ENROLLMENT_CHOICE, A.ABSENCE_TYPE_ID, A.COUNTRY_CODE_NUMBER, A.START_DATE_LOC_ZONE, A.END_DATE_LOC_ZONE, A.CT_ACTIVITY_ID, A.PROJECT_TYPE, B.COUNTRY COUNTRY, B.CITY CITY FROM HWR_VLTR_PROJECT_B A, HWR_VLTR_PROJECT_TL B, HWR_VLTR_ORGANIZATION_VL C WHERE A.PROJECT_ID = B.PROJECT_ID AND B.LANGUAGE = USERENV('LANG') AND A.ORGANIZATION_ID = C.ORGANIZATION_ID