View Name:	bus_opp_view
View Number:	5103
Group:	Clear Sales
Description:	Used by forms Opportunity (O) Detail (9601, 9630), Quote Call Scripts (9603), O Plan (9605), O Quotes (9606), O Competitive (9607), O Forecast (9608), O Influencer (9609) and My Clarify (12000)
Flags:	VIEW_OPTIMIZED
Baseline/Custom:	Baseline

View Field Name	Table Name	Field Name	Comment	Generic Field Id
objid	bus_opp_role	objid	Bus_opp_role internal record nubmer	3 (UNIQUE)
role_name	bus_opp_role	role_name	Name of the business opportunity role
bus_objid	bus_org	objid	Bus_org internal record number
bus_name	bus_org	name	Business organization name
opp_objid	opportunity	objid	Opportunity internal record number
active	bus_opp_role	active	Indicates whether the role is active; i.e., 0=inactive, 1=active
role_type	bus_opp_role	role_type	Type of role for the opportunity; i.e., 0=partner, 1=competitor
comments	bus_opp_role	comments	Comments about the role
focus_type	bus_opp_role	focus_type	Object type ID of the role-player; i.e., 173=an business organizations's role, 5000=an opportunity's role
products	bus_opp_role	products	Products this bus_org is trying to sell in this opportunity
close_date	bus_opp_role	close_date	Attempted close date for the opportunity by the bus_org
amount	bus_opp_role	amount	Currenty amount the bus_org is trying to close in this opportunity
drop_date	bus_opp_role	drop_date	Date on which the bus_org dropped out of the opportunity
drop_reason	bus_opp_role	drop_reason	Reason the bus_org left the opportunity

Join From	Join To
(bus_opp_role).opp_role2opportunity	(opportunity).opp2bus_opp_role
(bus_opp_role).bus_role2bus_org	(bus_org).bus_org2bus_opp_role

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