[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_NOLOGGING |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GR_SELECTION_PK | NORMAL | UNIQUE | APPS_TS_NOLOGGING |
BATCH_NO
ORDER_NO ORDER_LINE_NUMBER |
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. |
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;
GR.GR_SELECTION does not reference any database object
GR.GR_SELECTION is referenced by following:
|
|
|