Oracle Communities

Oracle Analytics and AI

Child Item

Help do find Final discharge location description (FDG Report)

I am running a query based on the FDG tables and need information about the FINAL DISCHARGE LOCATION.

Within the table JG_FSCL_DOC_LINES_ALL, we can access the ship_to_location_id field. Is it possible to link it and retrieve the NAME of the FINAL DISCHARGE LOCATION?

The tables I am using in my query are:

JG_FSCL_DOC_RELATIONS_ALL JFDRA
JG_FSCL_DOC_LINES_ALL JFDLA
HZ_PARTY_SITES HPS
HZ_LOCATIONS HL
HZ_PARTIES
FUN_ALL_BUSINESS_UNITS_V FABU
RA_CUSTOMER_TRX_ALL RCTA

Thanks!

Find more posts tagged with

Analytics

help

BI Publisher Data Models

Fusion AI Data Platform

Accepted answers

Kauan_Bohn

I tried this way in a subselect, and it worked:

SELECT hl.city

FROM HZ_LOCATIONS hl    

WHERE hl.location_id = jfdla.FINAL_DISCHARGE_LOCATION_id)

Thanks for the help!

All comments

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/24425/help-do-find-final-discharge-location-description-fdg-report

Hi @Kauan_Bohn,

Can you please check the following post to see if it is useful?

Location of Final Discharge in Receivables — Cloud Customer Connect

Cheers,

Kauan_Bohn

Hi,

It helped me identify that what I need is to find the description of SHIP_TO_LOCATION_ID, but I couldn't find the table that can be joined with JG_FSCL_DOC_LINES_ALL to bring me the description. I tried the following query:

SELECT 

jdfla.SHIP_TO_LOCATION_ID,

hl.city

FROM 

JG_FSCL_DOC_LINES_ALL jdfla,     

HZ_LOCATIONS hl

WHERE hl.location_id = jdfla.SHIP_TO_LOCATION_ID;

However, when joining it with my main query, it is not returning correctly. Is this a valid join?

Kauan_Bohn

I tried this way in a subselect, and it worked:

SELECT hl.city

FROM HZ_LOCATIONS hl    

WHERE hl.location_id = jfdla.FINAL_DISCHARGE_LOCATION_id)

Thanks for the help!

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/63345#Comment_63345

Thank you very much for sharing!