Results for “position_definition_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
HRI_CL_POSITION_HX_V is a read-only view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the HRI (Human Resources Intelligence) product family. It exposes a flattened, denormalized representation of position records drawn from the PER_POSITIONS view, presenting each position as an ID/VALUE pair with effective-dating attributes and key foreign key references. Its principal role is to support Human Resources Intelligence reporting, dimensional modeling, and lookup/LOV-style integrations where a compact, current set of positions is required.
The view is defined with the WITH READ ONLY clause, so it can be queried but not modified. It is a common reference point for ETRM users searching on POSITION_DEFINITION_ID, since the view surfaces that column directly alongside the position identifier, business group, organization, and job context.
Underlying Base Objects
The ETRM 12.2.2 metadata documents the following referenced base objects for this view: HR_BIS (PACKAGE), HR_GENERAL (PACKAGE), HR_SECURITY (PACKAGE), PER_POSITIONS (VIEW), and DUAL (SYNONYM).
- PER_POSITIONS — the primary source. The view selects POSITION_ID, NAME, DATE_EFFECTIVE, DATE_END, BUSINESS_GROUP_ID, ORGANIZATION_ID, JOB_ID, and POSITION_DEFINITION_ID from this view.
- HR_GENERAL — supplies the sentinel constants
END_OF_TIMEandSTART_OF_TIMEused in the NVL for DATE_TO and in the UNION ALL placeholder row. - HR_SECURITY and HR_BIS — HR security and business intelligence packages referenced by the underlying HR data model, supporting row-level security and BI extraction semantics.
- DUAL — used to construct a synthetic "no selection" row (ID = -1) via UNION ALL.
Key Columns
- ID — the position identifier (POS.POSITION_ID); the -1 placeholder row represents an unselected/none value.
- VALUE — the position name (POS.NAME), used as the display value.
- DATE_FROM — the position's date effective (POS.DATE_EFFECTIVE).
- DATE_TO — the position's date end, defaulted to HR_GENERAL.END_OF_TIME when null.
- BUSINESS_GROUP_ID — business group owning the position.
- ORGANIZATION_ID — organization associated with the position.
- JOB_ID — job linked to the position.
- POSITION_DEFINITION_ID — identifier of the position definition record associated with the position; this is the column most frequently referenced in user searches.
Common Use Cases and Queries
The view is typically used for current-position LOVs, HR intelligence extracts, and joins that need position name plus definition context. Because the WHERE clause restricts rows to those whose DATE_END is null or in the future (TRUNC(SYSDATE) <= NVL(DATE_END, END_OF_TIME)), only active/current positions are returned.
List all current positions:
SELECT id, value, position_definition_id FROM apps.hri_cl_position_hx_v WHERE id > 0 ORDER BY value;
Filter by position definition:
SELECT id, value, job_id, organization_id FROM apps.hri_cl_position_hx_v WHERE position_definition_id = :p_def_id;
Join to a business group context:
SELECT p.id, p.value, p.job_id FROM apps.hri_cl_position_hx_v p WHERE p.business_group_id = :p_bg_id AND p.id > 0;
The synthetic ID = -1 row is provided for LOV implementations that require a null/none selection, and should generally be excluded in analytical queries by filtering id > 0.
-
View: HRI_CL_POSITION_HX_V 12.2.2
APPS.HRI_CL_POSITION_HX_V·↳ HR_BIS·↳ HR_GENERAL·↳ HR_SECURITY·Explore HRI module →
-
View: HRI_CL_POSITION_HX_V 12.1.1
APPS.HRI_CL_POSITION_HX_V·↳ HR_BIS·↳ HR_GENERAL·↳ HR_SECURITY·Explore HRI module →
-
View: PSB_SELECT_POSITIONS_V 12.1.1
APPS.PSB_SELECT_POSITIONS_V·↳ PSB_POSITIONS·↳ PSB_POSITIONS_PVT·Explore PSB module →
-
APPS.PSB_WS_SELECT_POSITIONS_V·↳ PSB_POSITIONS·↳ PSB_POSITIONS_PVT·↳ PSB_WORKSHEETS·Explore PSB module →
-
View: HR_POSITIONS_LOV_V 12.2.2
Used to get list of value on Mass Move form.
APPS.HR_POSITIONS_LOV_V·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_POSITIONS·Explore PER module →
-
View: PER_POSITIONS_LOV_V 12.2.2
Used to support user interface
APPS.PER_POSITIONS_LOV_V·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_POSITIONS·Explore PER module →
-
View: PER_POSITIONS_LOV_V 12.1.1
Used to support user interface
APPS.PER_POSITIONS_LOV_V·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_POSITIONS·Explore PER module →
-
View: HR_POSITIONS_LOV_V 12.1.1
Used to get list of value on Mass Move form.
APPS.HR_POSITIONS_LOV_V·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_POSITIONS·Explore PER module →
-
Dual-maintained position definition information.
-
View: HRFV_POSITIONS 12.2.2
Business view template from which the flexfield view is generated.
APPS.HRFV_POSITIONS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_ALL_POSITIONS_F_TL·↳ HR_BIS·Explore PER module →
-
View: HR_POSITIONS 12.1.1
Date-effective view based on secured positions view.
APPS.HR_POSITIONS·↳ FND_PROFILE·↳ FND_SESSIONS·↳ HR_GENERAL·Explore PER module →
-
APPS.EDW_HR_PSTN_POSITION_LCV·↳ EDWBV_HR_PSTN_POSITION_LCV·↳ HR_GENERAL·Explore HRI module →
-
View: PER_MM_POSITIONS_V 12.1.1
Used to support user interface
APPS.PER_MM_POSITIONS_V·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·Explore PER module →
-
10sc only
APPS.PSB_POSITION_DEFINITIONS_KFV·↳ PSB_POSITION_DEFINITIONS·Explore PSB module →
-
View: PER_EXPANDED_POSITIONS 12.2.2
Used to support user interface
APPS.PER_EXPANDED_POSITIONS·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_POSITIONS_F·Explore PER module →
-
Combinations of segments stored in the PER_POSTIONS table.
-
Combinations of segments stored in the PER_POSTIONS table.
-
View: GHR_POSITIONS_H_V 12.1.1
Mapping of GHR_PA_HISTORY columns to HR_ALL_POSITIONS_F.
APPS.GHR_POSITIONS_H_V·↳ FND_DATE·↳ GHR_GENERAL·↳ GHR_PA_HISTORY·Explore GHR module →
-
This views is used by mass transfer in and out processes for datatransfer.
APPS.GHR_MT_POSITION_DEFINITIONS_V·↳ GHR_INTERFACE·Explore GHR module →
-
This views is used by mass transfer in and out processes for datatransfer.
APPS.GHR_MT_POSITION_DEFINITIONS_V·↳ GHR_INTERFACE·Explore GHR module →
-
View: PER_APP_ASGS_V 12.1.1
Used to support user interface
APPS.PER_APP_ASGS_V·↳ FND_SESSIONS·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL_TL·Explore PER module →
-
View: PER_ASSIGNMENTS_V10 12.2.2
Used to support user interface.
APPS.PER_ASSIGNMENTS_V10·↳ FND_SESSIONS·↳ HR_ALL_POSITIONS_F_TL·↳ HR_GENERAL·Explore PER module →
-
View: PER_ASSIGNMENTS_V10 12.1.1
Used to support user interface.
APPS.PER_ASSIGNMENTS_V10·↳ FND_SESSIONS·↳ HR_ALL_POSITIONS_F_TL·↳ HR_GENERAL·Explore PER module →
-
View: HR_POSITIONS_X 12.1.1
Date-effective view based on secured positions view.
APPS.HR_POSITIONS_X·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_POSITIONS_F·Explore PER module →
-
View: HRFV_POSITIONS 12.1.1
Business view template from which the flexfield view is generated.
APPS.HRFV_POSITIONS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_ALL_POSITIONS_F_TL·↳ HR_BIS·Explore PER module →
-
View: HR_POSITIONS_F 12.1.1
Secure view based on the corresponding _ALL_ table.
APPS.HR_POSITIONS_F·↳ FND_PROFILE·↳ HR_ALL_POSITIONS_F·↳ HR_ALL_POSITIONS_F_TL·Explore PER module →
-
View: PER_APP_ASGS_V 12.2.2
Used to support user interface
APPS.PER_APP_ASGS_V·↳ FND_SESSIONS·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL_TL·Explore PER module →
-
Position definition
-
APPS.EDWBV_HR_PSTN_POSITION_LCV·↳ EDW_LOCAL_INSTANCE·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore HRI module →
-
Dual-maintained position definition information.
-
View: PSB_POSITIONS_V 12.1.1
APPS.PSB_POSITIONS_V·↳ GL_SETS_OF_BOOKS·↳ PSB_DATA_EXTRACTS·↳ PSB_POSITIONS·Explore PSB module →
-
View: HR_POSITIONS 12.2.2
Date-effective view based on secured positions view.
APPS.HR_POSITIONS·↳ FND_PROFILE·↳ FND_SESSIONS·↳ HR_GENERAL·Explore PER module →
-
View: HR_ALL_POSITIONS_F_VL 12.1.1
APPS.HR_ALL_POSITIONS_F_VL·↳ HR_ALL_POSITIONS_F·↳ HR_ALL_POSITIONS_F_TL·Explore PER module →
-
View: PER_MM_POSITIONS_V 12.2.2
Used to support user interface
APPS.PER_MM_POSITIONS_V·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·Explore PER module →
-
Position key flexfield information
-
View: HR_ALL_POSITIONS_V1 12.1.1
Date-effective view with reduced pl/sql functions for performance.
APPS.HR_ALL_POSITIONS_V1·↳ FND_SESSIONS·↳ HR_ALL_POSITIONS_F·↳ HR_ALL_POSITIONS_F_TL·Explore PER module →
-
View: PER_EXPANDED_POSITIONS 12.1.1
Used to support user interface
APPS.PER_EXPANDED_POSITIONS·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_POSITIONS_F·Explore PER module →
-
View: HR_POSITION_API_V 12.1.1
APPS.HR_POSITION_API_V·↳ HR_ALL_POSITIONS_F·↳ PER_POSITION_DEFINITIONS·Explore PER module →
-
Used to support user interface
APPS.PER_EXPANDED_POSITIONS_V·↳ FND_SESSIONS·↳ HR_ALL_POSITIONS·↳ HR_GENERAL·Explore PER module →
-
Used to support user interface
APPS.PER_EXPANDED_POSITIONS_V·↳ FND_SESSIONS·↳ HR_ALL_POSITIONS·↳ HR_GENERAL·Explore PER module →
-
View: HR_POSITIONS_F 12.2.2
Secure view based on the corresponding _ALL_ table.
APPS.HR_POSITIONS_F·↳ FND_PROFILE·↳ HR_ALL_POSITIONS_F·↳ HR_ALL_POSITIONS_F_TL·Explore PER module →
-
View: PER_POSITIONS_V 12.1.1
Used to support user interface
APPS.PER_POSITIONS_V·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PER module →
-
View: GHR_MT_POSITIONS_V 12.2.2
This views is used by mass transfer in and out processes for datatransfer.
APPS.GHR_MT_POSITIONS_V·↳ GHR_INTERFACE·Explore GHR module →
-
View: GHR_MT_POSITIONS_V 12.1.1
This views is used by mass transfer in and out processes for datatransfer.
APPS.GHR_MT_POSITIONS_V·↳ GHR_INTERFACE·Explore GHR module →
-
APPS.PQH_POSITION_TRANSACTIONS_V·↳ HR_GENERAL·↳ PQH_POSITION_TRANSACTIONS·↳ PQH_UTILITY·Explore PQH module →
-
POSITION_TRANSACTION is used to maintain and create positions. Each transaction needs to be approved by pre-identified approvers. On approval these transactions are applied to database.Each transaction can have a combination of one or more
-
View: PER_POSITIONS_V 12.2.2
Used to support user interface
APPS.PER_POSITIONS_V·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_ALL_POSITIONS_F_TL·Explore PER module →