You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to get the SQL of a report made through Subject Areas

Summary:

We need to extract the source SQL code of a report made through subject areas

Content (required):

How can we get the source SQL code of a report made by subject area. We see that the "Advanced" tab exists within the report where a "SQL Issued" is shown, but we understand that this SQL is somehow a "View". Is there a way to extract the source SQL?, that is, where the real tables with the real field names actually appear?, for example:

SELECT NAME,

STATUS_CD,

CURRENCY_CODE,

FROM MOO_OPTY

This is because we need to complement a report in a data model to combine it with a table of attachments.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!