Opportunities

The information about a specific sale or a pending deal with a contact or an organization that is tracked and maintained in the Oracle B2C Service knowledge base.

Table-Specific Information

SELECT

The component will use the Oracle Service Cloud API to process WHERE clause conditions built with =,!=,<,>,<=,>=,IN,NOT_IN,IS,IS_NOT,LIKE operators. The rest of the filters are executed client side within the component.

SELECT * FROM Opportunities WHERE id = 12
SELECT * FROM Opportunities WHERE id > 15
SELECT * FROM Opportunities WHERE lookUpName LIKE '%test'
SELECT * FROM Opportunities WHERE id IN (12, 23, 123)
SELECT * FROM Opportunities WHERE lookUpName IS NOT NULL

INSERT

Insert can be executed. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO Opportunities (recalltime) VALUES ('2012-01-17')

UPDATE

Update can be executed. The columns that are not read-only can be Updated. For example:

UPDATE Opportunities SET summary = 'Test Replacement' WHERE lookupName = 'Battery Replacement'

DELETE

Following is an example of how to Delete a record in this table.

DELETE FROM Opportunities WHERE summary IS NULL

Columns


Name	Type	ReadOnly	Description
AssignedToAccountId	Long	False	Id of assignedToAccount. The sales representative assigned to the account.
AssignedToAccountlookUpName	String	False	LookUpName of assignedToAccount. The sales representative assigned to the account.
CampaignId	Long	True	Id of campaign. The campaign that created the opportunity, where applicable. This value and the survey are mutually exclusive; one or both must be null. This attribute is read-only.
CampaignlookUpName	String	True	LookUpName of campaign. The campaign that created the opportunity, where applicable. This value and the survey are mutually exclusive; one or both must be null. This attribute is read-only.
ClosedTime	Datetime	False	The date and time when the opportunity was closed.
CreatedTime	Datetime	True	The date and time when the opportunity was created. This attribute is read-only.
ForecastCloseDate	Date	False	The date when the opportunity is estimated to close.
Id [KEY]	Long	True	The unique identifier of the opportunity.
InitialContactDate	Date	False	The date when the sales representative made the initial contact with the organization.
InterfaceId	Long	False	Id of interface. The interface with which the opportunity is associated.
InterfacelookUpName	String	False	LookUpName of interface. The interface with which the opportunity is associated.
LeadRejectDateTime	Datetime	False	The date and time when the lead was rejected.
LeadRejectDescription	String	False	The summary or description provided when the lead was rejected.
LeadRejectReasonId	Long	False	Id of leadRejectReason. The reason the lead was rejected.
LeadRejectReasonlookUpName	String	False	LookUpName of leadRejectReason. The reason the lead was rejected.
LookupName	String	True	The name used to look up the opportunity.
LostTime	Datetime	False	The date and time when the opportunity was lost.
ManagerCommit	Bool	False	The committed status of the manager-forecasted value. The default value is false.
Name	String	False	The name of the opportunity.
OrganizationId	Long	False	Id of organization. The associated organization.
OrganizationlookUpName	String	False	LookUpName of organization. The associated organization.
RecallTime	Datetime	False	The date and time when the opportunity was recalled.
SalesRepresentativeCommit	Bool	False	Indicates whether the sales representative-forecasted value is committed. The default value is false.
SourceId	Long	True	Id of source. The creation source IDs. This attribute is read-only.
SourcelookUpName	String	True	LookUpName of source. The creation source IDs. This attribute is read-only.
Summary	String	False	The brief summary of the opportunity.
SurveyId	Long	True	Id of survey. The survey that created the opportunity, where applicable. This value and the campaign are mutually exclusive; one or both must be null. This attribute is read-only.
SurveylookUpName	String	True	LookUpName of survey. The survey that created the opportunity, where applicable. This value and the campaign are mutually exclusive; one or both must be null. This attribute is read-only.
TerritoryId	Long	False	Id of territory. The associated sales territory.
TerritorylookUpName	String	False	LookUpName of territory. The associated sales territory.
UpdatedTime	Datetime	True	The date and time when the opportunity was last updated. This attribute is read-only.
WinLossDescription	String	False	The description of how the opportunity was won or lost.
WinLossReasonId	Long	False	Id of winLossReason. The reason for winning or losing.
WinLossReasonlookUpName	String	False	LookUpName of winLossReason. The reason for winning or losing.
BannerimportanceFlagId	Long	False	Id of importanceFlag. The importance of the banner.
BannerimportanceFlaglookUpName	String	False	LookUpName of importanceFlag. The importance of the banner.
Bannertext	String	False	The description of a flag.
BannerupdatedByAccountId	Long	True	Id of updatedByAccount. The staff account that most recently updated the banner flag and/or text. This attribute is read-only.
BannerupdatedByAccountlookUpName	String	True	LookUpName of updatedByAccount. The staff account that most recently updated the banner flag and/or text. This attribute is read-only.
BannerupdatedTime	Datetime	True	The date and time when the banner was last updated. This attribute is read-only.
ClosedValuecurrencyId	Long	False	Id of currency. The ID of the currency.
ClosedValuecurrencylookUpName	String	False	LookUpName of currency. The ID of the currency.
ClosedValueexchangeRateId	Long	False	Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ClosedValueexchangeRatelookUpName	String	False	LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ClosedValuevalue	String	False	The value of the currency.
CostOfSalecurrencyId	Long	False	Id of currency. The ID of the currency.
CostOfSalecurrencylookUpName	String	False	LookUpName of currency. The ID of the currency.
CostOfSaleexchangeRateId	Long	False	Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
CostOfSaleexchangeRatelookUpName	String	False	LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
CostOfSalevalue	String	False	The value of the currency.
ManagerValuecurrencyId	Long	False	Id of currency. The ID of the currency.
ManagerValuecurrencylookUpName	String	False	LookUpName of currency. The ID of the currency.
ManagerValueexchangeRateId	Long	False	Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ManagerValueexchangeRatelookUpName	String	False	LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ManagerValuevalue	String	False	The value of the currency.
PrimaryContactcontactId	Long	False	Id of contact. The ID of the contact.
PrimaryContactcontactlookUpName	String	False	LookUpName of contact. The ID of the contact.
PrimaryContactcontactRoleId	Long	False	Id of contactRole. The role of the contact in the opportunity process.
PrimaryContactcontactRolelookUpName	String	False	LookUpName of contactRole. The role of the contact in the opportunity process.
ReturnValuecurrencyId	Long	False	Id of currency. The ID of the currency.
ReturnValuecurrencylookUpName	String	False	LookUpName of currency. The ID of the currency.
ReturnValueexchangeRateId	Long	False	Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ReturnValueexchangeRatelookUpName	String	False	LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ReturnValuevalue	String	False	The value of the currency.
SalesRepresentativeValuecurrencyId	Long	False	Id of currency. The ID of the currency.
SalesRepresentativeValuecurrencylookUpName	String	False	LookUpName of currency. The ID of the currency.
SalesRepresentativeValueexchangeRateId	Long	False	Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
SalesRepresentativeValueexchangeRatelookUpName	String	False	LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
SalesRepresentativeValuevalue	String	False	The value of the currency.
StageWithStrategystageId	Long	False	Id of stage. The current stage.
StageWithStrategystagelookUpName	String	False	LookUpName of stage. The current stage.
StageWithStrategystrategyId	Long	True	Id of strategy. The associated strategy. This attribute is read-only.
StageWithStrategystrategylookUpName	String	True	LookUpName of strategy. The associated strategy. This attribute is read-only.
StatusWithTypestatusId	Long	False	Id of status. The current status.
StatusWithTypestatuslookUpName	String	False	LookUpName of status. The current status.
StatusWithTypestatusTypeId	Long	True	Id of statusType. The associated status type. This attribute is read-only.
StatusWithTypestatusTypelookUpName	String	True	LookUpName of statusType. The associated status type. This attribute is read-only.

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
fileAttachments	String	The list of file attachments.
notes	String	The list of associated notes.
otherContacts	String	The other non-primary associated contacts.
quotes	String	The list of sales quotes.

SSIS Components for Oracle Service Cloud