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_DOCUMENT_PRINT

Object Details

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

Contains print information for the document by Item Code, Document Code, and Date.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GR_DOCUMENT_PRINT_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	DOCUMENT_TEXT_ID
GR_DOCUMENT_PRINT_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DOCUMENT_CODE
GR_DOCUMENT_PRINT_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LANGUAGE
GR_DOCUMENT_PRINT_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ITEM_CODE
GR_DOCUMENT_PRINT_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DISCLOSURE_CODE_COUNTRY
GR_DOCUMENT_PRINT_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DISCLOSURE_CODE_RECIPIENT

Columns

Name	Datatype	Length	Mandatory	Comments
DOCUMENT_TEXT_ID	NUMBER	(15)	Yes	The Text ID for the document that is being printed.
DOCUMENT_CODE	VARCHAR2	(10)	Yes	The Document Code for the document.
LANGUAGE	VARCHAR2	(4)	Yes	The two character code which is assigned for each language in which the data sheets will be created.
ITEM_CODE	VARCHAR2	(32)	Yes	The Item Code for the substance used in or produced by the process.
DISCLOSURE_CODE_COUNTRY	VARCHAR2	(10)	Yes	Disclosure Codes are used to assign value(s) to reporting levels (disclosure percentages) by country or recipient.
DISCLOSURE_CODE_RECIPIENT	VARCHAR2	(10)	Yes	Disclosure Codes are used to assign value(s) to reporting levels (disclosure percentages) by country or recipient.
MSDS_DATE	DATE			The date format in which dates print on the document. Valid date formats are: MM/DD/YY, DD/MM/YY, DD-MON-YYYY.
DOC_FROM_DATE	DATE		Yes	The date that the document is valid from. Valid date formats are: MM/DD/YY, DD/MM/YY, DD-MON-YYYY.
DOC_TO_DATE	DATE			The date that the document is valid from. Valid date formats are: MM/DD/YY, DD/MM/YY, DD-MON-YYYY.
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_TEXT_ID
,      DOCUMENT_CODE
,      LANGUAGE
,      ITEM_CODE
,      DISCLOSURE_CODE_COUNTRY
,      DISCLOSURE_CODE_RECIPIENT
,      MSDS_DATE
,      DOC_FROM_DATE
,      DOC_TO_DATE
,      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_DOCUMENT_PRINT;

Dependencies

[top of page]

GR.GR_DOCUMENT_PRINT does not reference any database object

GR.GR_DOCUMENT_PRINT is referenced by following:

APPS: GR_DOCUMENT_PRINT