eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.CSM_DEBRIEF_HEADERS_V

Object Details

Object Name:	CSM_DEBRIEF_HEADERS_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 Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ACCESS_ID	NUMBER			The Unique Access Identifier
DEBRIEF_HEADER_ID	NUMBER		Yes	The unique identifier for header
DEBRIEF_NUMBER	VARCHAR2	(4000)		The unique number for field service report
DEBRIEF_DATE	DATE			The field service report date
DEBRIEF_STATUS_ID	NUMBER			The Field Service Report status identifier
TASK_ASSIGNMENT_ID	NUMBER			The task assignment unique identifier
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 1
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 2
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 3
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 4
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 5
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 6
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 7
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 8
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 9
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 10
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 11
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 12
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 13
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 14
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 15
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
PROCESSED_FLAG	VARCHAR2	(40)		Status of debrief while being processed
LAST_UPDATE_DATE	DATE			Standard who column
TRAVEL_START_TIME	DATE
TRAVEL_END_TIME	DATE
TRAVEL_DISTANCE_IN_KM	NUMBER
CREATED_BY	NUMBER
LAST_UPDATED_BY	NUMBER
SERVER_LAST_UPDATE_DATE	DATE

Query Text

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


SELECT ACCESS_ID
,      DEBRIEF_HEADER_ID
,      DEBRIEF_NUMBER
,      DEBRIEF_DATE
,      DEBRIEF_STATUS_ID
,      TASK_ASSIGNMENT_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      PROCESSED_FLAG
,      LAST_UPDATE_DATE
,      TRAVEL_START_TIME
,      TRAVEL_END_TIME
,      TRAVEL_DISTANCE_IN_KM
,      CREATED_BY
,      LAST_UPDATED_BY
,      SERVER_LAST_UPDATE_DATE
FROM APPS.CSM_DEBRIEF_HEADERS_V;

Dependencies

[top of page]

APPS.CSM_DEBRIEF_HEADERS_V references the following:

APPS: ASG_BASE - show dependent code; CSF_DEBRIEF_HEADERS; CSM_DEBRIEF_HEADERS_ACC; CSM_UTIL_PKG - show dependent code

APPS.CSM_DEBRIEF_HEADERS_V is not referenced by any database object