eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.BEN_CWB_REPT_STOCK_DETAIL_V

Object Details

Object Name:	BEN_CWB_REPT_STOCK_DETAIL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BEN.BEN_CWB_REPT_STOCK_DETAIL_V
Subobject Name:
Status:	VALID

View Type

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

BEN_CWB_REPT_STOCK_DETAIL_V contains stock plan details by manager.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
RT_STRT_DT	DATE			Rate Start Date.
PLAN_NAME	VARCHAR2	(240)		Plan Name.
WS_MGR_FULL_NAME	VARCHAR2	(240)		Manager Full Name.
EMP_FULL_NAME	VARCHAR2	(240)		Employee Full Name.
EMPNO	VARCHAR2	(30)		Employee Number.
IMM_MGR_FULL_NAME	VARCHAR2	(240)		Manager Full Name.
WS_MGR_BRIEF_NAME	VARCHAR2	(332)		Manager Brief Name.
EMP_BRIEF_NAME	VARCHAR2	(332)		Employee Brief Name.
IMM_MGR_BRIEF_NAME	VARCHAR2	(332)		Immediate Manager Brief Name.
PERSON_ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment.
PERSON_ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment.
PERSON_ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment.
PERSON_ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment.
PERSON_ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment.
PERSON_ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment.
PERSON_ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment.
PERSON_ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment.
PERSON_ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment.
PERSON_ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment.
WS_AMOUNT	NUMBER			Amount.
WS_AMOUNT_UNITS	VARCHAR2	(80)		Amount unit of Measure.
LEVELS_DOWN	NUMBER			Levels Down.
COMMENTS	VARCHAR2	(35)		Comments.
JOB	VARCHAR2	(700)		Job Name.
JOB_SEGMENT1	VARCHAR2	(60)		Key flexfield segment.
JOB_SEGMENT2	VARCHAR2	(60)		Key flexfield segment.
JOB_SEGMENT3	VARCHAR2	(60)		Key flexfield segment.
JOB_SEGMENT4	VARCHAR2	(60)		Key flexfield segment.
JOB_SEGMENT5	VARCHAR2	(60)		Key flexfield segment.
GRADE	VARCHAR2	(240)		Grade Name.
BASE_SALARY	NUMBER			Employee Base Salary.
BASE_SAL_CURR_FREQ	VARCHAR2	(111)		Base Salary Frequency.
RANK	VARCHAR2	(150)		Employee Ranking.
HIRE_DATE	DATE			Hire Date.
ORG_NAME	VARCHAR2	(240)		Organization Name.
COUNTRY	VARCHAR2	(150)		Country.
TODAYS_EMPLOYMENT_STATUS	VARCHAR2	(80)		Employment Status.
ENRT_PERD_ID	NUMBER	(15)		Enrollment Period Identifier.
PERSON_ID	NUMBER	(15)	Yes	Foreign Key to PER_PEOPLE_F.
LVL_NUM	NUMBER	(15)	Yes	Level Number.

Query Text

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


SELECT RT_STRT_DT
,      PLAN_NAME
,      WS_MGR_FULL_NAME
,      EMP_FULL_NAME
,      EMPNO
,      IMM_MGR_FULL_NAME
,      WS_MGR_BRIEF_NAME
,      EMP_BRIEF_NAME
,      IMM_MGR_BRIEF_NAME
,      PERSON_ATTRIBUTE1
,      PERSON_ATTRIBUTE2
,      PERSON_ATTRIBUTE3
,      PERSON_ATTRIBUTE4
,      PERSON_ATTRIBUTE5
,      PERSON_ATTRIBUTE6
,      PERSON_ATTRIBUTE7
,      PERSON_ATTRIBUTE8
,      PERSON_ATTRIBUTE9
,      PERSON_ATTRIBUTE10
,      WS_AMOUNT
,      WS_AMOUNT_UNITS
,      LEVELS_DOWN
,      COMMENTS
,      JOB
,      JOB_SEGMENT1
,      JOB_SEGMENT2
,      JOB_SEGMENT3
,      JOB_SEGMENT4
,      JOB_SEGMENT5
,      GRADE
,      BASE_SALARY
,      BASE_SAL_CURR_FREQ
,      RANK
,      HIRE_DATE
,      ORG_NAME
,      COUNTRY
,      TODAYS_EMPLOYMENT_STATUS
,      ENRT_PERD_ID
,      PERSON_ID
,      LVL_NUM
FROM APPS.BEN_CWB_REPT_STOCK_DETAIL_V;

Dependencies

[top of page]

APPS.BEN_CWB_REPT_STOCK_DETAIL_V references the following:

APPS: BENUTILS - show dependent code; BEN_ACTY_BASE_RT_F; BEN_CWB_HRCHY; BEN_ELIG_PER_ELCTBL_CHC; BEN_ENRT_RT; BEN_PER_IN_LER; BEN_PIL_ELCTBL_CHC_POPL; BEN_PL_F; BEN_PRTT_RT_VAL; FND_GLOBAL - show dependent code; HR_ALL_ORGANIZATION_UNITS_TL; HR_API - show dependent code; HR_GENERAL - show dependent code; HR_LOOKUPS; HR_ORGANIZATION_UNITS; HR_SECURITY - show dependent code; PER_ALL_ASSIGNMENTS_F; PER_ALL_PEOPLE_F; PER_ASSIGNMENT_EXTRA_INFO; PER_BUSINESS_GROUPS_PERF; PER_GRADES; PER_GRADES_TL; PER_JOBS; PER_JOBS_TL; PER_JOB_DEFINITIONS; PER_PAY_PROPOSALS; PER_PERSON_TYPES; PER_PERSON_TYPE_USAGES_F

APPS.BEN_CWB_REPT_STOCK_DETAIL_V is referenced by following:

PUBLIC: BEN_CWB_REPT_STOCK_DETAIL_V