SQL Query Account With Empty Industry Not In Results
(Doc ID 2553227.1)
Last updated on DECEMBER 22, 2020
Applies to:Oracle Fusion Engagement Cloud Service - Version 11.13.19.01.0 to 11.13.19.04.0 [Release 1.0]
Information in this document applies to any platform.
The below query was build in order to get the Activity report of a specific account.
Problem is that if the Account does not have an Industry, it is not shown in the results.
How can this be achieved ?
c.PARTY_NAME as OWNER,
b.PARTY_NAME as ACCOUNT_NAME,
b.PARTY_NUMBER as REGISTRY_ID,
d.PARTY_NAME as CONTACT_NAME,
e.CLASS_CODE as INDUSTRY
a.ACCOUNT_ID= :New_Parameter_1 and
order by a.ACTIVITY_START_DATE desc
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document