VIEW: APPS.BEN_CWB_STOCK_TOTAL_POS_DTL_V

Source

View Text - Preformatted

SELECT PPF.employee_number, PPF.full_name full_name, PPF.first_name || ' ' || PPF.last_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, PPF.person_id, asg.supervisor_id from ben_cwb_stock_optn_dtls cso, per_all_people_f ppf, per_all_assignments_f asg WHERE PPF.person_id = asg.person_id and asg.primary_flag = 'Y' and sysdate between asg.effective_start_date and asg.effective_end_date and sysdate between PPF.effective_start_date and PPF.effective_end_date and ( PPF.person_id = cso.person_id or (PPF.business_group_id = cso.business_group_id and PPF.employee_number = cso.employee_number) ) ORDER BY PPF.full_name desc , grant_date

View Text - HTML Formatted

SELECT PPF.EMPLOYEE_NUMBER
, PPF.FULL_NAME FULL_NAME
, PPF.FIRST_NAME || ' ' || PPF.LAST_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
, PPF.PERSON_ID
, ASG.SUPERVISOR_ID
FROM BEN_CWB_STOCK_OPTN_DTLS CSO
, PER_ALL_PEOPLE_F PPF
, PER_ALL_ASSIGNMENTS_F ASG
WHERE PPF.PERSON_ID = ASG.PERSON_ID
AND ASG.PRIMARY_FLAG = 'Y'
AND SYSDATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND ( PPF.PERSON_ID = CSO.PERSON_ID OR (PPF.BUSINESS_GROUP_ID = CSO.BUSINESS_GROUP_ID
AND PPF.EMPLOYEE_NUMBER = CSO.EMPLOYEE_NUMBER) ) ORDER BY PPF.FULL_NAME DESC
, GRANT_DATE