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_HISTORY

Object Details

Object Name:	GR_DISPATCH_HISTORY
Object Type:	TABLE
Owner:	GR
FND Design Data:	GR.GR_DISPATCH_HISTORY
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:

Columns

Name	Datatype	Length	Mandatory	Comments
DISPATCH_HISTORY_ID	NUMBER		Yes	Dispatch History ID
DOCUMENT_ID	NUMBER		Yes	Document id
DOCUMENT_CODE	VARCHAR2	(10)		Document Code
ITEM	VARCHAR2	(240)	Yes	Item
ORGANIZATION_ID	NUMBER			Organziation id
INVENTORY_ITEM_ID	NUMBER			Inventory Item
RECIPIENT_ID	NUMBER		Yes	Recipient Info
RECIPIENT_SITE_ID	NUMBER		Yes	Recipient Site Info
DATE_SENT	DATE		Yes	Date sent to the recipient
DISPATCH_METHOD_CODE	VARCHAR2	(30)	Yes	Method of dispatch
CREATION_SOURCE	VARCHAR2	(30)	Yes	Source of creation
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		Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER			Standard Who Column

Query Text

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


SELECT DISPATCH_HISTORY_ID
,      DOCUMENT_ID
,      DOCUMENT_CODE
,      ITEM
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      RECIPIENT_ID
,      RECIPIENT_SITE_ID
,      DATE_SENT
,      DISPATCH_METHOD_CODE
,      CREATION_SOURCE
,      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_HISTORY;

Dependencies

[top of page]

GR.GR_DISPATCH_HISTORY does not reference any database object

GR.GR_DISPATCH_HISTORY is referenced by following:

APPS: GR_DISPATCH_HISTORY; GR_DISPATCH_HISTORY_TG