[Home] [Help] [Dependency Information]

VIEW: APPS.FA_EMPLOYEES

Object Details

Object Name:	FA_EMPLOYEES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OFA.FA_EMPLOYEES
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

FA_EMPLOYEES is a view of PER_PEOPLE_X that stores information
about your employees and the termination date, if any. Oracle
Assets uses this information for responsibility reporting.
.
Oracle Assets contains a row in this view for each employee name.
You cannot update or insert rows in this view.
You can update and insert rows in PER_PEOPLE_F using the Enter
Employee form.
.
.

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT EMPLOYEE_ID
,      EMPLOYEE_NUMBER
,      NAME
,      ACTUAL_TERMINATION_DATE
FROM APPS.FA_EMPLOYEES;

Dependencies

[top of page]

APPS

HR_GENERAL - show dependent code

HR_PERSON_NAME - show dependent code

HR_SECURITY - show dependent code

PER_PEOPLE_X

PER_PERIODS_OF_SERVICE

APPS

CSI_ASSET_PVT - show dependent code

FAFV_ASSET_ASSIGNS

FA_ASSET_DISTRIBUTION_V

FA_CUA_ASSET_WB_APIS_PKG - show dependent code

FA_CUA_HIERARCHY_PKG - show dependent code

FA_HIERARCHY_DISTRIBUTIONS_V

FA_HR_BATCH_DIST_NEW_V

FA_HR_BATCH_DIST_OLD_V

FA_MASS_REC_UTILS_PKG - show dependent code

FA_MASS_RET_PUB - show dependent code