Reverse Engineering Interactive Reports/Grids using APEX_REGION and APEX_EXEC

Have you ever needed to see exactly what the user is seeing in an interactive report (IR) or grid (IG) in their current session? You obviously know what query/view/table you used to create the IR or I