[Home] [Help]
View: ASO_I_HR_PEOPLE_V
Product: | ASO - Order Capture |
Description: | This view has all columns from PER_ALL_PEOPLE_F which is a DateTracked table holding personal information for employees, applicants and other people. |
Implementation/DBA Data: |
APPS.ASO_I_HR_PEOPLE_V
|
View Text
SELECT PERSON_ID
, LAST_NAME
, FIRST_NAME
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
FROM PER_ALL_PEOPLE_F
Columns
Name |
PERSON_ID |
LAST_NAME |
FIRST_NAME |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |