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


VIEW: APPS.CS_SR_TASK_DEBRIEF_NOTES_V

Object Details
Object Name: CS_SR_TASK_DEBRIEF_NOTES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCS.CS_SR_TASK_DEBRIEF_NOTES_V
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

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
INCIDENT_ID NUMBER (15) Yes This column stores the SR id (incident id)
ID NUMBER
Yes This column stores the note id
APP_OBJ_ID NUMBER
Yes This column stores the source id in the JTF notes table
APP_OBJ_CODE VARCHAR2 (240) Yes This column stores the source object code in the JTF notes table
NOTE_TYPE_CODE VARCHAR2 (30)
This column stores the note type code
NOTE_TYPE_MEANING VARCHAR2 (80)
This column stores the note type meaning
NOTE VARCHAR2 (2000) Yes This column stores the description of the note
TRUE_STMT CHAR (1)
This column stores a boolean value 'Y' or 'N'
CREATION_DATE DATE
Yes This column stores the note creation date
CREATED_BY NUMBER (15) Yes This column stores the user id of the creator of the note
LAST_UPDATE_DATE DATE
Yes This column stores the date when the note was last updated
LAST_UPDATED_BY NUMBER (15) Yes This column stores the user ifd of the last updated user.
LAST_UPDATE_LOGIN NUMBER (15)
This column stores the user id of the last user logged in.
RECORD_SOURCE_TYPE CHAR (12)
The value in this column determines the source of the note.
NOTE_STATUS VARCHAR2 (1)
This column stores the note status code
NOTE_STATUS_MEANING VARCHAR2 (80)
This column stores the note status description
OBJ_ID NUMBER
Yes This column stores the contract line id
OBJ_NUMBER VARCHAR2 (50) Yes This column stores the contract number associated to the SR.
USER_NAME VARCHAR2 (100) Yes This column stores the login user_name
SOURCE VARCHAR2 (131)
This column stores the concatenation of the source code and source number
IS_DETAIL VARCHAR2 (1)
This column indicates if note detail exists.
Query Text

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


SELECT INCIDENT_ID
,      ID
,      APP_OBJ_ID
,      APP_OBJ_CODE
,      NOTE_TYPE_CODE
,      NOTE_TYPE_MEANING
,      NOTE
,      TRUE_STMT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      RECORD_SOURCE_TYPE
,      NOTE_STATUS
,      NOTE_STATUS_MEANING
,      OBJ_ID
,      OBJ_NUMBER
,      USER_NAME
,      SOURCE
,      IS_DETAIL
FROM APPS.CS_SR_TASK_DEBRIEF_NOTES_V;

Dependencies

[top of page]

APPS.CS_SR_TASK_DEBRIEF_NOTES_V references the following:

SchemaAPPS
SynonymCSF_DEBRIEF_HEADERS
SynonymCS_INCIDENTS_ALL_B
ViewCS_LOOKUPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymFND_USER
SynonymJTF_NOTES_B
SynonymJTF_NOTES_TL
SynonymJTF_TASKS_B
SynonymJTF_TASK_ASSIGNMENTS
SchemaPUBLIC
SynonymDBMS_LOB

APPS.CS_SR_TASK_DEBRIEF_NOTES_V is not referenced by any database object