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

VIEW: APPS.BEN_CWB_STOCK_TOTAL_POS_DTL_V

Object Details
Object Name: BEN_CWB_STOCK_TOTAL_POS_DTL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBEN.BEN_CWB_STOCK_TOTAL_POS_DTL_V
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


BEN_CWB_STOCK_TOTAL_POS_DTL_V displays the positions of the employees stock options.


[View Source]

Columns
Name Datatype Length Mandatory Comments
EMPLOYEE_NUMBER VARCHAR2 (30)
Number assigned to a person if they have been an employee.
FULL_NAME VARCHAR2 (240)
Concatenation of last name, title, first name, middle names and the name the person is known by.
BRIEF_NAME VARCHAR2 (301)
Brief Name.
GRANT_NUMBER VARCHAR2 (30)
Grant Number.
GRANT_NAME VARCHAR2 (100)
Grant Name.
GRANT_TYPE VARCHAR2 (30)
Grant Type.
GRANT_DATE DATE

Grant Date.
GRANT_SHARES NUMBER

Grant Shares.
GRANT_PRICE NUMBER

Grant Price.
VALUE_AT_GRANT NUMBER

Valuation of Grant.
CURRENT_SHARE_PRICE NUMBER

Current Share Price.
CURRENT_SHARES_OUTSTANDING NUMBER

Current Outstanding Shares.
VESTED_SHARES NUMBER

Vested Shares.
UNVESTED_SHARES NUMBER

Unvested Shares.
EXERCISABLE_SHARES NUMBER

Excercisable Shares.
EXERCISED_SHARES NUMBER

Excercised Shares.
CANCELLED_SHARES NUMBER

Cancelled Shares.
TRADING_SYMBOL VARCHAR2 (30)
Trading Symbol.
EXPIRATION_DATE DATE

Expiration Date.
REASON_CODE VARCHAR2 (30)
Reason.
CLASS VARCHAR2 (30)
Classification.
MISC VARCHAR2 (100)
Miscellaneous Information.
PERSON_ID NUMBER (10) Yes Foreign Key to PER_PEOPLE_F.
SUPERVISOR_ID NUMBER (10)
Supervisor Identifier.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EMPLOYEE_NUMBER
,      FULL_NAME
,      BRIEF_NAME
,      GRANT_NUMBER
,      GRANT_NAME
,      GRANT_TYPE
,      GRANT_DATE
,      GRANT_SHARES
,      GRANT_PRICE
,      VALUE_AT_GRANT
,      CURRENT_SHARE_PRICE
,      CURRENT_SHARES_OUTSTANDING
,      VESTED_SHARES
,      UNVESTED_SHARES
,      EXERCISABLE_SHARES
,      EXERCISED_SHARES
,      CANCELLED_SHARES
,      TRADING_SYMBOL
,      EXPIRATION_DATE
,      REASON_CODE
,      CLASS
,      MISC
,      PERSON_ID
,      SUPERVISOR_ID
FROM APPS.BEN_CWB_STOCK_TOTAL_POS_DTL_V;

Dependencies

[top of page]

APPS.BEN_CWB_STOCK_TOTAL_POS_DTL_V references the following:

SchemaAPPS
SynonymBEN_CWB_STOCK_OPTN_DTLS
SynonymPER_ALL_ASSIGNMENTS_F
SynonymPER_ALL_PEOPLE_F

APPS.BEN_CWB_STOCK_TOTAL_POS_DTL_V is not referenced by any database object