[Home] [Help]
View: AR_NOTES_V
Product: | AR - Receivables |
Description: | (Release 10SC Only) |
Implementation/DBA Data: |
APPS.AR_NOTES_V
|
View Text
SELECT N.ROWID
, N.NOTE_ID
, N.CUSTOMER_TRX_ID
, N.CREATION_DATE
, N.NOTE_TYPE
, L.MEANING
, N.TEXT
, N.LAST_UPDATED_BY
, N.LAST_UPDATE_DATE
, N.LAST_UPDATE_LOGIN
, N.CREATION_DATE
, N.CREATED_BY
FROM AR_NOTES N
, AR_LOOKUPS L
WHERE L.LOOKUP_TYPE = 'NOTE_TYPE'
AND N.NOTE_TYPE = L.LOOKUP_CODE
Columns
Name |
ROW_ID |
NOTE_ID |
CUSTOMER_TRX_ID |
NOTE_DATE |
NOTE_TYPE |
AL_NOTE_TYPE_MEANING |
TEXT |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
CREATION_DATE |
CREATED_BY |