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_SELECTION

Object Details

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

Contains a table which holds the information for which document is to be printed from the Sales Order Processing information.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GR_SELECTION_PK	NORMAL	UNIQUE	APPS_TS_NOLOGGING	BATCH_NO ORDER_NO ORDER_LINE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_NO	NUMBER		Yes	Contains the Batch Number for the document which is to be printed after selection from the Sales Order Processing information.
ORDER_NO	NUMBER	(10)	Yes	Contains the order number of the document to be printed.
ORDER_LINE_NUMBER	NUMBER		Yes	Contains the Order Line Number of the document to be printed.
LINE_STATUS	NUMBER	(5)	Yes	Contains the status of the document to be printed. The valid values are Selected, Not Selected, In Progress, Printed, and Updated.
DOCUMENT_CODE	VARCHAR2	(10)		The document type that the user has selected to print.
PRINT_FLAG	VARCHAR2	(1)	Yes	Contains the information as to whether or not the user wishes to actually print the document for this particular item.
USER_ID	NUMBER	(15)	Yes	Contains the User Id for the user who does a User Override.
ITEM_CODE	VARCHAR2	(32)	Yes	Contains the Item Number for which the document will be printed.
RECIPIENT_CODE	VARCHAR2	(32)	Yes	Contains the Code for the Recipient who will be receiving the order.
SHIPMENT_NO	VARCHAR2	(32)		Contains the Number of the Shipment that the document will be printed for.
MESSAGE	VARCHAR2	(2000)		Contains any information that should be added.
USER_OVERRIDE	VARCHAR2	(1)		Contains information as to whether or not there was a user override.
DATE_MSDS_SENT	DATE			Contains the information as to when the MSDS was sent.

Query Text

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


SELECT BATCH_NO
,      ORDER_NO
,      ORDER_LINE_NUMBER
,      LINE_STATUS
,      DOCUMENT_CODE
,      PRINT_FLAG
,      USER_ID
,      ITEM_CODE
,      RECIPIENT_CODE
,      SHIPMENT_NO
,      MESSAGE
,      USER_OVERRIDE
,      DATE_MSDS_SENT
FROM GR.GR_SELECTION;

Dependencies

[top of page]

GR.GR_SELECTION does not reference any database object

GR.GR_SELECTION is referenced by following:

APPS: GR_SELECTION