PO_BUYERS_VAL_V

Details

• Schema: FUSION

• Object owner: PO

• Object type: VIEW

Columns

Name
FULL_NAME EMPLOYEE_NUMBER PERSON_ID LOCATION_ID DISPLAY_NAME LAST_NAME FIRST_NAME WORK_TELEPHONE EMAIL_ADDRESS BUSINESS_GROUP_ID

Query

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