[Home] [Help]
[Dependency Information]
| Object Name: | EDWBV_HR_PSTN_POSITION_LCV |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | HRI.EDWBV_HR_PSTN_POSITION_LCV
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
A Business Intelligence System view
This view contains
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| POSITION_PK | VARCHAR2 | (71) | ||
| INSTANCE | VARCHAR2 | (30) | ||
| NAME | VARCHAR2 | (513) | ||
| POSITION_DP | VARCHAR2 | (513) | ||
| BUSINESS_GROUP | VARCHAR2 | (240) | Yes | |
| ALL_FK | CHAR | (3) | ||
| ORGANIZATION_ID | NUMBER | (15) | Yes | |
| JOB_ID | NUMBER | (15) | Yes | |
| POSITION_ID | NUMBER | (15) | Yes | |
| POSITION_DEFINITION_ID | NUMBER | (15) | Yes | |
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
| POSITION_FROM_DATE | DATE | Yes | ||
| POSITION_TO_DATE | DATE | |||
| PROBATION_PERIOD | NUMBER | (22) | ||
| REPLACEMENT_REQUIRED | VARCHAR2 | (30) | ||
| TIME_NORMAL_START | VARCHAR2 | (5) | ||
| TIME_NORMAL_FINISH | VARCHAR2 | (5) | ||
| WORKING_HOURS | NUMBER | (22) | ||
| WORKING_HOUR_FREQ | VARCHAR2 | (4000) | ||
| _DF:APD:_EDW | CHAR | (25) | ||
| _KF:CONC_NAME:POS:_EDW | CHAR | (15) | ||
| LAST_UPDATE_DATE | DATE | |||
| CREATION_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT POSITION_PK
, INSTANCE
, NAME
, POSITION_DP
, BUSINESS_GROUP
, ALL_FK
, ORGANIZATION_ID
, JOB_ID
, POSITION_ID
, POSITION_DEFINITION_ID
, BUSINESS_GROUP_ID
, POSITION_FROM_DATE
, POSITION_TO_DATE
, PROBATION_PERIOD
, REPLACEMENT_REQUIRED
, TIME_NORMAL_START
, TIME_NORMAL_FINISH
, WORKING_HOURS
, WORKING_HOUR_FREQ
, _DF:APD:_EDW
, _KF:CONC_NAME:POS:_EDW
, LAST_UPDATE_DATE
, CREATION_DATE
FROM APPS.EDWBV_HR_PSTN_POSITION_LCV;
APPS
EDW_LOCAL_INSTANCE
HR_ALL_ORGANIZATION_UNITS
HR_GENERAL
- show dependent code
PER_ALL_POSITIONS
PER_POSITION_DEFINITIONS
APPS
EDW_HR_PSTN_POSITION_LCV
|
|
|
|