VIEW: APPS.RG_DSS_VAR_TEMPLATES_V

Source

View Text - Preformatted

SELECT ST.TEMPLATE_NAME, VT.ROWID ROW_ID, VT.VARIABLE_ID, VT.TEMPLATE_ID, VT.LAST_UPDATE_DATE, VT.LAST_UPDATED_BY, VT.LAST_UPDATE_LOGIN, VT.CREATION_DATE, VT.CREATED_BY, VT.SEGMENT1_TYPE, VT.SEGMENT2_TYPE, VT.SEGMENT3_TYPE, VT.SEGMENT4_TYPE, VT.SEGMENT5_TYPE, VT.SEGMENT6_TYPE, VT.SEGMENT7_TYPE, VT.SEGMENT8_TYPE, VT.SEGMENT9_TYPE, VT.SEGMENT10_TYPE, VT.SEGMENT11_TYPE, VT.SEGMENT12_TYPE, VT.SEGMENT13_TYPE, VT.SEGMENT14_TYPE, VT.SEGMENT15_TYPE, VT.SEGMENT16_TYPE, VT.SEGMENT17_TYPE, VT.SEGMENT18_TYPE, VT.SEGMENT19_TYPE, VT.SEGMENT20_TYPE, VT.SEGMENT21_TYPE, VT.SEGMENT22_TYPE, VT.SEGMENT23_TYPE, VT.SEGMENT24_TYPE, VT.SEGMENT25_TYPE, VT.SEGMENT26_TYPE, VT.SEGMENT27_TYPE, VT.SEGMENT28_TYPE, VT.SEGMENT29_TYPE, VT.SEGMENT30_TYPE, VT.CONTEXT, VT.ATTRIBUTE1, VT.ATTRIBUTE2, VT.ATTRIBUTE3, VT.ATTRIBUTE4, VT.ATTRIBUTE5, VT.ATTRIBUTE6, VT.ATTRIBUTE7, VT.ATTRIBUTE8, VT.ATTRIBUTE9, VT.ATTRIBUTE10, VT.ATTRIBUTE11, VT.ATTRIBUTE12, VT.ATTRIBUTE13, VT.ATTRIBUTE14, VT.ATTRIBUTE15 FROM GL_SUMMARY_TEMPLATES ST, RG_DSS_VAR_TEMPLATES VT WHERE VT.TEMPLATE_ID = ST.TEMPLATE_ID(+) AND ST.STATUS(+) = 'F'

View Text - HTML Formatted

SELECT ST.TEMPLATE_NAME
, VT.ROWID ROW_ID
, VT.VARIABLE_ID
, VT.TEMPLATE_ID
, VT.LAST_UPDATE_DATE
, VT.LAST_UPDATED_BY
, VT.LAST_UPDATE_LOGIN
, VT.CREATION_DATE
, VT.CREATED_BY
, VT.SEGMENT1_TYPE
, VT.SEGMENT2_TYPE
, VT.SEGMENT3_TYPE
, VT.SEGMENT4_TYPE
, VT.SEGMENT5_TYPE
, VT.SEGMENT6_TYPE
, VT.SEGMENT7_TYPE
, VT.SEGMENT8_TYPE
, VT.SEGMENT9_TYPE
, VT.SEGMENT10_TYPE
, VT.SEGMENT11_TYPE
, VT.SEGMENT12_TYPE
, VT.SEGMENT13_TYPE
, VT.SEGMENT14_TYPE
, VT.SEGMENT15_TYPE
, VT.SEGMENT16_TYPE
, VT.SEGMENT17_TYPE
, VT.SEGMENT18_TYPE
, VT.SEGMENT19_TYPE
, VT.SEGMENT20_TYPE
, VT.SEGMENT21_TYPE
, VT.SEGMENT22_TYPE
, VT.SEGMENT23_TYPE
, VT.SEGMENT24_TYPE
, VT.SEGMENT25_TYPE
, VT.SEGMENT26_TYPE
, VT.SEGMENT27_TYPE
, VT.SEGMENT28_TYPE
, VT.SEGMENT29_TYPE
, VT.SEGMENT30_TYPE
, VT.CONTEXT
, VT.ATTRIBUTE1
, VT.ATTRIBUTE2
, VT.ATTRIBUTE3
, VT.ATTRIBUTE4
, VT.ATTRIBUTE5
, VT.ATTRIBUTE6
, VT.ATTRIBUTE7
, VT.ATTRIBUTE8
, VT.ATTRIBUTE9
, VT.ATTRIBUTE10
, VT.ATTRIBUTE11
, VT.ATTRIBUTE12
, VT.ATTRIBUTE13
, VT.ATTRIBUTE14
, VT.ATTRIBUTE15
FROM GL_SUMMARY_TEMPLATES ST
, RG_DSS_VAR_TEMPLATES VT
WHERE VT.TEMPLATE_ID = ST.TEMPLATE_ID(+)
AND ST.STATUS(+) = 'F'