ANC_ABS_CERTIFICATIONS

Details

Schema: FUSION
Object owner: ANC
Object type: VIEW

Columns

Name
ABSENCE_CERTIFICATION_ID ANC_ABS_CERTIFICATION_F_ALTCD AUTO_COMPLETE_FLAG LEGISLATION_CODE CERT_ADMIN_UPLOAD CERT_COMPLETE_CALC_CD CERT_COMPLETE_CALC_MODE_CD CERT_COMPLETE_CALC_OVERRIDE CERT_COMPLETE_NOTIF_ADMIN CERT_COMPLETE_NOTIF_EMP CERT_COMPLETE_NOTIF_MGR CERT_COMPLETE_UPDATE_CD CERT_CREATE_CALC_CD CERT_CREATE_CALC_MODE_CD CERT_CREATE_CALC_OVERRIDE CERT_CREATE_NOTIF_ADMIN CERT_CREATE_NOTIF_EMP CERT_CREATE_NOTIF_MGR CERT_CREATE_UPDATE_CD CERT_DUE_DATE_CALC_CD CERT_DUE_DATE_CALC_MODE_CD CERT_DUE_DATE_CALC_OVERRIDE CERT_DUE_DATE_NOTIF_ADMIN CERT_DUE_DATE_NOTIF_EMP CERT_DUE_DATE_NOTIF_MGR CERT_DUE_DATE_UPDATE_CD CERT_EMPLOYEE_UPLOAD CERT_EMPLOYEE_USE_CD CERT_EXPIRE_CALC_CD CERT_EXPIRE_CALC_MODE_CD CERT_EXPIRE_CALC_OVERRIDE CERT_EXPIRE_NOTIF_ADMIN CERT_EXPIRE_NOTIF_EMP CERT_EXPIRE_NOTIF_MGR CERT_EXPIRE_UPDATE_CD CERT_MANAGER_UPLOAD CERT_MANAGER_USE_CD NAME CERT_USE_CD CERT_STATUS_CD CERT_TRIGGER_CD CREATED_BY CREATION_DATE DUE_DATE_REFERENCE_DATE_CD DUE_DATE_TYPE_CD DUE_DATE_UNITS DUE_DATE_UOM_CD EFFECTIVE_END_DATE EFFECTIVE_START_DATE ENTERPRISE_ID LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY OBJECT_VERSION_NUMBER UPDATE_ABSENCE_ENTRY ABSENCE_CERTIFICATION_DESC LANGUAGE SOURCE_LANG DOCUMENT_TYPE_ID MANAGEMENT_TYPE_CD CONFIRM_ON_DEMAND ALLOW_ON_DEMAND CNFM_RSN_RULE CNFM_RSN_VALUES EXPIRY_RULE EXPIRY_REF_DATE EXPIRY_UOM VOID_RSN_RULE VOID_RSN_VALUES EXPIRY_DURATION ELIG_PROFILE_ID SGUID BASE_NAME

Name

ABSENCE_CERTIFICATION_ID

ANC_ABS_CERTIFICATION_F_ALTCD

AUTO_COMPLETE_FLAG

LEGISLATION_CODE

CERT_ADMIN_UPLOAD

CERT_COMPLETE_CALC_CD

CERT_COMPLETE_CALC_MODE_CD

CERT_COMPLETE_CALC_OVERRIDE

CERT_COMPLETE_NOTIF_ADMIN

CERT_COMPLETE_NOTIF_EMP

CERT_COMPLETE_NOTIF_MGR

CERT_COMPLETE_UPDATE_CD

CERT_CREATE_CALC_CD

CERT_CREATE_CALC_MODE_CD

CERT_CREATE_CALC_OVERRIDE

CERT_CREATE_NOTIF_ADMIN

CERT_CREATE_NOTIF_EMP

CERT_CREATE_NOTIF_MGR

CERT_CREATE_UPDATE_CD

CERT_DUE_DATE_CALC_CD

CERT_DUE_DATE_CALC_MODE_CD

CERT_DUE_DATE_CALC_OVERRIDE

CERT_DUE_DATE_NOTIF_ADMIN

CERT_DUE_DATE_NOTIF_EMP

CERT_DUE_DATE_NOTIF_MGR

CERT_DUE_DATE_UPDATE_CD

CERT_EMPLOYEE_UPLOAD

CERT_EMPLOYEE_USE_CD

CERT_EXPIRE_CALC_CD

CERT_EXPIRE_CALC_MODE_CD

CERT_EXPIRE_CALC_OVERRIDE

CERT_EXPIRE_NOTIF_ADMIN

CERT_EXPIRE_NOTIF_EMP

CERT_EXPIRE_NOTIF_MGR

CERT_EXPIRE_UPDATE_CD

CERT_MANAGER_UPLOAD

CERT_MANAGER_USE_CD

NAME

CERT_USE_CD

CERT_STATUS_CD

CERT_TRIGGER_CD

CREATED_BY

CREATION_DATE

DUE_DATE_REFERENCE_DATE_CD

DUE_DATE_TYPE_CD

DUE_DATE_UNITS

DUE_DATE_UOM_CD

EFFECTIVE_END_DATE

EFFECTIVE_START_DATE

ENTERPRISE_ID

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LAST_UPDATED_BY

OBJECT_VERSION_NUMBER

UPDATE_ABSENCE_ENTRY

ABSENCE_CERTIFICATION_DESC

LANGUAGE

SOURCE_LANG

DOCUMENT_TYPE_ID

MANAGEMENT_TYPE_CD

CONFIRM_ON_DEMAND

ALLOW_ON_DEMAND

CNFM_RSN_RULE

CNFM_RSN_VALUES

EXPIRY_RULE

EXPIRY_REF_DATE

EXPIRY_UOM

VOID_RSN_RULE

VOID_RSN_VALUES

EXPIRY_DURATION

ELIG_PROFILE_ID

SGUID

BASE_NAME

Query

SQL_Statement
SELECT AbsenceCertificationsDEO.ABSENCE_CERTIFICATION_ID, AbsenceCertificationsDEO.ANC_ABS_CERTIFICATION_F_ALTCD, AbsenceCertificationsDEO.AUTO_COMPLETE_FLAG, AbsenceCertificationsDEO.LEGISLATION_CODE, AbsenceCertificationsDEO.CERT_ADMIN_UPLOAD, AbsenceCertificationsDEO.CERT_COMPLETE_CALC_CD, AbsenceCertificationsDEO.CERT_COMPLETE_CALC_MODE_CD, AbsenceCertificationsDEO.CERT_COMPLETE_CALC_OVERRIDE, AbsenceCertificationsDEO.CERT_COMPLETE_NOTIF_ADMIN, AbsenceCertificationsDEO.CERT_COMPLETE_NOTIF_EMP, AbsenceCertificationsDEO.CERT_COMPLETE_NOTIF_MGR, AbsenceCertificationsDEO.CERT_COMPLETE_UPDATE_CD, AbsenceCertificationsDEO.CERT_CREATE_CALC_CD, AbsenceCertificationsDEO.CERT_CREATE_CALC_MODE_CD, AbsenceCertificationsDEO.CERT_CREATE_CALC_OVERRIDE, AbsenceCertificationsDEO.CERT_CREATE_NOTIF_ADMIN, AbsenceCertificationsDEO.CERT_CREATE_NOTIF_EMP, AbsenceCertificationsDEO.CERT_CREATE_NOTIF_MGR, AbsenceCertificationsDEO.CERT_CREATE_UPDATE_CD, AbsenceCertificationsDEO.CERT_DUE_DATE_CALC_CD, AbsenceCertificationsDEO.CERT_DUE_DATE_CALC_MODE_CD, AbsenceCertificationsDEO.CERT_DUE_DATE_CALC_OVERRIDE, AbsenceCertificationsDEO.CERT_DUE_DATE_NOTIF_ADMIN, AbsenceCertificationsDEO.CERT_DUE_DATE_NOTIF_EMP, AbsenceCertificationsDEO.CERT_DUE_DATE_NOTIF_MGR, AbsenceCertificationsDEO.CERT_DUE_DATE_UPDATE_CD, AbsenceCertificationsDEO.CERT_EMPLOYEE_UPLOAD, AbsenceCertificationsDEO.CERT_EMPLOYEE_USE_CD, AbsenceCertificationsDEO.CERT_EXPIRE_CALC_CD, AbsenceCertificationsDEO.CERT_EXPIRE_CALC_MODE_CD, AbsenceCertificationsDEO.CERT_EXPIRE_CALC_OVERRIDE, AbsenceCertificationsDEO.CERT_EXPIRE_NOTIF_ADMIN, AbsenceCertificationsDEO.CERT_EXPIRE_NOTIF_EMP, AbsenceCertificationsDEO.CERT_EXPIRE_NOTIF_MGR, AbsenceCertificationsDEO.CERT_EXPIRE_UPDATE_CD, AbsenceCertificationsDEO.CERT_MANAGER_UPLOAD, AbsenceCertificationsDEO.CERT_MANAGER_USE_CD, AbsenceCertificationsTransla1.NAME, AbsenceCertificationsDEO.CERT_USE_CD, AbsenceCertificationsDEO.CERT_STATUS_CD, AbsenceCertificationsDEO.CERT_TRIGGER_CD, AbsenceCertificationsDEO.CREATED_BY, AbsenceCertificationsDEO.CREATION_DATE, AbsenceCertificationsDEO.DUE_DATE_REFERENCE_DATE_CD, AbsenceCertificationsDEO.DUE_DATE_TYPE_CD, AbsenceCertificationsDEO.DUE_DATE_UNITS, AbsenceCertificationsDEO.DUE_DATE_UOM_CD, AbsenceCertificationsDEO.EFFECTIVE_END_DATE, AbsenceCertificationsDEO.EFFECTIVE_START_DATE, AbsenceCertificationsDEO.ENTERPRISE_ID, AbsenceCertificationsDEO.LAST_UPDATE_DATE, AbsenceCertificationsDEO.LAST_UPDATE_LOGIN, AbsenceCertificationsDEO.LAST_UPDATED_BY, AbsenceCertificationsDEO.OBJECT_VERSION_NUMBER, AbsenceCertificationsDEO.UPDATE_ABSENCE_ENTRY, AbsenceCertificationsTransla1.ABSENCE_CERTIFICATION_DESC, AbsenceCertificationsTransla1.LANGUAGE, AbsenceCertificationsTransla1.SOURCE_LANG, AbsenceCertificationsDEO.DOCUMENT_TYPE_ID, AbsenceCertificationsDEO.MANAGEMENT_TYPE_CD, AbsenceCertificationsDEO.CONFIRM_ON_DEMAND, AbsenceCertificationsDEO.ALLOW_ON_DEMAND, AbsenceCertificationsDEO.CNFM_RSN_RULE, AbsenceCertificationsDEO.CNFM_RSN_VALUES, AbsenceCertificationsDEO.EXPIRY_RULE, AbsenceCertificationsDEO.EXPIRY_REF_DATE, AbsenceCertificationsDEO.EXPIRY_UOM, AbsenceCertificationsDEO.VOID_RSN_RULE, AbsenceCertificationsDEO.VOID_RSN_VALUES, AbsenceCertificationsDEO.EXPIRY_DURATION, AbsenceCertificationsDEO.ELIG_PROFILE_ID, AbsenceCertificationsDEO.SGUID SGUID, AbsenceCertificationsDEO.BASE_NAME FROM ANC_ABS_CERTIFICATIONS_F AbsenceCertificationsDEO, ANC_ABS_CERTIFICATIONS_F_TL AbsenceCertificationsTransla1 WHERE AbsenceCertificationsDEO.ABSENCE_CERTIFICATION_ID = AbsenceCertificationsTransla1.ABSENCE_CERTIFICATION_ID AND AbsenceCertificationsDEO.EFFECTIVE_END_DATE = AbsenceCertificationsTransla1.EFFECTIVE_END_DATE AND AbsenceCertificationsDEO.EFFECTIVE_START_DATE = AbsenceCertificationsTransla1.EFFECTIVE_START_DATE AND AbsenceCertificationsTransla1.LANGUAGE = SYS_CONTEXT('USERENV', 'LANG')

SQL_Statement

SELECT

AbsenceCertificationsDEO.ABSENCE_CERTIFICATION_ID,

AbsenceCertificationsDEO.ANC_ABS_CERTIFICATION_F_ALTCD,

AbsenceCertificationsDEO.AUTO_COMPLETE_FLAG,

AbsenceCertificationsDEO.LEGISLATION_CODE,

AbsenceCertificationsDEO.CERT_ADMIN_UPLOAD,

AbsenceCertificationsDEO.CERT_COMPLETE_CALC_CD,

AbsenceCertificationsDEO.CERT_COMPLETE_CALC_MODE_CD,

AbsenceCertificationsDEO.CERT_COMPLETE_CALC_OVERRIDE,

AbsenceCertificationsDEO.CERT_COMPLETE_NOTIF_ADMIN,

AbsenceCertificationsDEO.CERT_COMPLETE_NOTIF_EMP,

AbsenceCertificationsDEO.CERT_COMPLETE_NOTIF_MGR,

AbsenceCertificationsDEO.CERT_COMPLETE_UPDATE_CD,

AbsenceCertificationsDEO.CERT_CREATE_CALC_CD,

AbsenceCertificationsDEO.CERT_CREATE_CALC_MODE_CD,

AbsenceCertificationsDEO.CERT_CREATE_CALC_OVERRIDE,

AbsenceCertificationsDEO.CERT_CREATE_NOTIF_ADMIN,

AbsenceCertificationsDEO.CERT_CREATE_NOTIF_EMP,

AbsenceCertificationsDEO.CERT_CREATE_NOTIF_MGR,

AbsenceCertificationsDEO.CERT_CREATE_UPDATE_CD,

AbsenceCertificationsDEO.CERT_DUE_DATE_CALC_CD,

AbsenceCertificationsDEO.CERT_DUE_DATE_CALC_MODE_CD,

AbsenceCertificationsDEO.CERT_DUE_DATE_CALC_OVERRIDE,

AbsenceCertificationsDEO.CERT_DUE_DATE_NOTIF_ADMIN,

AbsenceCertificationsDEO.CERT_DUE_DATE_NOTIF_EMP,

AbsenceCertificationsDEO.CERT_DUE_DATE_NOTIF_MGR,

AbsenceCertificationsDEO.CERT_DUE_DATE_UPDATE_CD,

AbsenceCertificationsDEO.CERT_EMPLOYEE_UPLOAD,

AbsenceCertificationsDEO.CERT_EMPLOYEE_USE_CD,

AbsenceCertificationsDEO.CERT_EXPIRE_CALC_CD,

AbsenceCertificationsDEO.CERT_EXPIRE_CALC_MODE_CD,

AbsenceCertificationsDEO.CERT_EXPIRE_CALC_OVERRIDE,

AbsenceCertificationsDEO.CERT_EXPIRE_NOTIF_ADMIN,

AbsenceCertificationsDEO.CERT_EXPIRE_NOTIF_EMP,

AbsenceCertificationsDEO.CERT_EXPIRE_NOTIF_MGR,

AbsenceCertificationsDEO.CERT_EXPIRE_UPDATE_CD,

AbsenceCertificationsDEO.CERT_MANAGER_UPLOAD,

AbsenceCertificationsDEO.CERT_MANAGER_USE_CD,

AbsenceCertificationsTransla1.NAME,

AbsenceCertificationsDEO.CERT_USE_CD,

AbsenceCertificationsDEO.CERT_STATUS_CD,

AbsenceCertificationsDEO.CERT_TRIGGER_CD,

AbsenceCertificationsDEO.CREATED_BY,

AbsenceCertificationsDEO.CREATION_DATE,

AbsenceCertificationsDEO.DUE_DATE_REFERENCE_DATE_CD,

AbsenceCertificationsDEO.DUE_DATE_TYPE_CD,

AbsenceCertificationsDEO.DUE_DATE_UNITS,

AbsenceCertificationsDEO.DUE_DATE_UOM_CD,

AbsenceCertificationsDEO.EFFECTIVE_END_DATE,

AbsenceCertificationsDEO.EFFECTIVE_START_DATE,

AbsenceCertificationsDEO.ENTERPRISE_ID,

AbsenceCertificationsDEO.LAST_UPDATE_DATE,

AbsenceCertificationsDEO.LAST_UPDATE_LOGIN,

AbsenceCertificationsDEO.LAST_UPDATED_BY,

AbsenceCertificationsDEO.OBJECT_VERSION_NUMBER,

AbsenceCertificationsDEO.UPDATE_ABSENCE_ENTRY,

AbsenceCertificationsTransla1.ABSENCE_CERTIFICATION_DESC,

AbsenceCertificationsTransla1.LANGUAGE,

AbsenceCertificationsTransla1.SOURCE_LANG,

AbsenceCertificationsDEO.DOCUMENT_TYPE_ID,

AbsenceCertificationsDEO.MANAGEMENT_TYPE_CD,

AbsenceCertificationsDEO.CONFIRM_ON_DEMAND,

AbsenceCertificationsDEO.ALLOW_ON_DEMAND,

AbsenceCertificationsDEO.CNFM_RSN_RULE,

AbsenceCertificationsDEO.CNFM_RSN_VALUES,

AbsenceCertificationsDEO.EXPIRY_RULE,

AbsenceCertificationsDEO.EXPIRY_REF_DATE,

AbsenceCertificationsDEO.EXPIRY_UOM,

AbsenceCertificationsDEO.VOID_RSN_RULE,

AbsenceCertificationsDEO.VOID_RSN_VALUES,

AbsenceCertificationsDEO.EXPIRY_DURATION,

AbsenceCertificationsDEO.ELIG_PROFILE_ID,

AbsenceCertificationsDEO.SGUID SGUID,

AbsenceCertificationsDEO.BASE_NAME

FROM

ANC_ABS_CERTIFICATIONS_F AbsenceCertificationsDEO,

ANC_ABS_CERTIFICATIONS_F_TL AbsenceCertificationsTransla1

WHERE

AbsenceCertificationsDEO.ABSENCE_CERTIFICATION_ID = AbsenceCertificationsTransla1.ABSENCE_CERTIFICATION_ID AND AbsenceCertificationsDEO.EFFECTIVE_END_DATE = AbsenceCertificationsTransla1.EFFECTIVE_END_DATE AND AbsenceCertificationsDEO.EFFECTIVE_START_DATE = AbsenceCertificationsTransla1.EFFECTIVE_START_DATE AND AbsenceCertificationsTransla1.LANGUAGE = SYS_CONTEXT('USERENV', 'LANG')