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

VIEW: APPS.HR_EMPLOYEES_CURRENT_V

Object Details
Object Name: HR_EMPLOYEES_CURRENT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.HR_EMPLOYEES_CURRENT_V
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
BUSINESS_GROUP_ID NUMBER (15) Yes Business group unique identifier
ORGANIZATION_ID NUMBER (15) Yes Organization unique identifier
EMPLOYEE_ID NUMBER (10) Yes Employee unique identifier
ASSIGNMENT_ID NUMBER (10) Yes Assignment 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 for the employee
FULL_NAME VARCHAR2 (240)
Full concatenated name for the employee
FIRST_NAME VARCHAR2 (150)
First name for the employee
MIDDLE_NAME VARCHAR2 (60)
Middle names of the employee
LAST_NAME VARCHAR2 (150) Yes Last name for the employee
PREFIX VARCHAR2 (30)
Prefix for the employee
LOCATION_ID NUMBER (15)
Location unique identifier
SUPERVISOR_ID NUMBER (10)
Supervisor of the employee unique identifier
SET_OF_BOOKS_ID NUMBER (15)
Set of Books unique identifier
DEFAULT_CODE_COMBINATION_ID NUMBER (15)
Accounting Flexfield unique identifier
EXPENSE_CHECK_ADDRESS_FLAG VARCHAR2 (30)
Indicates where employee expense reports checks should be sent
EMAIL_ADDRESS VARCHAR2 (240)
Electronic mail address of employee
WORK_TELEPHONE VARCHAR2 (4000)
INACTIVE_DATE VARCHAR2 (0)
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 BUSINESS_GROUP_ID
,      ORGANIZATION_ID
,      EMPLOYEE_ID
,      ASSIGNMENT_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
,      LOCATION_ID
,      SUPERVISOR_ID
,      SET_OF_BOOKS_ID
,      DEFAULT_CODE_COMBINATION_ID
,      EXPENSE_CHECK_ADDRESS_FLAG
,      EMAIL_ADDRESS
,      WORK_TELEPHONE
,      INACTIVE_DATE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE_CATEGORY
,      PBG_NAME
FROM APPS.HR_EMPLOYEES_CURRENT_V;

Dependencies

[top of page]

APPS.HR_EMPLOYEES_CURRENT_V references the following:

SchemaAPPS
SynonymFINANCIALS_SYSTEM_PARAMETERS
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
ViewPER_BUSINESS_GROUPS_PERF
ViewPER_PEOPLE_F
APPS.HR_EMPLOYEES_CURRENT_V is referenced by following:

SchemaAPPS
PL/SQL PackageAP_CARD_DATABASE_PKG - show dependent code
Package BodyAP_CARD_DATABASE_PKG - show dependent code
Package BodyAP_CARD_VALIDATE_PKG - show dependent code
ViewAP_EXPENSE_FEED_DISTS_OPEN_V
ViewAP_EXPENSE_FEED_DISTS_V
ViewAP_EXPENSE_FEED_LINES_V
Package BodyAP_IMPORT_VALIDATION_PKG - show dependent code
Package BodyAP_VENDOR_PUB_PKG - show dependent code
PL/SQL PackageAP_WEB_AUDIT_UTILS - show dependent code
Package BodyAP_WEB_AUDIT_UTILS - show dependent code
Package BodyAP_WEB_DB_AP_INT_PKG - show dependent code
Package BodyAP_WEB_DB_EXPRPT_PKG - show dependent code
PL/SQL PackageAP_WEB_DB_EXPRPT_PKG - show dependent code
Package BodyAP_WEB_DB_HR_INT_PKG - show dependent code
PL/SQL PackageAP_WEB_DB_HR_INT_PKG - show dependent code
Package BodyAP_WEB_DB_USER_PREF_PKG - show dependent code
PL/SQL PackageAP_WEB_DB_USER_PREF_PKG - show dependent code
Package BodyAP_WEB_EXPENSE_WF - show dependent code
PL/SQL PackageAP_WEB_EXPENSE_WF - show dependent code
Package BodyAP_WEB_INACTIVE_EMP_WF_PKG - show dependent code
Package BodyAP_WEB_OA_DISC_PKG - show dependent code
PL/SQL PackageAP_WEB_OA_MAINFLOW_PKG - show dependent code
Package BodyAP_WEB_OA_MAINFLOW_PKG - show dependent code
Package BodyAP_WEB_PARENT_PKG - show dependent code
Package BodyAP_WEB_PCARD_WORKFLOW_PKG - show dependent code
Package BodyAP_WEB_VALIDATE_UTIL - show dependent code
ViewCHV_OWNERS_ALL_V
ViewCHV_PLANNERS_ALL_V
ViewCHV_PLANNERS_VAL_V
ViewCHV_SCHEDULERS_ALL_V
ViewCHV_SCHEDULERS_VAL_V
Package BodyICX_LOAD_REQ_INTERFACE - show dependent code
ViewICX_PO_APPROVER_VAL_V
ViewICX_PO_REQUESTOR_VAL_V
Package BodyICX_PO_REQ_ACCT2 - show dependent code
Package BodyICX_REQ_ACCT2 - show dependent code
Package BodyICX_REQ_ACCT_DIST - show dependent code
Package BodyICX_REQ_NAVIGATION - show dependent code
Package BodyICX_REQ_ORDER - show dependent code
Package BodyICX_REQ_SUBMIT - show dependent code
Package BodyMRP_RELEASE_PK - show dependent code
Package BodyOE_PURCHASE_RELEASE_PVT - show dependent code
Package BodyPA_COMP_PROFILE_PVT - show dependent code
Package BodyPOREQ - show dependent code
ViewPOR_LOCATION_LOV_V
ViewPOR_PREPARER_LOV_V
ViewPOR_RCV_REQ_LOV_V
Package BodyPOR_RCV_TRANSACTION_SV - show dependent code
ViewPOR_RECEIVE_ORDERS_V
ViewPOR_REQUESTER_LOV_V
ViewPOR_VIEW_LINE_DETAILS_V
ViewPOR_VIEW_REQS_BY_APPROVER_V
ViewPOR_VIEW_REQS_BY_GROUP_V
Package BodyPOS_CHANGE_PROM_DATES - show dependent code
Package BodyPO_ACTION_HISTORY_SV - show dependent code
ViewPO_ALERT_BLANKET_VIEW
ViewPO_ALERT_CONTRACT_VIEW
ViewPO_ALERT_PLANNED_VIEW
Package BodyPO_APPROVALLIST_S1 - show dependent code
Package BodyPO_CHANGEORDERWF_PVT - show dependent code
Package BodyPO_COPYDOC_SUB - show dependent code
Package BodyPO_DIFF_SUMMARY_PKG - show dependent code
Package BodyPO_FORWARD_SV1 - show dependent code
ViewPO_NOTIFICATION_DETAILS_V
Package BodyPO_PDOI_DISTRIBUTIONS_SV3 - show dependent code
ViewPO_REQUESTOR_LOCATIONS_V
Package BodyQA_SOLUTION_CAR_PKG - show dependent code
Package BodyQLTDACTB - show dependent code
Package BodyRCV_CORE_S - show dependent code
Package BodyRCV_INT_ORDER_PP_PVT - show dependent code
Package BodyRCV_INT_ORG_TRANSFER - show dependent code
Package BodyRCV_ROI_TRANSACTION - show dependent code
Package BodyRCV_TRANSACTIONS_INTERFACE_SV - show dependent code
Package BodyRCV_TRANSACTIONS_INTERFACE_SV1 - show dependent code
Package BodyRCV_TRANSACTIONS_SV - show dependent code
Package BodyRCV_TRANSACTION_SV - show dependent code
SchemaPUBLIC
SynonymHR_EMPLOYEES_CURRENT_V