View Name:	oppempl_view
View Number:	5230
Group:	Sales Mgr
Description:	Used internally to select Opportunities
Flags:	VIEW_OPTIMIZED
Baseline/Custom:	Baseline

View Field Name	Table Name	Field Name	Comment	Generic Field Id
objid	opportunity	objid	Opportunity internal record number	3 (UNIQUE)
terr_objid	territory	objid	Territory internal record number
stage_objid	cycle_stage	objid	Cycle state internal record number
empl_objid	employee	objid	Employee internal record number
user_objid	user	objid	User internal record number
id	opportunity	id	Opportunity ID number
name	opportunity	name	Opportunity Name
amount	opportunity	frcst_cls_amount	Forecasted close amount
probability	opportunity	frcst_cls_prb	Forecasted close probability
close_date	opportunity	frcst_cls_dt	Forecasted close date
stage	cycle_stage	name	Cycle stage name
first_name	employee	first_name	Employee first name
last_name	employee	last_name	Employee last name

Join From	Join To
(opportunity).opp2territory	(territory).terr2opportunity
(opportunity).opp2cycle_stage	(cycle_stage).stage2opportunity
(opportunity).opp_owner2user	(user).owner2opportunity
(employee).employee2user	(user).user2employee

act_entry	case	contact	employee
rol_contct	site	site_view	user

alt-s	Execute SQL
alt-t	Execute SQL, getting latest 10 rows
?	Bring up this help dialog