[Home] [Help] [Dependency Information]
Object Name: | GR_SELECTION_HEADER |
---|---|
Object Type: | TABLE |
Owner: | GR |
FND Design Data: | GR.GR_SELECTION_HEADER |
Subobject Name: | |
Status: | VALID |
Contains all the selection criteria for printing documents from Sales Orders that have been taken and/or shipped.
Tablespace: | APPS_TS_NOLOGGING |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GR_SELECTION_HEADER_PK | NORMAL | UNIQUE | APPS_TS_NOLOGGING | BATCH_NO |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_NO | NUMBER | Yes | Contains an assigned number which will serve as identification. | |
STATUS | NUMBER | (5) | Yes | Contains the status of the document to be printed. The valid values are Entered, Selected, In Progress, Restart, Printed, Rerun, Update in Progress, Updated and Voided. |
USER_ID | NUMBER | (15) | Yes | Contains the User Id of the user who makes the request. |
DOCUMENT_CODE | VARCHAR2 | (10) | Contains the type of document that the user wishes to print. | |
ORDER_FROM | NUMBER | (10) | Contains the Initial Order Number to look at. | |
ORDER_TO | NUMBER | (10) | Contains the last Order Number to look at. | |
SHIPMENT_FROM | NUMBER | (10) | Contains the first Shipment Number to look at. | |
SHIPMENT_TO | NUMBER | (10) | Contains the last Shipment Number to look at. | |
SHIPMENT_DATE_FROM | DATE | Contains the initial Shipment Date to look at. | ||
SHIPMENT_DATE_TO | DATE | Contains the last Shipment Date to look at. | ||
TERRITORY_CODE | VARCHAR2 | (4) | Yes | Territory code used for printing. |
ORGN_CODE | VARCHAR2 | (4) | Yes | Organization code used for printing. |
WHSE_CODE | VARCHAR2 | (4) | Yes | Warehouse code used for printing. |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_NO
, STATUS
, USER_ID
, DOCUMENT_CODE
, ORDER_FROM
, ORDER_TO
, SHIPMENT_FROM
, SHIPMENT_TO
, SHIPMENT_DATE_FROM
, SHIPMENT_DATE_TO
, TERRITORY_CODE
, ORGN_CODE
, WHSE_CODE
FROM GR.GR_SELECTION_HEADER;
GR.GR_SELECTION_HEADER does not reference any database object
GR.GR_SELECTION_HEADER is referenced by following:
|
|
|