DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.CSF_M_NOTES_V

Object Details
Object Name: CSF_M_NOTES_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

A public view which may be useful for custom reporting or other data
requirements.


This table contains information about notes


[View Source]

Columns
Name Datatype Length Mandatory Comments
ACCESS_ID NUMBER

The Unique Access Identifier
JTF_NOTE_ID NUMBER
Yes The Unique Note Identifier
SOURCE_OBJECT_ID NUMBER

Source Object Identifier
SOURCE_OBJECT_CODE VARCHAR2 (4000)
Source Object Code
NOTES VARCHAR2 (4000)
Notes Data
NOTE_STATUS VARCHAR2 (1)
Note Status
ENTERED_BY NUMBER

Person who entered the Note
ENTERED_DATE DATE

The Date on which note was entered
NOTE_TYPE VARCHAR2 (30)
The Type of the Note
LAST_UPDATE_DATE DATE

Standard WHO Information
PARENT_NOTE_ID NUMBER

SOURCE_NAME VARCHAR2 (360)
CREATED_BY NUMBER

LAST_UPDATED_BY NUMBER

SERVER_LAST_UPDATE_DATE DATE

NOTES_DETAIL CLOB (4000)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ACCESS_ID
,      JTF_NOTE_ID
,      SOURCE_OBJECT_ID
,      SOURCE_OBJECT_CODE
,      NOTES
,      NOTE_STATUS
,      ENTERED_BY
,      ENTERED_DATE
,      NOTE_TYPE
,      LAST_UPDATE_DATE
,      PARENT_NOTE_ID
,      SOURCE_NAME
,      CREATED_BY
,      LAST_UPDATED_BY
,      SERVER_LAST_UPDATE_DATE
,      NOTES_DETAIL
FROM APPS.CSF_M_NOTES_V;

Dependencies

[top of page]

APPS.CSF_M_NOTES_V references the following:

SchemaAPPS
PL/SQL PackageASG_BASE - show dependent code
SynonymASG_USER
SynonymCSM_NOTES_ACC
PL/SQL PackageCSM_UTIL_PKG - show dependent code
SynonymJTF_NOTES_B
SynonymJTF_NOTES_TL
SynonymJTF_RS_RESOURCE_EXTNS

APPS.CSF_M_NOTES_V is not referenced by any database object