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

VIEW: APPS.BENBV_CWB_SUMMARY_V

Object Details
Object Name: BENBV_CWB_SUMMARY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBEN.BENBV_CWB_SUMMARY_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
STATUS VARCHAR2 (30)
Summary Row Status.
ELIG_COUNT_DIRECT NUMBER (15)
Directs Eligible.
ELIG_COUNT_ALL NUMBER (15)
Alls Eligible.
EMP_RECV_COUNT_DIRECT NUMBER (15)
Directs Receiving.
EMP_RECV_COUNT_ALL NUMBER (15)
Alls Receiving.
ELIG_SAL_VAL_DIRECT NUMBER

Directs Eligible Salary.
ELIG_SAL_VAL_ALL NUMBER

Alls Eligible Salary.
WS_VAL_DIRECT NUMBER

Directs Worksheet Value.
WS_VAL_ALL NUMBER

Alls Worksheet Value.
WS_BDGT_VAL_DIRECT NUMBER

Directs Worksheet Budget Value.
WS_BDGT_VAL_ALL NUMBER

Alls Worksheet Budget Value.
WS_BDGT_ISS_VAL_DIRECT NUMBER

Directs Worksheet Budget Issued Value.
WS_BDGT_ISS_VAL_ALL NUMBER

Alls Worksheet Budget Issued Value.
BDGT_VAL_DIRECT NUMBER

Directs Budget Value.
BDGT_ISS_VAL_DIRECT NUMBER

Directs Budget Issued Value.
STAT_SAL_VAL_DIRECT NUMBER

Directs Stated Salary.
STAT_SAL_VAL_ALL NUMBER

Alls Stated Salary.
OTH_COMP_VAL_DIRECT NUMBER

Directs Other Compensation.
OTH_COMP_VAL_ALL NUMBER

Alls Other Compensation.
TOT_COMP_VAL_DIRECT NUMBER

Directs Total Compensation.
TOT_COMP_VAL_ALL NUMBER

Alls Total Compensation.
REC_VAL_DIRECT NUMBER

Directs Recommended Value.
REC_VAL_ALL NUMBER

Alls Recommended Value.
REC_MN_VAL_DIRECT NUMBER

Directs Recommended Min Value.
REC_MN_VAL_ALL NUMBER

Alls Recommended Min Value.
REC_MX_VAL_DIRECT NUMBER

Directs Recommended Max Value.
REC_MX_VAL_ALL NUMBER

Alls Recommended Max Value.
MISC1_VAL_DIRECT NUMBER

Directs Miscellaneous 1 Value.
MISC1_VAL_ALL NUMBER

Alls Miscellaneous 1 Value.
MISC2_VAL_DIRECT NUMBER

Directs Miscellaneous 2 Value.
MISC2_VAL_ALL NUMBER

Alls Miscellaneous 2 Value.
MISC3_VAL_DIRECT NUMBER

Directs Miscellaneous 3 Value.
MISC3_VAL_ALL NUMBER

Alls Miscellaneous 3 Value.
LF_EVT_OCRD_DT DATE

Life Event Occured Date
GROUP_PLAN VARCHAR2 (4000)
Group Plan.
GROUP_OPTION_IN_PLAN VARCHAR2 (4000)
Group Option in Plan.
SUMMARY_ID NUMBER (15) Yes Summary Primary Key.
GROUP_PER_IN_LER_ID NUMBER (15) Yes Group Per in Ler ID
GROUP_PL_ID NUMBER (15) Yes Group Plan ID
GROUP_OIPL_ID NUMBER (15)
Group Option in Plan
PERSON_ID NUMBER (15)
Person ( Foreign key to PER_ALL_PEOPLE_F)
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
Query Text

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


SELECT STATUS
,      ELIG_COUNT_DIRECT
,      ELIG_COUNT_ALL
,      EMP_RECV_COUNT_DIRECT
,      EMP_RECV_COUNT_ALL
,      ELIG_SAL_VAL_DIRECT
,      ELIG_SAL_VAL_ALL
,      WS_VAL_DIRECT
,      WS_VAL_ALL
,      WS_BDGT_VAL_DIRECT
,      WS_BDGT_VAL_ALL
,      WS_BDGT_ISS_VAL_DIRECT
,      WS_BDGT_ISS_VAL_ALL
,      BDGT_VAL_DIRECT
,      BDGT_ISS_VAL_DIRECT
,      STAT_SAL_VAL_DIRECT
,      STAT_SAL_VAL_ALL
,      OTH_COMP_VAL_DIRECT
,      OTH_COMP_VAL_ALL
,      TOT_COMP_VAL_DIRECT
,      TOT_COMP_VAL_ALL
,      REC_VAL_DIRECT
,      REC_VAL_ALL
,      REC_MN_VAL_DIRECT
,      REC_MN_VAL_ALL
,      REC_MX_VAL_DIRECT
,      REC_MX_VAL_ALL
,      MISC1_VAL_DIRECT
,      MISC1_VAL_ALL
,      MISC2_VAL_DIRECT
,      MISC2_VAL_ALL
,      MISC3_VAL_DIRECT
,      MISC3_VAL_ALL
,      LF_EVT_OCRD_DT
,      GROUP_PLAN
,      GROUP_OPTION_IN_PLAN
,      SUMMARY_ID
,      GROUP_PER_IN_LER_ID
,      GROUP_PL_ID
,      GROUP_OIPL_ID
,      PERSON_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.BENBV_CWB_SUMMARY_V;

Dependencies

[top of page]

APPS.BENBV_CWB_SUMMARY_V references the following:

SchemaAPPS
PL/SQL PackageBEN_BIS_UTILS - show dependent code
SynonymBEN_CWB_SUMMARY

APPS.BENBV_CWB_SUMMARY_V is not referenced by any database object