[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 |
APPS.SO_NOTE_USAGE_ATTR_V