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 | Datetime | 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 | Datetime | 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. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| RecordSet | String |
Input specifying the resource type. |
| Finder | String |
Input specifying the Finder type. |