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

VIEW: APPS.OKL_CS_NOTES_UV

Object Details
Object Name: OKL_CS_NOTES_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_CS_NOTES_UV
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier in the database
JTF_NOTE_ID NUMBER
Yes
PARENT_NOTE_ID NUMBER

SOURCE_OBJECT_ID NUMBER
Yes
SOURCE_OBJECT_CODE VARCHAR2 (240) Yes
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
NOTES VARCHAR2 (2000) Yes
NOTES_DETAIL CLOB (4000)
ENTERED_BY NUMBER (15) Yes
ENTERED_DATE DATE
Yes
SOURCE_OBJECT_MEANING VARCHAR2 (30) Yes
NOTE_TYPE VARCHAR2 (30)
ENTERED_BY_NAME VARCHAR2 (360)
NOTE_STATUS VARCHAR2 (1)
NOTE_STATUS_MEANING VARCHAR2 (80) Yes
NOTE_TYPE_MEANING VARCHAR2 (80)
CONTEXT VARCHAR2 (30)
CONTRACT_ID NUMBER

Query Text

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


SELECT ROW_ID
,      JTF_NOTE_ID
,      PARENT_NOTE_ID
,      SOURCE_OBJECT_ID
,      SOURCE_OBJECT_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      NOTES
,      NOTES_DETAIL
,      ENTERED_BY
,      ENTERED_DATE
,      SOURCE_OBJECT_MEANING
,      NOTE_TYPE
,      ENTERED_BY_NAME
,      NOTE_STATUS
,      NOTE_STATUS_MEANING
,      NOTE_TYPE_MEANING
,      CONTEXT
,      CONTRACT_ID
FROM APPS.OKL_CS_NOTES_UV;

Dependencies

[top of page]

APPS.OKL_CS_NOTES_UV references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymJTF_IH_ACTIVITIES
SynonymJTF_NOTES_B
SynonymJTF_NOTES_TL
SynonymJTF_OBJECTS_TL
SynonymJTF_RS_RESOURCE_EXTNS

APPS.OKL_CS_NOTES_UV is not referenced by any database object