[Home] [Help] [Dependency Information]
Object Name: | GR_ORDER_INFO_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GR.GR_ORDER_INFO_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Id uniquely identifying the rows. | |
ORDER_NO | VARCHAR2 | (40) | Order number assigned by either system or user, unique within an orgn . | |
ORDER_COMMENT | VARCHAR2 | (70) | Freeform text/Comments . | |
ORDER_ID | NUMBER | Surrogate key for order. | ||
AFROM_WHSE | VARCHAR2 | (40) | ||
BILLCUST_ID | NUMBER | Default third party to be invoiced . | ||
SHIPADDR_ID | NUMBER | Shipping destination . | ||
LINE_NO | NUMBER | Line number assigned by system for this order line. | ||
LINE_ID | NUMBER | Surrogate id for table, uniquely identifies each row. | ||
ITEM_ID | NUMBER | |||
SHIPCUST_ID | NUMBER | Default shipping(destination) customer . | ||
FROM_WHSE | VARCHAR2 | (40) | Shipping warehouse . | |
HOLDREAS_CODE | VARCHAR2 | (4) | Hold reason code default . | |
HOLD_CODE | VARCHAR2 | (4) | Hold reason code default | |
DELETE_MARK | NUMBER | 0 Active, 1 Marked for delete . | ||
COMPLETED_IND | NUMBER | Indicates "completed" status or order, 0(open), 1(shipped), -1 (cancelled) . | ||
ACTUAL_SHIPDATE | DATE | Actual shipdate, date defaults to system "zero date" . | ||
BOL_NO | VARCHAR2 | (32) | Bill of Lading number, unique within orgn . | |
BOL_COMMENT | VARCHAR2 | (500) | Freeform text . | |
BOL_ID | NUMBER | Surrogate id to uniquely identify this shipment . | ||
PICKING_IND | NUMBER | Indicates if the order should be held for picking . | ||
SHIPPING_IND | NUMBER | Indicates if the order should be held from release . | ||
ORDER_TYPE_ID | NUMBER | Unique identifier of user defined order type, assigned by system. | ||
CREATED_BY | NUMBER | Op code of user creating rows. | ||
CREATION_DATE | DATE | Date time row created.. | ||
LAST_UPDATED_BY | DATE | Op_code of user last changing row . | ||
LAST_UPDATE_DATE | NUMBER | Date time row last changed . | ||
LAST_UPDATE_LOGIN | NUMBER | Who Column . |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ORDER_NO
, ORDER_COMMENT
, ORDER_ID
, AFROM_WHSE
, BILLCUST_ID
, SHIPADDR_ID
, LINE_NO
, LINE_ID
, ITEM_ID
, SHIPCUST_ID
, FROM_WHSE
, HOLDREAS_CODE
, HOLD_CODE
, DELETE_MARK
, COMPLETED_IND
, ACTUAL_SHIPDATE
, BOL_NO
, BOL_COMMENT
, BOL_ID
, PICKING_IND
, SHIPPING_IND
, ORDER_TYPE_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.GR_ORDER_INFO_V;
|
|
|