[Home] [Help]
[Dependency Information]
| Object Name: | HRBV_POSITION_LIST_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Position list (from PER_POSITION_LIST table ).
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PROGRAM_UPDATE_DATE | DATE | Program update date. | ||
| SECURITY_PROFILE_ID | NUMBER | (15) | Yes | Foreign key to PER_SECURITY_PROFILES. |
| POSITION_ID | NUMBER | (15) | Yes | Foreign key to PER_ALL_POSITIONS. |
| USER_ID | NUMBER | (15) | User Id. |
Cut, paste (and edit) the following text to query this object:
SELECT PROGRAM_UPDATE_DATE
, SECURITY_PROFILE_ID
, POSITION_ID
, USER_ID
FROM APPS.HRBV_POSITION_LIST_V;
APPS
PER_POSITION_LIST
APPS.HRBV_POSITION_LIST_V is not referenced by any database object
|
|
|
|