Product: | RG - Application Report Generator |
---|---|
Description: | 10SC ONLY |
Implementation/DBA Data: | APPS.RG_DSS_VAR_TEMPLATES_V |
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'