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]

VIEW: APPS.GR_ORDER_INFO_V

Object Details

Object Name:	GR_ORDER_INFO_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GR.GR_ORDER_INFO_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

View of Order Fulfillment tables and Order Management tables

[View Source]

Columns

Name	Datatype	Length	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)	From warehouse
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		Internal identifier of the item
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 .

Query Text

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;

Dependencies

[top of page]

APPS.GR_ORDER_INFO_V references the following:

APPS: OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; OE_TRANSACTION_TYPES_TL; OP_BILL_LAD; OP_HOLD_CDS; OP_ORDR_DTL; OP_ORDR_HDR; OP_ORDR_TYP_VL; WSH_DELIVERY_ASSIGNMENTS; WSH_DELIVERY_DETAILS; WSH_NEW_DELIVERIES

APPS.GR_ORDER_INFO_V is referenced by following:

APPS: GR_PROCESS_ORDERS - show dependent code; GR_PROCESS_ORDERS - show dependent code