OpportunityTeamMembers

The opportunity team members resource is used to view, create, and update the team members associated with an opportunity. The opportunity team member of the deploying organization associated with the opportunity.

Columns


Name	Type	ReadOnly	References	Description
OptyResourceId [KEY]	Long	False		This is the primary key of the opportunity team members table.
OptyNumber [KEY]	String	False	Opportunities.OptyNumber
AccessLevelCode	String	False		The type of access granted to the resource as well as managers of the organizations. A list of accepted values are defined in the lookup ZCA_ACCESS_LEVEL. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.
AsgnTerritoryVersionId	Long	False		The unique identifier of the territory version for the resource that got assigned to the opportunity through territory-based assignment.
AssignmentType	String	False		The code indicating how the resource is assigned to the sales account team. A list of accepted values are defined in the lookup ZCA_ASSIGNMENT_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.
CreatedBy	String	False		The user who created the opportunity resource record.
CreationDate	Datetime	False		The date and time when the resource record was created.
DealExpirationDate	Date	False		The date on which the deal protection period of an opportunity team member ends. The date is updated for territory members when they are unassigned from a opportunity because of a territory realingment.
DealProtected	String	False		Indicates if the resource is under deal protection. If the value is True, then the resource is under deal protection. The default value is False.
DealProtectedDate	Date	False		The date on which the deal protection period of an opportunity team member starts. The date is updated for territory members when they are unassigned from a opportunity because of a territory realingment.
EmailAddress	String	False		The e-mail address of the opportunity team member.
FormattedPhoneNumber	String	False		The formatted phone number of the opportunity team member.
LastUpdateDate	Datetime	False		The date when the record was last updated.
LastUpdatedBy	String	False		The user who last updated the record.
LastUpdateLogin	String	False		The session login associated to the user who last updated the record.
LockAssignmentFlag	Boolean	False		Indicates if the automatic territory assignment can be set. If the value is True, then the automatic territory assignment cannot remove the sales account team resource. When a sales account team member is added manually, this flag is defaulted to `Y'.
MemberFunctionCode	String	False		The code indicating the role of a sales team member in the resource team such as Integrator, Executive Sponsor, and Technical Account Manager. A list of accepted values is defined in the lookup FND_LOOKUPS. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
MgrResourceId	Long	False		The unique identifier of the resource team member's manager.
OptyId	Long	False		The unique Identifier of the opportunity.
OptyResourceNumber	String	False		The label that represents the association between the opportunity and resource.
OwnerFlag	Boolean	False		Indicates if the opportunity team member is the owner of the opportunity. If the value is True, then the opportunity team member is also the owner fo the opportunity. The default value is False.
PartnerOrgId	Long	False		The unique identifier of the partner organization.
PartnerPartyName	String	False		The name of the partner associated with the partner resource.
PartyName	String	False		The name of the opportunity team member.
PersonFirstName	String	False		The first name of the opportunity team member.
PersonLastName	String	False		The last name of the opportunity team member.
ResourceId	Long	False		The unique party identifier for the existing resource record in Oracle Sales.
RoleName	String	False		The role of the opportunity team member in the resource organization.
TerritoryName	String	False		The name of the opportunity team member's territory.
OpportunityLastUpdateDate	Datetime	False		The date and time when the opportunity was last updated.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
RecordSet	String	Input specifying the resource type.
Finder	String	Input specifying the Finder type.
PartyId	String	Input specifying the Party Id.
PartyIdAttribute	String	Input specifying the Party Id Attribute.
AttributeName	String	Input specifying the Attribute Name.
RollUpId	String	Input specifying the RollUp Id.
SourceObject	String	Input specifying the Source Object.
SourceObjectId	String	Input specifying the Source Object Id.
ClosePeriod	String	Input specifying the Close Period.
ContactPartyId	String	Input specifying the Contact Party Id.
EffectiveBeginDate	String	Input specifying the Effective BeginDate.
EffectiveEndDate	String	Input specifying the Effective EndDate.
LeadNumber	String	Input specifying the Lead Number.
LookupCategory	String	Input specifying the Lookup Category.
OpportunityContactName	String	Input specifying the Opportunity Contact Name.
OptyStatusCode	String	Input specifying the Opty StatusCode.
Partner	String	Input specifying the Partner.
PartnerPartyId	String	Input specifying the Partner Party Id.
Product	String	Input specifying the Product.
ProductGroup	String	Input specifying the Product Group.
ReferenceName	String	Input specifying the Reference Name.
ResourcePartyId	String	Input specifying the Resource Party Id.
TeamMember	String	Input specifying the Team Member.
Name	String	Input specifying the Name.

SSIS Components for Oracle Sales

OpportunityTeamMembers

Columns

Pseudo-Columns