VIEW: APPS.IGSFV_USEC_MEETING_SCHEDULES

Source

View Text - Preformatted

SELECT USO.OCCURRENCE_IDENTIFIER OCCURRENCE_IDENTIFIER, USO.MONDAY MONDAY_INDICATOR, USO.TUESDAY TUESDAY_INDICATOR, USO.WEDNESDAY WEDNESDAY_INDICATOR, USO.THURSDAY THURSDAY_INDICATOR, USO.FRIDAY FRIDAY_INDICATOR, USO.SATURDAY SATURDAY_INDICATOR, USO.SUNDAY SUNDAY_INDICATOR, USO.START_TIME, USO.END_TIME, USO.BUILDING_CODE, USO.ROOM_CODE, '_LA:SCHEDULE_STATUS:IGS_LOOKUP_VALUES:SCHEDULE_TYPE:MEANING', USO.STATUS_LAST_UPDATED, USO.ERROR_TEXT, USO.INST_NOTIFY_IND INST_NOTIFY_INDICATOR, USO.NOTIFY_STATUS, '_DF:IGS:IGS_PS_UNITSEC_OCCUR:USO', USO.DEDICATED_BUILDING_CODE, USO.DEDICATED_ROOM_CODE, USO.PREFERRED_BUILDING_CODE, USO.PREFERRED_ROOM_CODE, USO.START_DATE, USO.END_DATE, USO.TO_BE_ANNOUNCED TO_BE_ANNOUNCED_INDICATOR, BLD1.DESCRIPTION BUILDING_DESCRIPTION, ROM1.DESCRIPTION ROOM_DESCRIPTION, BLD2.DESCRIPTION DEDICATED_BUILDING_DESC, ROM2.DESCRIPTION DEDICATED_ROOM_DESC, BLD3.DESCRIPTION PREFERRED_BUILDING_DESC, ROM3.DESCRIPTION PREFERRED_ROOM_DESC, USO.UNIT_SECTION_OCCURRENCE_ID, USO.UOO_ID UNIT_SECTION_ID, '_LA:PREFERRED_REGION_CODE:IGS_LOOKUP_VALUES:IGS_OR_LOC_REGION:MEANING', USO.NO_SET_DAY_IND NO_SET_DAY_INDICATOR, USO.CANCEL_FLAG CANCEL_FLAG, USO.ABORT_FLAG ABORT_FLAG, USO.CREATED_BY, USO.CREATION_DATE, USO.LAST_UPDATED_BY, USO.LAST_UPDATE_DATE FROM IGS_PS_USEC_OCCURS_ALL USO, IGS_AD_BUILDING_ALL BLD1, IGS_AD_BUILDING_ALL BLD2, IGS_AD_BUILDING_ALL BLD3, IGS_AD_ROOM_ALL ROM1, IGS_AD_ROOM_ALL ROM2, IGS_AD_ROOM_ALL ROM3 WHERE USO.BUILDING_CODE = BLD1.BUILDING_ID (+) AND USO.ROOM_CODE = ROM1.ROOM_ID (+) AND USO.DEDICATED_BUILDING_CODE = BLD2.BUILDING_ID (+) AND USO.DEDICATED_ROOM_CODE = ROM2.ROOM_ID (+) AND USO.PREFERRED_BUILDING_CODE = BLD3.BUILDING_ID (+) AND USO.PREFERRED_ROOM_CODE = ROM3.ROOM_ID (+) WITH READ ONLY

View Text - HTML Formatted

SELECT USO.OCCURRENCE_IDENTIFIER OCCURRENCE_IDENTIFIER
, USO.MONDAY MONDAY_INDICATOR
, USO.TUESDAY TUESDAY_INDICATOR
, USO.WEDNESDAY WEDNESDAY_INDICATOR
, USO.THURSDAY THURSDAY_INDICATOR
, USO.FRIDAY FRIDAY_INDICATOR
, USO.SATURDAY SATURDAY_INDICATOR
, USO.SUNDAY SUNDAY_INDICATOR
, USO.START_TIME
, USO.END_TIME
, USO.BUILDING_CODE
, USO.ROOM_CODE
, '_LA:SCHEDULE_STATUS:IGS_LOOKUP_VALUES:SCHEDULE_TYPE:MEANING'
, USO.STATUS_LAST_UPDATED
, USO.ERROR_TEXT
, USO.INST_NOTIFY_IND INST_NOTIFY_INDICATOR
, USO.NOTIFY_STATUS
, '_DF:IGS:IGS_PS_UNITSEC_OCCUR:USO'
, USO.DEDICATED_BUILDING_CODE
, USO.DEDICATED_ROOM_CODE
, USO.PREFERRED_BUILDING_CODE
, USO.PREFERRED_ROOM_CODE
, USO.START_DATE
, USO.END_DATE
, USO.TO_BE_ANNOUNCED TO_BE_ANNOUNCED_INDICATOR
, BLD1.DESCRIPTION BUILDING_DESCRIPTION
, ROM1.DESCRIPTION ROOM_DESCRIPTION
, BLD2.DESCRIPTION DEDICATED_BUILDING_DESC
, ROM2.DESCRIPTION DEDICATED_ROOM_DESC
, BLD3.DESCRIPTION PREFERRED_BUILDING_DESC
, ROM3.DESCRIPTION PREFERRED_ROOM_DESC
, USO.UNIT_SECTION_OCCURRENCE_ID
, USO.UOO_ID UNIT_SECTION_ID
, '_LA:PREFERRED_REGION_CODE:IGS_LOOKUP_VALUES:IGS_OR_LOC_REGION:MEANING'
, USO.NO_SET_DAY_IND NO_SET_DAY_INDICATOR
, USO.CANCEL_FLAG CANCEL_FLAG
, USO.ABORT_FLAG ABORT_FLAG
, USO.CREATED_BY
, USO.CREATION_DATE
, USO.LAST_UPDATED_BY
, USO.LAST_UPDATE_DATE
FROM IGS_PS_USEC_OCCURS_ALL USO
, IGS_AD_BUILDING_ALL BLD1
, IGS_AD_BUILDING_ALL BLD2
, IGS_AD_BUILDING_ALL BLD3
, IGS_AD_ROOM_ALL ROM1
, IGS_AD_ROOM_ALL ROM2
, IGS_AD_ROOM_ALL ROM3
WHERE USO.BUILDING_CODE = BLD1.BUILDING_ID (+)
AND USO.ROOM_CODE = ROM1.ROOM_ID (+)
AND USO.DEDICATED_BUILDING_CODE = BLD2.BUILDING_ID (+)
AND USO.DEDICATED_ROOM_CODE = ROM2.ROOM_ID (+)
AND USO.PREFERRED_BUILDING_CODE = BLD3.BUILDING_ID (+)
AND USO.PREFERRED_ROOM_CODE = ROM3.ROOM_ID (+) WITH READ ONLY