How to pull GL JE data for a rolling last 2 periods or last 60 days

Summary:

How to pull GL JE data for a rolling last 2 periods or last 60 days

Content (required):

How can I pull GL JE data from the GL JE Header and Lines tables, so the report will pull a rolling last two periods of data or a rolling 60 days of data, from the current date?

Version (include the version you are using, if applicable):

Oracle Fusion Cloud Applications

23C (11.13.23.07.0)

Code Snippet (add any code snippets that support your topic, if applicable):

SELECT 

     gcc.segment1 || '.' || gcc.segment2 || '.' || gcc.segment3 || '.' || gcc.segment4 || '.' || 

      gcc.segment5 || '.' || gcc.segment6 Accounting_Code_Combination,