GL FSG - Column Set Detail Listing

Description
Categories: BI Publisher
Columns: Axis Set Id2, Axis Seq, Axis Name, Ax Description, Amount Type, Period Offset, Unit Of Measure Id, Runtime Override, Override Column Calculations, Percentage Divisor Seq ...
Application: General Ledger
Source: FSG - Column Set Detail Listing (XML)
Short Name: RGXCOLD_XML
DB package: GL_RGXCOLD_XMLP_PKG
SELECT AXIS_SET_ID AXIS_SET_ID2, 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,
       LK2.MEANING DISPLAY,
       POSITION,
       DISPLAY_FORMAT,
       FORMAT_BEFORE_TEXT,
       FORMAT_AFTER_TEXT,
       DISPLAY_PRECISION,
       FORMAT_MASK_WIDTH,
       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,
       SEGMENT_OVERRIDE_VALUE,
	GL_RGXCOLD_XMLP_PKG.display_format_dspformula(DISPLAY_FORMAT, DISPLAY_PRECISION, FORMAT_MASK_WIDTH, FORMAT_BEFORE_TEXT, FORMAT_AFTER_TEXT) DISPLAY_FORMAT_DSP
FROM
       RG_REPORT_AXES,
       RG_REPORT_STANDARD_AXES_TL STD,
       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 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
Column Set Name
 
LOV Oracle
Access Set Id
 
Number
GL_SRS_COA_UNVALIDATED
 
Number
RG_SRS_INSTALLATION