[Home] [Help]
[Dependency Information]
Object Name: | EDWBV_HR_PSTN_POSITION_LCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
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;
|
|
|