ANC_ABSENCE_REASONS

Details

Schema: FUSION
Object owner: ANC
Object type: VIEW

Columns

Name
ABSENCE_REASON_ID ANC_ABS_REASONS_F_ALTCD CREATED_BY CREATION_DATE EFFECTIVE_START_DATE EFFECTIVE_END_DATE ENTERPRISE_ID LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY LEGISLATION_CODE OBJECT_VERSION_NUMBER NAME STATUS DESCRIPTION LANGUAGE SGUID BASE_NAME

Name

ABSENCE_REASON_ID

ANC_ABS_REASONS_F_ALTCD

CREATED_BY

CREATION_DATE

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

ENTERPRISE_ID

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LAST_UPDATED_BY

LEGISLATION_CODE

OBJECT_VERSION_NUMBER

NAME

STATUS

DESCRIPTION

LANGUAGE

SGUID

BASE_NAME

Query

SQL_Statement
SELECT AbsenceReasonsDEO.ABSENCE_REASON_ID, AbsenceReasonsDEO.ANC_ABS_REASONS_F_ALTCD, AbsenceReasonsDEO.CREATED_BY, AbsenceReasonsDEO.CREATION_DATE, AbsenceReasonsDEO.EFFECTIVE_START_DATE, AbsenceReasonsDEO.EFFECTIVE_END_DATE, AbsenceReasonsDEO.ENTERPRISE_ID, AbsenceReasonsDEO.LAST_UPDATE_DATE, AbsenceReasonsDEO.LAST_UPDATE_LOGIN, AbsenceReasonsDEO.LAST_UPDATED_BY, AbsenceReasonsDEO.LEGISLATION_CODE, AbsenceReasonsDEO.OBJECT_VERSION_NUMBER, AbsenceReasonsTranslationDEO.NAME, AbsenceReasonsDEO.STATUS, AbsenceReasonsTranslationDEO.DESCRIPTION, AbsenceReasonsTranslationDEO.LANGUAGE, AbsenceReasonsDEO.SGUID SGUID, AbsenceReasonsDEO.BASE_NAME FROM ANC_ABSENCE_REASONS_F AbsenceReasonsDEO, ANC_ABSENCE_REASONS_F_TL AbsenceReasonsTranslationDEO WHERE AbsenceReasonsDEO.ABSENCE_REASON_ID = AbsenceReasonsTranslationDEO.ABSENCE_REASON_ID AND AbsenceReasonsDEO.EFFECTIVE_START_DATE = AbsenceReasonsTranslationDEO.EFFECTIVE_START_DATE AND AbsenceReasonsDEO.EFFECTIVE_END_DATE = AbsenceReasonsTranslationDEO.EFFECTIVE_END_DATE AND AbsenceReasonsTranslationDEO.LANGUAGE = SYS_CONTEXT('USERENV', 'LANG')

SQL_Statement

SELECT

AbsenceReasonsDEO.ABSENCE_REASON_ID,

AbsenceReasonsDEO.ANC_ABS_REASONS_F_ALTCD,

AbsenceReasonsDEO.CREATED_BY,

AbsenceReasonsDEO.CREATION_DATE,

AbsenceReasonsDEO.EFFECTIVE_START_DATE,

AbsenceReasonsDEO.EFFECTIVE_END_DATE,

AbsenceReasonsDEO.ENTERPRISE_ID,

AbsenceReasonsDEO.LAST_UPDATE_DATE,

AbsenceReasonsDEO.LAST_UPDATE_LOGIN,

AbsenceReasonsDEO.LAST_UPDATED_BY,

AbsenceReasonsDEO.LEGISLATION_CODE,

AbsenceReasonsDEO.OBJECT_VERSION_NUMBER,

AbsenceReasonsTranslationDEO.NAME,

AbsenceReasonsDEO.STATUS,

AbsenceReasonsTranslationDEO.DESCRIPTION,

AbsenceReasonsTranslationDEO.LANGUAGE,

AbsenceReasonsDEO.SGUID SGUID,

AbsenceReasonsDEO.BASE_NAME

FROM

ANC_ABSENCE_REASONS_F AbsenceReasonsDEO,

ANC_ABSENCE_REASONS_F_TL AbsenceReasonsTranslationDEO

WHERE

AbsenceReasonsDEO.ABSENCE_REASON_ID = AbsenceReasonsTranslationDEO.ABSENCE_REASON_ID AND AbsenceReasonsDEO.EFFECTIVE_START_DATE = AbsenceReasonsTranslationDEO.EFFECTIVE_START_DATE AND AbsenceReasonsDEO.EFFECTIVE_END_DATE = AbsenceReasonsTranslationDEO.EFFECTIVE_END_DATE AND AbsenceReasonsTranslationDEO.LANGUAGE = SYS_CONTEXT('USERENV', 'LANG')