[Home] [Help]
View: SO_NOTE_USAGE_ATTR_V
View Text
SELECT NUA.ROWID
, NUA.USAGE_ID
, NUA.CREATION_DATE
, NUA.CREATED_BY
, NUA.LAST_UPDATE_DATE
, NUA.LAST_UPDATED_BY
, NUA.LAST_UPDATE_LOGIN
, NUA.REPORT_ID
, NUA.FORMAT_CODE
, SR.DESCRIPTION
, SL.MEANING
FROM SO_LOOKUPS SL
, SO_REPORTS SR
, SO_NOTE_USAGE_ATTRIBUTES NUA
WHERE NUA.REPORT_ID = SR.REPORT_ID
AND NUA.FORMAT_CODE = SL.LOOKUP_CODE
AND SL.LOOKUP_TYPE = 'NOTE_FORMAT'
Columns
Name |
ROW_ID |
USAGE_ID |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
REPORT_ID |
FORMAT_CODE |
REPORT_DESCRIPTION |
FORMAT_MEANING |