VIEW: APPS.RG_REPORTS_V

Source

View Text - Preformatted

SELECT RP.ROWID ROW_ID, RP.APPLICATION_ID, RP.REPORT_ID, RP.LAST_UPDATE_DATE, RP.LAST_UPDATED_BY, RP.LAST_UPDATE_LOGIN, RP.CREATION_DATE, RP.CREATED_BY, RP.NAME, RP.REPORT_TITLE, RP.SECURITY_FLAG, RP.ROW_SET_ID, RP.COLUMN_SET_ID, RP.REPORT_DISPLAY_SET_ID, RP.CONTENT_SET_ID, RP.ROW_ORDER_ID, RP.MINIMUM_DISPLAY_LEVEL, CSET.NAME COLUMN_SET, RS.NAME ROW_SET, RPD.NAME REPORT_DISPLAY_SET, COS.NAME CONTENT_SET, ROD.NAME ROW_ORDER, RP.ROUNDING_OPTION, RP.PARAMETER_SET_ID, RP.UNIT_OF_MEASURE_ID, RP.ID_FLEX_CODE, RP.STRUCTURE_ID, RP.SEGMENT_OVERRIDE, RP.OVERRIDE_ALC_LEDGER_CURRENCY, RP.DESCRIPTION, RP.CONTEXT, RP.ATTRIBUTE1, RP.ATTRIBUTE2, RP.ATTRIBUTE3, RP.ATTRIBUTE4, RP.ATTRIBUTE5, RP.ATTRIBUTE6, RP.ATTRIBUTE7, RP.ATTRIBUTE8, RP.ATTRIBUTE9, RP.ATTRIBUTE10, RP.ATTRIBUTE11, RP.ATTRIBUTE12, RP.ATTRIBUTE13, RP.ATTRIBUTE14, RP.ATTRIBUTE15, RP.OUTPUT_OPTION, DECODE(RP.SECURITY_FLAG, 'Y', DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0, 'GL_DAS_FSG_REPORT_V', 'GL_DAS_FSG_REPORT', TO_CHAR(RP.REPORT_ID), NULL, NULL, NULL, NULL, FND_GLOBAL.USER_NAME), 'T', 'Y', 'N'), 'Y') VIEW_PRIVILEGE, 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, DECODE(RP.SECURITY_FLAG, 'Y', DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0, 'GL_DAS_FSG_REPORT_M', 'GL_DAS_FSG_REPORT', TO_CHAR(RP.REPORT_ID), NULL, NULL, NULL, NULL, FND_GLOBAL.USER_NAME), 'T', 'Y', 'N'), 'Y') MODIFY_PRIVILEGE FROM RG_REPORTS RP, RG_REPORT_AXIS_SETS CSET, RG_REPORT_AXIS_SETS RS, RG_REPORT_DISPLAY_SETS RPD, RG_REPORT_CONTENT_SETS COS, RG_ROW_ORDERS ROD, RG_LOOKUPS RL 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) || '%')

View Text - HTML Formatted

SELECT RP.ROWID ROW_ID
, RP.APPLICATION_ID
, RP.REPORT_ID
, RP.LAST_UPDATE_DATE
, RP.LAST_UPDATED_BY
, RP.LAST_UPDATE_LOGIN
, RP.CREATION_DATE
, RP.CREATED_BY
, RP.NAME
, RP.REPORT_TITLE
, RP.SECURITY_FLAG
, RP.ROW_SET_ID
, RP.COLUMN_SET_ID
, RP.REPORT_DISPLAY_SET_ID
, RP.CONTENT_SET_ID
, RP.ROW_ORDER_ID
, RP.MINIMUM_DISPLAY_LEVEL
, CSET.NAME COLUMN_SET
, RS.NAME ROW_SET
, RPD.NAME REPORT_DISPLAY_SET
, COS.NAME CONTENT_SET
, ROD.NAME ROW_ORDER
, RP.ROUNDING_OPTION
, RP.PARAMETER_SET_ID
, RP.UNIT_OF_MEASURE_ID
, RP.ID_FLEX_CODE
, RP.STRUCTURE_ID
, RP.SEGMENT_OVERRIDE
, RP.OVERRIDE_ALC_LEDGER_CURRENCY
, RP.DESCRIPTION
, RP.CONTEXT
, RP.ATTRIBUTE1
, RP.ATTRIBUTE2
, RP.ATTRIBUTE3
, RP.ATTRIBUTE4
, RP.ATTRIBUTE5
, RP.ATTRIBUTE6
, RP.ATTRIBUTE7
, RP.ATTRIBUTE8
, RP.ATTRIBUTE9
, RP.ATTRIBUTE10
, RP.ATTRIBUTE11
, RP.ATTRIBUTE12
, RP.ATTRIBUTE13
, RP.ATTRIBUTE14
, RP.ATTRIBUTE15
, RP.OUTPUT_OPTION
, DECODE(RP.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_FSG_REPORT_V'
, 'GL_DAS_FSG_REPORT'
, TO_CHAR(RP.REPORT_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') VIEW_PRIVILEGE
, 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
, DECODE(RP.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_FSG_REPORT_M'
, 'GL_DAS_FSG_REPORT'
, TO_CHAR(RP.REPORT_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') MODIFY_PRIVILEGE
FROM RG_REPORTS RP
, RG_REPORT_AXIS_SETS CSET
, RG_REPORT_AXIS_SETS RS
, RG_REPORT_DISPLAY_SETS RPD
, RG_REPORT_CONTENT_SETS COS
, RG_ROW_ORDERS ROD
, RG_LOOKUPS RL
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) || '%')