HHR_VLTR_PRJ_PROJECT_VL

Details

• Schema: FUSION

• Object owner: HHR

• Object type: VIEW

Columns

Name

PROJECT_ID STATE START_DATE END_DATE START_TIME END_TIME REGISTRATION_DEADLINE REG_DEADLINE PROJECT_INITIATIVE VOLUNTEER_JOB IS_SAME_SCH_SELECTED_DAYS 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 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 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 PROJECT_TYPE COUNTRY CITY

Query

SQL_Statement

SELECT A.PROJECT_ID PROJECT_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.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, 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, 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.PROJECT_TYPE PROJECT_TYPE, B.COUNTRY COUNTRY, B.CITY CITY FROM HWR_VLTR_PROJECT_B A, HWR_VLTR_PROJECT_TL B WHERE A.PROJECT_ID = B.PROJECT_ID AND B.LANGUAGE = USERENV('LANG')