DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.HR_EMPLOYEES

Object Details
Object Name: HR_EMPLOYEES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.HR_EMPLOYEES
Subobject Name:
Status: VALID

View Type

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.

[View Source]

Columns
Name Datatype Length Mandatory Comments
EMPLOYEE_ID NUMBER (10) Yes Employee unique identifier
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
EMPLOYEE_NUM VARCHAR2 (30)
Number of the employee
FULL_NAME VARCHAR2 (240)
Full concatenated name of the employee
FIRST_NAME VARCHAR2 (150)
First name of the employee
MIDDLE_NAME VARCHAR2 (60)
Middle names of the employee
LAST_NAME VARCHAR2 (150) Yes Last name of the employee
PREFIX VARCHAR2 (30)
Prefix for the employee
EXPENSE_CHECK_ADDRESS_FLAG VARCHAR2 (30)
Indicates where employee expense reports checks should be sent
EMAIL_ADDRESS VARCHAR2 (240)
Electronic mail address of employee
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
PBG.NAME VARCHAR2 (240) Yes
Query Text

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


SELECT EMPLOYEE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      EMPLOYEE_NUM
,      FULL_NAME
,      FIRST_NAME
,      MIDDLE_NAME
,      LAST_NAME
,      PREFIX
,      EXPENSE_CHECK_ADDRESS_FLAG
,      EMAIL_ADDRESS
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE_CATEGORY
,      PBG.NAME
FROM APPS.HR_EMPLOYEES;

Dependencies

[top of page]

APPS.HR_EMPLOYEES references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewPER_ASSIGNMENTS_F
SynonymPER_ASSIGNMENT_STATUS_TYPES
ViewPER_BUSINESS_GROUPS_PERF
ViewPER_PEOPLE_F
APPS.HR_EMPLOYEES is referenced by following:

SchemaAPPS
Package BodyAP_VENDORS_PKG - show dependent code
Package BodyAP_WEB_DISC_PKG - show dependent code
Package BodyAP_WEB_PROXY_ASSIGN_PKG - show dependent code
PL/SQL PackageAP_WEB_UTILITIES_PKG - show dependent code
Package BodyAP_WEB_UTILITIES_PKG - show dependent code
ViewCHV_CUM_ITEMS_HISTORY_V
ViewCHV_RECEIVING_TRANSACTIONS_V
ViewCHV_SCHEDULE_HEADERS_V
ViewCSC_CUSTOMERS_AUDIT_HIST_V
ViewCSI_CONTACTS_V
ViewCST_XLA_HR_EMPLOYEE_REF_V
ViewCS_IB_EMPLOYEES_V
ViewCS_IB_W_EMPLOYEES_V
ViewENGBV_ENG_CHANGE_APPROVERS
ViewENGFV_ENG_CHANGE_APPROVERS
Package BodyGMPMPACT - show dependent code
ViewHR_EMPLOYEES_ALL_V
ViewICX_EDM_PURCHASE_REQ_V
ViewICX_PLAN_SCHEDULE_HEADERS_V
ViewICX_PO_REQUISITION_HEADERS_V
ViewICX_PO_REQ_HEADERS_V
ViewICX_RCV_ACCEPTED_ITEMS_V
ViewICX_RCV_EARLY_LATE_RECEIPTS_V
ViewICX_RCV_REJECTED_ITEMS_V
ViewICX_RCV_RETURNS_V
ViewICX_RCV_TRANSACTIONS_V
ViewICX_RECEIPT_HEADERS_V
ViewICX_SHIP_SCHEDULE_HEADERS_V
ViewIGC_CC_HEADER_VERSION_V
ViewIGI_SAP_DEPT_APPROVERS_V
ViewIGI_SAP_INVOICE_CLERK_V
ViewIGI_SIA_DEPT_APPROVER_RG
ViewIGI_SIA_INVOICE_CLERK_RG
ViewINVFV_CYCLE_COUNT_ADJUSTMENTS
Package BodyINV_LABEL_PVT1 - show dependent code
Package BodyJMF_SHIKYU_RPT_SPR_PVT - show dependent code
Package BodyNTN - show dependent code
ViewPOA_CM_EVALUATED_BY_LOV_V
ViewPOR_HEADER_V
Package BodyPOR_HISTORY_FEED_PKG - show dependent code
ViewPOS_ACK_SELECT_V
ViewPO_DISTS_REF_V
ViewPO_HEADERS_CHANGE_PRINT
ViewPO_HEADERS_PRINT
ViewPO_HEADERS_REF_V
Package BodyPO_LINE_LOCATIONS_AP_PKG - show dependent code
Package BodyPO_NOTIFICATIONS_SV3 - show dependent code
ViewPO_QUOTATION_APPROVALS_V
ViewPO_RELEASE_TRANSACTION_V
ViewPO_REQS_IN_TRANSIT_ALL_V
ViewPO_REQ_DISTS_REF_V
ViewPO_REQ_HEADERS_REF_V
ViewPO_REQ_LINES_REF_V
ViewPO_REQ_TRANSACTION_V
ViewPO_RFQ_HEADERS_PRINT
ViewPO_TRANSACTION_V
Package BodyRCV_DEFAULT_PKG - show dependent code
PL/SQL PackageRCV_ROI_PREPROCESSOR - show dependent code
PL/SQL PackageRCV_SHIPMENT_OBJECT_SV - show dependent code
Package BodyRCV_TRANSACTION_SV - show dependent code
Package BodyWSH_WSHRDPAK_XMLP_PKG - show dependent code
SchemaPUBLIC
SynonymHR_EMPLOYEES