VIEW: APPS.RG_REPORT_REQUESTS_V

Source

View Text - Preformatted

SELECT RQ.ROWID ROW_ID, RQ.APPLICATION_ID, RQ.REPORT_REQUEST_ID, RQ.LAST_UPDATE_DATE, RQ.LAST_UPDATED_BY, RQ.LAST_UPDATE_LOGIN, RQ.CREATION_DATE, RQ.CREATED_BY, RQ.SEQUENCE, RQ.FORM_SUBMISSION_FLAG, RQ.CONCURRENT_REQUEST_ID, RQ.REPORT_SET_ID, RQ.REPORT_ID, RP.NAME REPORT_NAME, RP.REPORT_TITLE, RP.PARAMETER_SET_ID, AXR.AXIS_SET_ID ROW_SET_ID, AXR.NAME ROW_SET, AXC.AXIS_SET_ID COLUMN_SET_ID, AXC.NAME COLUMN_SET, RP.CONTENT_SET_ID R_CONTENT_SET_ID, RCOS.NAME R_CONTENT_SET, RP.ROW_ORDER_ID R_ROW_ORDER_ID, RROD.NAME R_ROW_ORDER, RP.REPORT_DISPLAY_SET_ID R_REPORT_DISPLAY_SET_ID, RRPD.NAME R_REPORT_DISPLAY_SET, RP.ROUNDING_OPTION R_ROUNDING_OPTION, RP.SEGMENT_OVERRIDE R_SEGMENT_OVERRIDE, RP.OVERRIDE_ALC_LEDGER_CURRENCY R_OVERRIDE_ALC_LEDGER_CURRENCY, RP.UNIT_OF_MEASURE_ID R_UNIT_OF_MEASURE_ID, RP.OUTPUT_OPTION R_OUTPUT_OPTION, RP.MINIMUM_DISPLAY_LEVEL MINIMUM_DISPLAY_LEVEL, RQ.CONTENT_SET_ID, COS.NAME CONTENT_SET, RQ.ROW_ORDER_ID, ROD.NAME ROW_ORDER, RQ.REPORT_DISPLAY_SET_ID, RPD.NAME REPORT_DISPLAY_SET, RQ.ROUNDING_OPTION, RQ.SEGMENT_OVERRIDE, RQ.OVERRIDE_ALC_LEDGER_CURRENCY, RQ.UNIT_OF_MEASURE_ID, RQ.OUTPUT_OPTION, RQ.ID_FLEX_CODE, RQ.STRUCTURE_ID, RQ.LEDGER_ID, RQ.ALC_LEDGER_CURRENCY, RQ.PERIOD_NAME, RQ.ACCOUNTING_DATE, RQ.EXCEPTIONS_FLAG, RQ.CONTEXT, RQ.ATTRIBUTE1, RQ.ATTRIBUTE2, RQ.ATTRIBUTE3, RQ.ATTRIBUTE4, RQ.ATTRIBUTE5, RQ.ATTRIBUTE6, RQ.ATTRIBUTE7, RQ.ATTRIBUTE8, RQ.ATTRIBUTE9, RQ.ATTRIBUTE10, RQ.ATTRIBUTE11, RQ.ATTRIBUTE12, RQ.ATTRIBUTE13, RQ.ATTRIBUTE14, RQ.ATTRIBUTE15, DECODE(RP.SECURITY_FLAG, 'Y', DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0, 'GL_DAS_FSG_REPORT_U', 'GL_DAS_FSG_REPORT', TO_CHAR(RQ.REPORT_ID), NULL, NULL, NULL, NULL, FND_GLOBAL.USER_NAME), 'T', 'Y', 'N'), 'Y') USE_PRIVILEGE FROM RG_REPORTS RP, RG_REPORT_REQUESTS RQ, RG_REPORT_DISPLAY_SETS RPD, RG_REPORT_CONTENT_SETS COS, RG_ROW_ORDERS ROD, RG_REPORT_AXIS_SETS AXR, RG_REPORT_AXIS_SETS AXC, RG_REPORT_DISPLAY_SETS RRPD, RG_REPORT_CONTENT_SETS RCOS, RG_ROW_ORDERS RROD WHERE RQ.REPORT_ID = RP.REPORT_ID AND RQ.ROW_ORDER_ID = ROD.ROW_ORDER_ID (+) AND RQ.CONTENT_SET_ID = COS.CONTENT_SET_ID (+) AND RQ.REPORT_DISPLAY_SET_ID = RPD.REPORT_DISPLAY_SET_ID (+) AND RP.ROW_SET_ID = AXR.AXIS_SET_ID AND RP.COLUMN_SET_ID = AXC.AXIS_SET_ID AND RP.REPORT_DISPLAY_SET_ID = RRPD.REPORT_DISPLAY_SET_ID(+) AND RP.CONTENT_SET_ID = RCOS.CONTENT_SET_ID(+) AND RP.ROW_ORDER_ID = RROD.ROW_ORDER_ID(+)

View Text - HTML Formatted

SELECT RQ.ROWID ROW_ID
, RQ.APPLICATION_ID
, RQ.REPORT_REQUEST_ID
, RQ.LAST_UPDATE_DATE
, RQ.LAST_UPDATED_BY
, RQ.LAST_UPDATE_LOGIN
, RQ.CREATION_DATE
, RQ.CREATED_BY
, RQ.SEQUENCE
, RQ.FORM_SUBMISSION_FLAG
, RQ.CONCURRENT_REQUEST_ID
, RQ.REPORT_SET_ID
, RQ.REPORT_ID
, RP.NAME REPORT_NAME
, RP.REPORT_TITLE
, RP.PARAMETER_SET_ID
, AXR.AXIS_SET_ID ROW_SET_ID
, AXR.NAME ROW_SET
, AXC.AXIS_SET_ID COLUMN_SET_ID
, AXC.NAME COLUMN_SET
, RP.CONTENT_SET_ID R_CONTENT_SET_ID
, RCOS.NAME R_CONTENT_SET
, RP.ROW_ORDER_ID R_ROW_ORDER_ID
, RROD.NAME R_ROW_ORDER
, RP.REPORT_DISPLAY_SET_ID R_REPORT_DISPLAY_SET_ID
, RRPD.NAME R_REPORT_DISPLAY_SET
, RP.ROUNDING_OPTION R_ROUNDING_OPTION
, RP.SEGMENT_OVERRIDE R_SEGMENT_OVERRIDE
, RP.OVERRIDE_ALC_LEDGER_CURRENCY R_OVERRIDE_ALC_LEDGER_CURRENCY
, RP.UNIT_OF_MEASURE_ID R_UNIT_OF_MEASURE_ID
, RP.OUTPUT_OPTION R_OUTPUT_OPTION
, RP.MINIMUM_DISPLAY_LEVEL MINIMUM_DISPLAY_LEVEL
, RQ.CONTENT_SET_ID
, COS.NAME CONTENT_SET
, RQ.ROW_ORDER_ID
, ROD.NAME ROW_ORDER
, RQ.REPORT_DISPLAY_SET_ID
, RPD.NAME REPORT_DISPLAY_SET
, RQ.ROUNDING_OPTION
, RQ.SEGMENT_OVERRIDE
, RQ.OVERRIDE_ALC_LEDGER_CURRENCY
, RQ.UNIT_OF_MEASURE_ID
, RQ.OUTPUT_OPTION
, RQ.ID_FLEX_CODE
, RQ.STRUCTURE_ID
, RQ.LEDGER_ID
, RQ.ALC_LEDGER_CURRENCY
, RQ.PERIOD_NAME
, RQ.ACCOUNTING_DATE
, RQ.EXCEPTIONS_FLAG
, RQ.CONTEXT
, RQ.ATTRIBUTE1
, RQ.ATTRIBUTE2
, RQ.ATTRIBUTE3
, RQ.ATTRIBUTE4
, RQ.ATTRIBUTE5
, RQ.ATTRIBUTE6
, RQ.ATTRIBUTE7
, RQ.ATTRIBUTE8
, RQ.ATTRIBUTE9
, RQ.ATTRIBUTE10
, RQ.ATTRIBUTE11
, RQ.ATTRIBUTE12
, RQ.ATTRIBUTE13
, RQ.ATTRIBUTE14
, RQ.ATTRIBUTE15
, DECODE(RP.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_FSG_REPORT_U'
, 'GL_DAS_FSG_REPORT'
, TO_CHAR(RQ.REPORT_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') USE_PRIVILEGE
FROM RG_REPORTS RP
, RG_REPORT_REQUESTS RQ
, RG_REPORT_DISPLAY_SETS RPD
, RG_REPORT_CONTENT_SETS COS
, RG_ROW_ORDERS ROD
, RG_REPORT_AXIS_SETS AXR
, RG_REPORT_AXIS_SETS AXC
, RG_REPORT_DISPLAY_SETS RRPD
, RG_REPORT_CONTENT_SETS RCOS
, RG_ROW_ORDERS RROD
WHERE RQ.REPORT_ID = RP.REPORT_ID
AND RQ.ROW_ORDER_ID = ROD.ROW_ORDER_ID (+)
AND RQ.CONTENT_SET_ID = COS.CONTENT_SET_ID (+)
AND RQ.REPORT_DISPLAY_SET_ID = RPD.REPORT_DISPLAY_SET_ID (+)
AND RP.ROW_SET_ID = AXR.AXIS_SET_ID
AND RP.COLUMN_SET_ID = AXC.AXIS_SET_ID
AND RP.REPORT_DISPLAY_SET_ID = RRPD.REPORT_DISPLAY_SET_ID(+)
AND RP.CONTENT_SET_ID = RCOS.CONTENT_SET_ID(+)
AND RP.ROW_ORDER_ID = RROD.ROW_ORDER_ID(+)