VIEW: APPS.IGSFV_PERSON_OFFICE_HOURS

Source

View Text - Preformatted

SELECT POH.OFFICE_HRS_ID, POH.CONTACT_PREFERENCE_ID, HCP.CONTACT_LEVEL_TABLE_ID, HP.PARTY_NUMBER, HP.PARTY_NAME, '_LA:HCP.CONTACT_TYPE:IGS_LOOKUP_VALUES:CONTACT_TYPE:MEANING', '_LA:HCP.PREFERENCE_CODE:IGS_LOOKUP_VALUES:PREFERENCE_CODE:MEANING', '_LA:HCP.PREFERENCE_TOPIC_TYPE:IGS_LOOKUP_VALUES:PREFERENCE_TOPIC_TYPE:MEANING', HCP.PREFERENCE_START_DATE, HCP.PREFERENCE_END_DATE, HCP.REASON_CODE, '_LA:POH.DAY_OF_WEEK_CODE:IGS_LOOKUP_VALUES:IGS_WEEK_DAYS:MEANING', POH.START_TM_DATE, POH.END_TM_DATE, POH.CREATED_BY, POH.CREATION_DATE, POH.LAST_UPDATED_BY, POH.LAST_UPDATE_DATE, POH.LAST_UPDATE_LOGIN FROM IGS_PE_OFFICE_HRS POH, HZ_CONTACT_PREFERENCES HCP, HZ_PARTIES HP WHERE POH.CONTACT_PREFERENCE_ID = HCP.CONTACT_PREFERENCE_ID AND HCP.CONTACT_LEVEL_TABLE = 'HZ_PARTIES' AND HCP.CONTACT_LEVEL_TABLE_ID = HP.PARTY_ID WITH READ ONLY

View Text - HTML Formatted

SELECT POH.OFFICE_HRS_ID
, POH.CONTACT_PREFERENCE_ID
, HCP.CONTACT_LEVEL_TABLE_ID
, HP.PARTY_NUMBER
, HP.PARTY_NAME
, '_LA:HCP.CONTACT_TYPE:IGS_LOOKUP_VALUES:CONTACT_TYPE:MEANING'
, '_LA:HCP.PREFERENCE_CODE:IGS_LOOKUP_VALUES:PREFERENCE_CODE:MEANING'
, '_LA:HCP.PREFERENCE_TOPIC_TYPE:IGS_LOOKUP_VALUES:PREFERENCE_TOPIC_TYPE:MEANING'
, HCP.PREFERENCE_START_DATE
, HCP.PREFERENCE_END_DATE
, HCP.REASON_CODE
, '_LA:POH.DAY_OF_WEEK_CODE:IGS_LOOKUP_VALUES:IGS_WEEK_DAYS:MEANING'
, POH.START_TM_DATE
, POH.END_TM_DATE
, POH.CREATED_BY
, POH.CREATION_DATE
, POH.LAST_UPDATED_BY
, POH.LAST_UPDATE_DATE
, POH.LAST_UPDATE_LOGIN
FROM IGS_PE_OFFICE_HRS POH
, HZ_CONTACT_PREFERENCES HCP
, HZ_PARTIES HP
WHERE POH.CONTACT_PREFERENCE_ID = HCP.CONTACT_PREFERENCE_ID
AND HCP.CONTACT_LEVEL_TABLE = 'HZ_PARTIES'
AND HCP.CONTACT_LEVEL_TABLE_ID = HP.PARTY_ID WITH READ ONLY