機械翻訳について

CN_BUSINESS_UNITS_NAMES_X

詳細

• スキーマ: FUSION

• オブジェクト所有者: CN

• オブジェクト・タイプ: VIEW

列

名前
ORGANIZATION_ID NAME LANGUAGE SOURCE_LANG EFFECTIVE_START_DATE EFFECTIVE_END_DATE LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN

問合せ

SQL_Statement

SELECT ORG.ORGANIZATION_ID, ORG.NAME, ORG.LANGUAGE, ORG.SOURCE_LANG, ORG.EFFECTIVE_START_DATE, ORG.EFFECTIVE_END_DATE, ORG.LAST_UPDATE_DATE, ORG.LAST_UPDATED_BY, ORG.CREATION_DATE, ORG.CREATED_BY, ORG.LAST_UPDATE_LOGIN FROM hr_organization_units_f_tl ORG, HR_ORG_UNIT_CLASSIFICATIONS_X CLS WHERE CLS.ORGANIZATION_ID = ORG.ORGANIZATION_ID AND CLS.CLASSIFICATION_CODE = 'FUN_BUSINESS_UNIT' AND TRUNC(SYSDATE) BETWEEN ORG.EFFECTIVE_START_DATE AND ORG.EFFECTIVE_END_DATE