My Oracle Support Banner

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.

Goal

 

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 ?

select
a.ACTIVITY_START_DATE,
a.ACTIVITY_END_DATE,
c.PARTY_NAME as OWNER,
a.SUBJECT,
a.ACTIVITY_TYPE_CODE,
a.ACTIVITY_FUNCTION_CODE,
a.ACTIVITY_DESC,
a.ACTIVITY_MTG_MINUTES,
b.PARTY_NAME as ACCOUNT_NAME,
b.PARTY_NUMBER as REGISTRY_ID,
d.PARTY_NAME as CONTACT_NAME,
a.LOCATION,
b.CITY,
e.CLASS_CODE as INDUSTRY
from
fusion.ZMM_ACTY_ACTIVITIES a,
fusion.hz_parties b,
fusion.hz_parties c,
fusion.hz_parties d,
fusion.ZCA_BI_CODE_ASSIGNMENTS_V e
where
a.OWNER_ID=c.PARTY_ID and
a.ACCOUNT_ID=b.PARTY_ID and
a.ACCOUNT_ID= :New_Parameter_1 and
a.PRIMARY_CONTACT_ID=d.PARTY_ID(+) and
b.PARTY_ID=e.OWNER_TABLE_ID and
e.CLASS_CATEGORY='A3_INDUSTRIES' and
e.STATUS='A' and
e.PRIMARY_FLAG='Y'
order by a.ACTIVITY_START_DATE desc


Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.