[Home] [Help] [Dependency Information]
Object Name: | GR_SELECTION_HEADER# |
---|---|
Object Type: | VIEW |
Owner: | GR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_NO | NUMBER | Yes | ||
STATUS | NUMBER | (5) | Yes | |
USER_ID | NUMBER | (15) | Yes | |
DOCUMENT_CODE | VARCHAR2 | (10) | ||
ORDER_FROM | NUMBER | (10) | ||
ORDER_TO | NUMBER | (10) | ||
SHIPMENT_FROM | NUMBER | (10) | ||
SHIPMENT_TO | NUMBER | (10) | ||
SHIPMENT_DATE_FROM | DATE | |||
SHIPMENT_DATE_TO | DATE | |||
TERRITORY_CODE | VARCHAR2 | (4) | Yes | |
ORGN_CODE | VARCHAR2 | (4) | Yes | |
WHSE_CODE | VARCHAR2 | (4) | Yes |
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#;
|
|
|