VIEW: APPS.IGS_EN_TIMESLOT_CONF_V

Source

View Text - Preformatted

SELECT etc.rowid row_id, etc.igs_en_timeslot_conf_id igs_en_timeslot_conf_id, etc.timeslot_name timeslot_name, etc.start_dt_alias start_dt_alias, cd1.description dsp_description1, cd1.closed_ind dsp_closed_ind1, etc.end_dt_alias end_dt_alias, cd2.description dsp_description2, cd2.closed_ind dsp_closed_ind2, etc.created_by created_by, etc.creation_date creation_date, etc.last_updated_by last_updated_by, etc.last_update_date last_update_date, etc.last_update_login last_update_login FROM IGS_EN_TIMESLOT_CONF etc, igs_ca_da cd1, igs_ca_da cd2 WHERE etc.start_dt_alias = cd1.dt_alias AND etc.end_dt_alias = cd2.dt_alias AND NVL(etc.org_id,NVL(TO_NUMBER(decode(substrb( USERENV('CLIENT_INFO'),1,1),' ',NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =NVL(TO_NUMBER(decode(substrb( USERENV('CLIENT_INFO'),1,1),' ',NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

View Text - HTML Formatted

SELECT ETC.ROWID ROW_ID
, ETC.IGS_EN_TIMESLOT_CONF_ID IGS_EN_TIMESLOT_CONF_ID
, ETC.TIMESLOT_NAME TIMESLOT_NAME
, ETC.START_DT_ALIAS START_DT_ALIAS
, CD1.DESCRIPTION DSP_DESCRIPTION1
, CD1.CLOSED_IND DSP_CLOSED_IND1
, ETC.END_DT_ALIAS END_DT_ALIAS
, CD2.DESCRIPTION DSP_DESCRIPTION2
, CD2.CLOSED_IND DSP_CLOSED_IND2
, ETC.CREATED_BY CREATED_BY
, ETC.CREATION_DATE CREATION_DATE
, ETC.LAST_UPDATED_BY LAST_UPDATED_BY
, ETC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ETC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_TIMESLOT_CONF ETC
, IGS_CA_DA CD1
, IGS_CA_DA CD2
WHERE ETC.START_DT_ALIAS = CD1.DT_ALIAS
AND ETC.END_DT_ALIAS = CD2.DT_ALIAS
AND NVL(ETC.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB( USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) =NVL(TO_NUMBER(DECODE(SUBSTRB( USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)