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: GR.GR_DISPATCH_HISTORIES

Object Details

Object Name:	GR_DISPATCH_HISTORIES
Object Type:	TABLE
Owner:	GR
FND Design Data:	GR.GR_DISPATCH_HISTORIES
Subobject Name:
Status:	VALID

Contains transaction information, such as who received what and when.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GR_DISPATCH_HISTORIES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	DOCUMENT_CODE DOCUMENT_TEXT_ID ITEM_CODE RECIPIENT_CODE DATE_MSDS_SENT
GR_DISPATCH_HISTORIES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DOCUMENT_TEXT_ID
GR_DISPATCH_HISTORIES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ITEM_CODE
GR_DISPATCH_HISTORIES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECIPIENT_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
DOCUMENT_CODE	VARCHAR2	(10)	Yes	The Document Code for the document.
DOCUMENT_TEXT_ID	NUMBER	(15)	Yes	The Text ID for the document that is being printed.
ITEM_CODE	VARCHAR2	(32)	Yes	The Item Code for the substance used in or produced by the process.
RECIPIENT_CODE	VARCHAR2	(32)	Yes	The recipient code.
DATE_MSDS_SENT	DATE		Yes	The date that the document was sent to the recipient (customer).
DISPATCH_METHOD_CODE	NUMBER	(2)		The method used to send the document such as fax, mail, etc..
COVER_LETTER_TEXT_ID	VARCHAR2	(10)		The Text ID for the cover letter that was sent with the document.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Structure Defining Column.
ATTRIBUTE1	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE16	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE17	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE18	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE19	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE20	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE21	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE22	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE23	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE24	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE25	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE26	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE27	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE28	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE29	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
ATTRIBUTE30	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column.
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column

Query Text

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


SELECT DOCUMENT_CODE
,      DOCUMENT_TEXT_ID
,      ITEM_CODE
,      RECIPIENT_CODE
,      DATE_MSDS_SENT
,      DISPATCH_METHOD_CODE
,      COVER_LETTER_TEXT_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM GR.GR_DISPATCH_HISTORIES;

Dependencies

[top of page]

GR.GR_DISPATCH_HISTORIES does not reference any database object

GR.GR_DISPATCH_HISTORIES is referenced by following:

GR: GR_DISPATCH_HISTORIES#