Help do find Final discharge location description (FDG Report)

Kauan_Bohn

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!

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/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?

Bhaskar Konar

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

Thank you very much for sharing!