View: RG_REPORT_NAME_V

Product:	RG - Application Report Generator
Description:
Implementation/DBA Data:	APPS.RG_REPORT_NAME_V

View Text

SELECT RP.APPLICATION_ID
, RP.REPORT_ID
, RP.NAME
, RP.REPORT_TITLE
, RP.SECURITY_FLAG
, RP.DESCRIPTION
, RP.UNIT_OF_MEASURE_ID
, RP.PARAMETER_SET_ID
, RP.REPORT_DISPLAY_SET_ID
, RPD.NAME REPORT_DISPLAY_SET
, RP.CONTENT_SET_ID
, COS.NAME CONTENT_SET
, RP.ROW_ORDER_ID
, ROD.NAME ROW_ORDER
, RP.COLUMN_SET_ID
, CSET.NAME COLUMN_SET
, RP.ROW_SET_ID
, RS.NAME ROW_SET
, RP.ROUNDING_OPTION
, RP.ID_FLEX_CODE
, RP.STRUCTURE_ID
, RP.SEGMENT_OVERRIDE
, RP.OVERRIDE_ALC_LEDGER_CURRENCY
, RP.MINIMUM_DISPLAY_LEVEL
, 'N' EXCEPTIONS_FLAG
, RP.OUTPUT_OPTION
, DECODE(RP.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_FSG_REPORT_U'
, 'GL_DAS_FSG_REPORT'
, TO_CHAR(RP.REPORT_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') USE_PRIVILEGE
FROM RG_REPORTS RP
, RG_REPORT_AXIS_SETS CSET
, RG_REPORT_AXIS_SETS RS
, RG_LOOKUPS RL
, RG_REPORT_CONTENT_SETS COS
, RG_ROW_ORDERS ROD
, RG_REPORT_DISPLAY_SETS RPD
WHERE RP.COLUMN_SET_ID = CSET.AXIS_SET_ID
AND CSET.AXIS_SET_TYPE = 'C'
AND RP.ROW_SET_ID = RS.AXIS_SET_ID
AND RS.AXIS_SET_TYPE = 'R'
AND RP.ROW_ORDER_ID = ROD.ROW_ORDER_ID (+)
AND RP.CONTENT_SET_ID = COS.CONTENT_SET_ID (+)
AND RP.REPORT_DISPLAY_SET_ID = RPD.REPORT_DISPLAY_SET_ID (+)
AND ( RL.LOOKUP_TYPE = 'FSG_ADHOC_REPORT_NAME_PREFIX' AND RL.LOOKUP_CODE = 'ADHOC_PREFIX' AND RP.NAME NOT LIKE SUBSTR(RL.MEANING
, 1
, 16)||'%' )

Columns