[Home] [Help]
[Dependency Information]
| Object Name: | PER_PEOPLE_X |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | PER.PER_PEOPLE_X
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, PERSON_TYPE_ID
, LAST_NAME
, START_DATE
, APPLICANT_NUMBER
, COMMENT_ID
, CURRENT_APPLICANT_FLAG
, CURRENT_EMP_OR_APL_FLAG
, CURRENT_EMPLOYEE_FLAG
, DATE_EMPLOYEE_DATA_VERIFIED
, DATE_OF_BIRTH
, EMAIL_ADDRESS
, EMPLOYEE_NUMBER
, EXPENSE_CHECK_SEND_TO_ADDRESS
, FIRST_NAME
, FULL_NAME
, KNOWN_AS
, MARITAL_STATUS
, MIDDLE_NAMES
, NATIONALITY
, NATIONAL_IDENTIFIER
, PREVIOUS_LAST_NAME
, REGISTERED_DISABLED_FLAG
, SEX
, TITLE
, VENDOR_ID
, WORK_TELEPHONE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, PER_INFORMATION_CATEGORY
, PER_INFORMATION1
, PER_INFORMATION2
, PER_INFORMATION3
, PER_INFORMATION4
, PER_INFORMATION5
, PER_INFORMATION6
, PER_INFORMATION7
, PER_INFORMATION8
, PER_INFORMATION9
, PER_INFORMATION10
, PER_INFORMATION11
, PER_INFORMATION12
, PER_INFORMATION13
, PER_INFORMATION14
, PER_INFORMATION15
, PER_INFORMATION16
, PER_INFORMATION17
, PER_INFORMATION18
, PER_INFORMATION19
, PER_INFORMATION20
, PER_INFORMATION21
, PER_INFORMATION22
, PER_INFORMATION23
, PER_INFORMATION24
, PER_INFORMATION25
, PER_INFORMATION26
, PER_INFORMATION27
, PER_INFORMATION28
, PER_INFORMATION29
, PER_INFORMATION30
, SUFFIX
, OBJECT_VERSION_NUMBER
, WORK_SCHEDULE
, CORRESPONDENCE_LANGUAGE
, STUDENT_STATUS
, FTE_CAPACITY
, ON_MILITARY_SERVICE
, SECOND_PASSPORT_EXISTS
, BACKGROUND_CHECK_STATUS
, BACKGROUND_DATE_CHECK
, BLOOD_TYPE
, LAST_MEDICAL_TEST_DATE
, LAST_MEDICAL_TEST_BY
, REHIRE_RECOMMENDATION
, REHIRE_AUTHORIZOR
, REHIRE_REASON
, RESUME_EXISTS
, RESUME_LAST_UPDATED
, OFFICE_NUMBER
, INTERNAL_LOCATION
, MAILSTOP
, PROJECTED_START_DATE
, HONORS
, PRE_NAME_ADJUNCT
, HOLD_APPLICANT_DATE_UNTIL
, COORD_BEN_MED_PLN_NO
, COORD_BEN_NO_CVG_FLAG
, DPDNT_ADOPTION_DATE
, DPDNT_VLNTRY_SVCE_FLAG
, RECEIPT_OF_DEATH_CERT_DATE
, USES_TOBACCO_FLAG
, BENEFIT_GROUP_ID
, ORIGINAL_DATE_OF_HIRE
, TOWN_OF_BIRTH
, REGION_OF_BIRTH
, COUNTRY_OF_BIRTH
, GLOBAL_PERSON_ID
, COORD_BEN_MED_EXT_ER
, COORD_BEN_MED_PL_NAME
, COORD_BEN_MED_INSR_CRR_NAME
, COORD_BEN_MED_INSR_CRR_IDENT
, COORD_BEN_MED_CVG_STRT_DT
, COORD_BEN_MED_CVG_END_DT
, NPW_NUMBER
, CURRENT_NPW_FLAG
, GLOBAL_NAME
, LOCAL_NAME
, LIST_NAME
FROM APPS.PER_PEOPLE_X;
APPS
HR_GENERAL
- show dependent code
HR_PERSON_NAME
- show dependent code
HR_SECURITY
- show dependent code
PER_PEOPLE_F
APPS
AHL_UMP_NONROUTINES_PVT
- show dependent code
AMS_DS_ACCESSES_ALL_V
AMS_DS_GROUP_ACCESSES_ALL_V
AP_CARDS_V
AP_EXPENSE_REPORT_HISTORY_V
AP_NOTES_PVT
- show dependent code
AP_WEB_DB_CCARD_PKG
- show dependent code
AP_WEB_DB_EXPRPT_PKG
- show dependent code
AP_WEB_DB_HR_INT_PKG
- show dependent code
AP_WEB_EXPENSE_CUST_WF
- show dependent code
AP_WEB_EXPENSE_WF
- show dependent code
AP_WEB_POLICY_UTILS
- show dependent code
AST_SALES_GROUP_ADMINS_V
AS_ACCESSES_ACTIVE_V
CS_CORE_UTIL
- show dependent code
CS_INCIDENT_ACTION_AUDIT_V
CS_SERVICEREQUEST_UTIL
- show dependent code
CS_WORKFLOW_PUB
- show dependent code
CUG_GENERIC_WF_PKG
- show dependent code
ENG_ECN_APPROVERS_V
FARX_C_MT
- show dependent code
FA_DISTRIBUTION_HISTORY_V
FA_DISTRIBUTION_HIST_WEB_V
FA_EMPLOYEES
FA_MASS_EXTERNAL_TRANSFERS_V
GHR_PD_COVERSHEET_V
GL_HR_EMPLOYEES_CURRENT_V
GMS_NOTIFICATIONS_V
GMS_PERSONNEL_V
GMS_REPORTS_V
HRBISOFO
- show dependent code
HRFV_ACCRUAL_PLAN_ENROLLMENTS
HRFV_ACCRUAL_VALUES
HRFV_ADA_DISABILITIES
HRFV_ADA_DIS_ACCOMMODATIONS
HRFV_ADDRESSES
HRFV_APPLICANT_DETAILS
HRFV_APPRAISAL_DETAILS
HRFV_ASSIGNMENT_COSTS
HRFV_BENEFIT_ENROLLMENTS
HRFV_COMPETENCE_PROFILES
HRFV_CONTACTS
HRFV_CURRENT_SALARIES
HRFV_DEPLOYMENT_FACTORS
HRFV_DETAILED_SPECIAL_INFO
HRFV_GB_ADDRESSES
HRFV_GB_DIRECT_DEPOSITS
HRFV_GB_LOCATIONS
HRFV_GB_PERSONAL_DETAILS
HRFV_GRADE_HISTORY
HRFV_GRADE_STEP_PLACEMENTS
HRFV_GRD_PLACEMNT_PROG_PT_VALS
HRFV_GRD_STEP_PLACEMNT_HISTORY
HRFV_JOB_APPLICATIONS
HRFV_JOB_HISTORY
HRFV_LOCATIONS
HRFV_LOCATION_HISTORY
HRFV_ORGANIZATION_HISTORY
HRFV_OSHA_REPORTABLE_INCIDENTS
HRFV_PAY_METH_NOT_DIR_DEPOSITS
HRFV_PERSONAL_BACKGROUND_INFO
HRFV_PERSONAL_MEDICAL_INFO
HRFV_PERSONAL_REHIRE_INFO
HRFV_PERSON_AGE_ANALYSIS
HRFV_PERSON_SPECIAL_INFO
HRFV_PHONES
HRFV_POSITION_HISTORY
HRFV_PROBATIONS
HRFV_QUALIFICATIONS
HRFV_REVIEWERS
HRFV_REVIEWS
HRFV_SALARY_COMPONENTS
HRFV_SCHOOL_COLL_ATTENDANCES
HRFV_SUBJECTS
HRFV_SUPERVISORS
HRFV_TIME_IN_SERVICE_ANALYSIS
HRFV_US_ADDRESSES
HRFV_US_DIRECT_DEPOSITS
HRFV_US_LOCATIONS
HRFV_US_PERSONAL_DETAILS
HRIBV_SUPV_HRCHY_ROLLUP_X
HRIBV_SUPV_HRCHY_X
HRI_BPL_DATA_SETUP_DGNSTC
- show dependent code
HRI_CL_PER_APL_BX_V
HRI_CL_PER_EMP_HX_V
HRI_CL_PER_HXN_V
HRI_CL_PER_HX_V
HRI_CL_PER_SUP_HX_V
HRI_CL_PER_USER_HX_V
HRI_OPL_SUPH_HST
- show dependent code
HR_CERIDIAN_500_DEDUCTION_V
HR_CERIDIAN_DEDUCTION_V
HXC_APPROVAL_COMPS_V
HXC_GET_NAME
- show dependent code
HXC_RESOURCE_RULES_PERSON_V
HXC_RESOURCE_RULES_V
IBY_PAYGROUP_PUB
- show dependent code
ICX_INTERNAL_CONTACT_LOV
ICX_PER_PEOPLE_X_V
IGW_ADMIN_OFFICIAL_V
IGW_AWARD_PARTICULARS_PKG
- show dependent code
IGW_ORG_MAP_DETAILS_V
IGW_PI_V
IGW_PROP
- show dependent code
IGW_PROPOSAL_PERSONS_V
IGW_PROP_COMMENTS_V
IGW_PROP_PERSONS_V
IGW_PROP_V
IGW_PRPO_OTHER_SUPPORT_V
IGW_PRPO_PROP_PERSONS_V
IGW_REPORT_PROCESSING
- show dependent code
IGW_SIGNING_OFFICIAL_V
IGW_VIEW_PARAMETERS
- show dependent code
INVFV_ITEMS
INVFV_ORGANIZATION_ITEMS
MTL_EMPLOYEES_CURRENT_VIEW
MTL_EMPLOYEES_VIEW
OIE_MGR_RPT_V
PA_BUDGET_PUB
- show dependent code
PA_CANDIDATE_REVIEWS_V
PA_CANDIDATE_UTILS
- show dependent code
PA_COMP_PROFILE_PUB
- show dependent code
PA_COMP_PROFILE_PVT
- show dependent code
PA_FIN_PLAN_UTILS
- show dependent code
PA_FP_CI_IMPLEMENT_PKG
- show dependent code
PA_MANAGERS_V
PA_PLANNING_RESOURCE_PVT
- show dependent code
PA_PLANNING_RESOURCE_UTILS
- show dependent code
PA_PROJECT_ASSETS_PUB
- show dependent code
PA_PROJ_MANAGER_V
PA_RBS_ELEMENTS_PVT
- show dependent code
PA_REP_PROJ_REQHRS_GLD_V
PA_REP_PROJ_REQHRS_GL_V
PA_REP_PROJ_REQHRS_PAD_V
PA_REP_PROJ_REQHRS_PA_V
PA_REP_PROJ_REQHRS_WKD_V
PA_REP_PROJ_REQHRS_WK_V
PA_REP_RES_SCHHRS_GLD_V
PA_REP_RES_SCHHRS_PAD_V
PA_REP_RES_SCHHRS_WKD_V
PA_RESOURCE_AUTHORITY_V
POS_AP_EXPENSE_REPORTS_V
POS_PER_PEOPLE_X_V
PQH_ROLE_PEOPLE_V
PSP_PSPDAREG_XMLP_PKG
- show dependent code
PUBLIC
PER_PEOPLE_X
|
|
|
|