VIEW: APPS.RG_REPORT_DISPLAYS_V

Source

View Text - Preformatted

SELECT DS.ROWID , DS.REPORT_DISPLAY_ID , DS.REPORT_DISPLAY_SET_ID , DS.SEQUENCE , DS.ROW_GROUP_ID , RG.NAME ROW_GROUP , RS.NAME ROW_SET , RG.FROM_SEQUENCE ROW_FROM_SEQUENCE , RG.TO_SEQUENCE ROW_TO_SEQUENCE , DS.COLUMN_GROUP_ID , CG.NAME COLUMN_GROUP , CS.NAME COLUMN_SET , CG.FROM_SEQUENCE COLUMN_FROM_SEQUENCE , CG.TO_SEQUENCE COLUMN_TO_SEQUENCE , DS.DESCRIPTION , DS.DISPLAY_FLAG , DS.CREATION_DATE , DS.CREATED_BY , DS.LAST_UPDATE_DATE , DS.LAST_UPDATED_BY , DS.LAST_UPDATE_LOGIN , DS.CONTEXT , DS.ATTRIBUTE1 , DS.ATTRIBUTE2 , DS.ATTRIBUTE3 , DS.ATTRIBUTE4 , DS.ATTRIBUTE5 , DS.ATTRIBUTE6 , DS.ATTRIBUTE7 , DS.ATTRIBUTE8 , DS.ATTRIBUTE9 , DS.ATTRIBUTE10 , DS.ATTRIBUTE11 , DS.ATTRIBUTE12 , DS.ATTRIBUTE13 , DS.ATTRIBUTE14 , DS.ATTRIBUTE15 FROM RG_REPORT_DISPLAYS DS,RG_REPORT_DISPLAY_GROUPS RG,RG_REPORT_DISPLAY_GROUPS CG,RG_REPORT_AXIS_SETS RS,RG_REPORT_AXIS_SETS CS WHERE DS.ROW_GROUP_ID = RG.REPORT_DISPLAY_GROUP_ID(+) AND DS.COLUMN_GROUP_ID = CG.REPORT_DISPLAY_GROUP_ID(+) AND RG.ROW_SET_ID = RS.AXIS_SET_ID(+) AND CG.COLUMN_SET_ID = CS.AXIS_SET_ID(+)

View Text - HTML Formatted

SELECT DS.ROWID
, DS.REPORT_DISPLAY_ID
, DS.REPORT_DISPLAY_SET_ID
, DS.SEQUENCE
, DS.ROW_GROUP_ID
, RG.NAME ROW_GROUP
, RS.NAME ROW_SET
, RG.FROM_SEQUENCE ROW_FROM_SEQUENCE
, RG.TO_SEQUENCE ROW_TO_SEQUENCE
, DS.COLUMN_GROUP_ID
, CG.NAME COLUMN_GROUP
, CS.NAME COLUMN_SET
, CG.FROM_SEQUENCE COLUMN_FROM_SEQUENCE
, CG.TO_SEQUENCE COLUMN_TO_SEQUENCE
, DS.DESCRIPTION
, DS.DISPLAY_FLAG
, DS.CREATION_DATE
, DS.CREATED_BY
, DS.LAST_UPDATE_DATE
, DS.LAST_UPDATED_BY
, DS.LAST_UPDATE_LOGIN
, DS.CONTEXT
, DS.ATTRIBUTE1
, DS.ATTRIBUTE2
, DS.ATTRIBUTE3
, DS.ATTRIBUTE4
, DS.ATTRIBUTE5
, DS.ATTRIBUTE6
, DS.ATTRIBUTE7
, DS.ATTRIBUTE8
, DS.ATTRIBUTE9
, DS.ATTRIBUTE10
, DS.ATTRIBUTE11
, DS.ATTRIBUTE12
, DS.ATTRIBUTE13
, DS.ATTRIBUTE14
, DS.ATTRIBUTE15
FROM RG_REPORT_DISPLAYS DS
, RG_REPORT_DISPLAY_GROUPS RG
, RG_REPORT_DISPLAY_GROUPS CG
, RG_REPORT_AXIS_SETS RS
, RG_REPORT_AXIS_SETS CS
WHERE DS.ROW_GROUP_ID = RG.REPORT_DISPLAY_GROUP_ID(+)
AND DS.COLUMN_GROUP_ID = CG.REPORT_DISPLAY_GROUP_ID(+)
AND RG.ROW_SET_ID = RS.AXIS_SET_ID(+)
AND CG.COLUMN_SET_ID = CS.AXIS_SET_ID(+)