[Home] [Help]
View: AST_NOTES_LITE_VL
Product: | AST - TeleSales |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT B.JTF_NOTE_ID
, B.SOURCE_OBJECT_ID
, B.SOURCE_OBJECT_CODE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, T.NOTES
, B.ENTERED_BY
, B.ENTERED_DATE
, OT.NAME
, B.NOTE_TYPE
, RES.SOURCE_NAME
, B.NOTE_STATUS
FROM JTF_RS_RESOURCE_EXTNS RES
, JTF_NOTES_B B
, JTF_NOTES_TL T
, JTF_OBJECTS_TL OT
WHERE B.JTF_NOTE_ID = T.JTF_NOTE_ID
AND T.LANGUAGE = USERENV('LANG')
AND B.SOURCE_OBJECT_CODE = OT.OBJECT_CODE
AND OT.LANGUAGE = USERENV('LANG')
AND RES.USER_ID(+) = B.CREATED_BY
Columns
Name |
JTF_NOTE_ID |
SOURCE_OBJECT_ID |
SOURCE_OBJECT_CODE |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
NOTES |
ENTERED_BY |
ENTERED_DATE |
SOURCE_OBJECT_MEANING |
NOTE_TYPE |
ENTERED_BY_NAME |
NOTE_STATUS |