GL FSG - Row Set Detail Listing

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Row Set Detail Listing
Application: General Ledger
Source: FSG - Row Set Detail Listing (XML)
Short Name: RGXROWD_XML
DB package: GL_RGXROWD_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

SELECT AXIS_SET_ID AXIS_SET_ID1,
       AXIS_SEQ, AXIS_NAME,
       RG_REPORT_AXES.DESCRIPTION AX_DESCRIPTION,
       STD.STANDARD_AXIS_NAME AMOUNT_TYPE,
       PERIOD_OFFSET, UNIT_OF_MEASURE_ID,
       PARAMETER_NUM RUNTIME_OVERRIDE,
       LK1.MEANING OVERRIDE_COLUMN_CALCULATIONS,
       PERCENTAGE_DIVISOR_SEQ,
       DISPLAY_FLAG,
       XBRL.ELEMENT_LABEL,
       LK2.MEANING DISPLAY,
       DISPLAY_FORMAT,
       RGLK1.MEANING FACTOR,
       LK3.MEANING DISPLAY_ZERO,
       LK4.MEANING CHANGE_SIGN,
       LK5.MEANING CHANGE_SIGN_ON_VARIANCE,
       RGLK2.MEANING LEVEL_OF_DETAIL,
       NUMBER_CHARACTERS_INDENTED,
       NUMBER_LINES_SKIPPED_BEFORE,
       NUMBER_LINES_SKIPPED_AFTER,
       BEFORE_AXIS_STRING,
       AFTER_AXIS_STRING,
       LK6.MEANING PAGE_BREAK_BEFORE,
       LK7.MEANING PAGE_BREAK_AFTER
FROM
       RG_REPORT_AXES,
       RG_REPORT_STANDARD_AXES_TL STD,
       RG_XBRL_ELEMENTS XBRL,
       FND_LOOKUPS LK1, FND_LOOKUPS LK2,
       FND_LOOKUPS LK3, FND_LOOKUPS LK4,
       FND_LOOKUPS LK5, FND_LOOKUPS LK6,
       FND_LOOKUPS LK7,
       RG_LOOKUPS RGLK1, RG_LOOKUPS RGLK2
WHERE
      STD.STANDARD_AXIS_ID(+) =
        RG_REPORT_AXES.STANDARD_AXIS_ID
AND STD.LANGUAGE(+) = USERENV('LANG')
AND RG_REPORT_AXES.ELEMENT_ID = XBRL.ELEMENT_ID(+)
AND LK1.LOOKUP_TYPE(+) = 'YES_NO'
AND LK1.LOOKUP_CODE(+) =
         CALCULATION_PRECEDENCE_FLAG
AND LK2.LOOKUP_TYPE(+) = 'YES_NO'
AND LK2.LOOKUP_CODE(+) = DISPLAY_FLAG
AND RGLK1.LOOKUP_TYPE(+) = 'DISPLAY_UNITS'
AND RGLK1.LOOKUP_CODE(+) = TO_CHAR (DISPLAY_UNITS)
AND LK3.LOOKUP_TYPE(+) = 'YES_NO'
AND LK3.LOOKUP_CODE(+) =
       DISPLAY_ZERO_AMOUNT_FLAG
AND LK4.LOOKUP_TYPE(+) = 'YES_NO'
AND LK4.LOOKUP_CODE(+) = CHANGE_SIGN_FLAG
AND LK5.LOOKUP_TYPE(+) = 'YES_NO'
AND LK5.LOOKUP_CODE(+) =
       CHANGE_VARIANCE_SIGN_FLAG
AND RGLK2.LOOKUP_TYPE(+) = 'GL_DISPLAY_LEVEL'
AND RGLK2.LOOKUP_CODE(+) = TO_CHAR (DISPLAY_LEVEL)
AND LK6.LOOKUP_TYPE(+) = 'YES_NO'
AND LK6.LOOKUP_CODE(+) = PAGE_BREAK_BEFORE_FLAG
AND LK7.LOOKUP_TYPE(+) = 'YES_NO'
AND LK7.LOOKUP_CODE(+) = PAGE_BREAK_AFTER_FLAG
 and AXIS_SET_ID=:AXIS_SET_ID
ORDER BY AXIS_SEQ
Parameter Name SQL text Validation
Row Set Name
 
LOV Oracle