機械翻訳について

PO_BUYERS_VAL_V

詳細

• スキーマ: FUSION

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

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

列

名前
FULL_NAME EMPLOYEE_NUMBER PERSON_ID LOCATION_ID DISPLAY_NAME LAST_NAME FIRST_NAME WORK_TELEPHONE EMAIL_ADDRESS BUSINESS_GROUP_ID

問合せ

SQL_Statement
SELECT FULL_NAME, null EMPLOYEE_NUMBER, PERSON_ID, null LOCATION_ID, DISPLAY_NAME, LAST_NAME, FIRST_NAME, null WORK_TELEPHONE, null EMAIL_ADDRESS, null BUSINESS_GROUP_ID FROM PER_PERSON_NAMES_F_V WHERE trunc(sysdate) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE