Product: | RG - Application Report Generator |
---|---|
Description: | 10SC ONLY |
Implementation/DBA Data: |
![]() |
SELECT PA.ROWID ROW_ID
, PA.PARAMETER_SET_ID
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATED_BY
, PA.LAST_UPDATE_LOGIN
, PA.CREATION_DATE
, PA.CREATED_BY
, PA.PARAMETER_NUM
, PA.PARAMETER_ID
, EN.ENCUMBRANCE_TYPE
, EN.DESCRIPTION
, PA.DATA_TYPE
, PA.CONTEXT
, PA.ATTRIBUTE1
, PA.ATTRIBUTE2
, PA.ATTRIBUTE3
, PA.ATTRIBUTE4
, PA.ATTRIBUTE5
, PA.ATTRIBUTE6
, PA.ATTRIBUTE7
, PA.ATTRIBUTE8
, PA.ATTRIBUTE9
, PA.ATTRIBUTE10
, PA.ATTRIBUTE11
, PA.ATTRIBUTE12
, PA.ATTRIBUTE13
, PA.ATTRIBUTE14
, PA.ATTRIBUTE15
FROM RG_REPORT_PARAMETERS PA
, GL_ENCUMBRANCE_TYPES EN
WHERE PA.DATA_TYPE = 'E'
AND PA.PARAMETER_ID = EN.ENCUMBRANCE_TYPE_ID