DBA Data[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