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]

TABLE: CSM.CSM_DEBRIEF_HEADERS_INQ

Object Details

Object Name:	CSM_DEBRIEF_HEADERS_INQ
Object Type:	TABLE
Owner:	CSM
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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
CLID$$CS	VARCHAR2	(30)	Name of the Client(FNDUSER)
DEBRIEF_HEADER_ID	NUMBER		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
DMLTYPE$$	VARCHAR2	(1)	Type of the DML operation performed at the client
SEQNO$$	NUMBER	(10)	Sequence Nmber to uniquely identify this record, among the records, which were performed
TRANID$$	NUMBER	(10)	Id of the synch session in which this record was populated
VERSION$$	NUMBER	(10)	The identifier of the Version Number
TRAVEL_START_TIME	DATE		Indicates the value for travel start time
TRAVEL_END_TIME	DATE		Indicates the value for travel end time
TRAVEL_DISTANCE_IN_KM	NUMBER		Indicates the value for travel distance
CREATED_BY	NUMBER		Standard WHO Column
LAST_UPDATED_BY	NUMBER		Standard WHO Column
SERVER_LAST_UPDATE_DATE	DATE		Standard WHO Column

Query Text

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


SELECT CLID$$CS
,      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
,      DMLTYPE$$
,      SEQNO$$
,      TRANID$$
,      VERSION$$
,      TRAVEL_START_TIME
,      TRAVEL_END_TIME
,      TRAVEL_DISTANCE_IN_KM
,      CREATED_BY
,      LAST_UPDATED_BY
,      SERVER_LAST_UPDATE_DATE
FROM CSM.CSM_DEBRIEF_HEADERS_INQ;

Dependencies

[top of page]

CSM.CSM_DEBRIEF_HEADERS_INQ does not reference any database object

CSM.CSM_DEBRIEF_HEADERS_INQ is referenced by following:

APPS: CSM_DEBRIEF_HEADERS_INQ