[Home] [Help]
VIEW: APPS.PER_RECRUITER_LOV_V
Source
View Text - Preformatted
SELECT person_id, full_name, order_Name, employee_number, applicant_number, npw_number, effective_start_date, effective_end_date, business_group_id from per_all_workforce_v
View Text - HTML Formatted
SELECT PERSON_ID
, FULL_NAME
, ORDER_NAME
, EMPLOYEE_NUMBER
, APPLICANT_NUMBER
, NPW_NUMBER
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
FROM PER_ALL_WORKFORCE_V