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

VIEW: APPS.BEN_CWB_EQUITY_EDGE_OPT_INFO_V

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
EMPLOYEE_NUMBER VARCHAR2 (30)
Employee Number.
OPTION_NUMBER VARCHAR2 (240)
Option Number.
PLAN_NAME VARCHAR2 (240)
Plan Name.
TYPE VARCHAR2 (240)
Option Plan Type.
CLASS VARCHAR2 (240)
Class.
OPTION_DATE VARCHAR2 (240)
Option Grant Date.
GRANT_DATE_MARKET_VALUE VARCHAR2 (240)
Market Value on Grant Date
PRICE VARCHAR2 (240)
Price.
SHARES NUMBER

Number of Shares.
MAX_SAR_PCT VARCHAR2 (240)
Max Percentage.
VEST_TEMPLATE VARCHAR2 (240)
Vesting Template.
VEST_BASE_DATE VARCHAR2 (240)
Vesting Base Date.
ACTIVE_FLAG CHAR (1)
Active [Y/N].
TRANSACTION_ID NUMBER (15) Yes Transaction Identifier.
ENRT_PERD_ID NUMBER (15)
Enrollment Period Identifier.
Query Text

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


SELECT EMPLOYEE_NUMBER
,      OPTION_NUMBER
,      PLAN_NAME
,      TYPE
,      CLASS
,      OPTION_DATE
,      GRANT_DATE_MARKET_VALUE
,      PRICE
,      SHARES
,      MAX_SAR_PCT
,      VEST_TEMPLATE
,      VEST_BASE_DATE
,      ACTIVE_FLAG
,      TRANSACTION_ID
,      ENRT_PERD_ID
FROM APPS.BEN_CWB_EQUITY_EDGE_OPT_INFO_V;

Dependencies

[top of page]

APPS.BEN_CWB_EQUITY_EDGE_OPT_INFO_V references the following:

SchemaAPPS
SynonymBEN_ELIG_PER_ELCTBL_CHC
SynonymBEN_ENRT_RT
SynonymBEN_PER_IN_LER
SynonymBEN_PIL_ELCTBL_CHC_POPL
SynonymBEN_PRTT_RT_VAL
SynonymBEN_TRANSACTION
SynonymPER_ALL_PEOPLE_F
APPS.BEN_CWB_EQUITY_EDGE_OPT_INFO_V is referenced by following:

SchemaPUBLIC
SynonymBEN_CWB_EQUITY_EDGE_OPT_INFO_V