View: IGS_PE_OFFICE_HRS_V

Product:	IGS - Student System
Description:	This will be used to view Daily Visiting times for Faculty, Staff, Advisor
Implementation/DBA Data:	APPS.IGS_PE_OFFICE_HRS_V

View Text

SELECT CPREF.ROWID ROW_ID
, CPREF.OFFICE_HRS_ID
, CPREF.CONTACT_PREFERENCE_ID
, HZPREF.CONTACT_LEVEL_TABLE_ID PERSON_ID
, HZPREF.CONTACT_LEVEL_TABLE
, HZ.PARTY_NUMBER PERSON_NUMBER
, CPREF.DAY_OF_WEEK_CODE
, LK.MEANING DAY_OF_WEEK_M
, CPREF.START_TM_DATE
, CPREF.END_TM_DATE
, CPREF.CREATED_BY
, CPREF.CREATION_DATE
, CPREF.LAST_UPDATED_BY
, CPREF.LAST_UPDATE_DATE
, CPREF.LAST_UPDATE_LOGIN
FROM IGS_PE_OFFICE_HRS CPREF
, HZ_PARTIES HZ
, HZ_CONTACT_PREFERENCES HZPREF
, IGS_LOOKUP_VALUES LK
WHERE CPREF.CONTACT_PREFERENCE_ID = HZPREF.CONTACT_PREFERENCE_ID
AND HZPREF.CONTACT_LEVEL_TABLE_ID = HZ.PARTY_ID
AND HZPREF.CONTACT_LEVEL_TABLE='HZ_PARTIES'
AND CPREF.DAY_OF_WEEK_CODE = LK.LOOKUP_CODE
AND LK.LOOKUP_TYPE='IGS_WEEK_DAYS'

Columns