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.OEBV_ORDER_HEADERS

Object Details

Object Name:	OEBV_ORDER_HEADERS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ONT.OEBV_ORDER_HEADERS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

BIS View for Order Headers - required for Oracle IT

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ORDER_NUMBER	NUMBER		Yes
CUSTOMER_NUMBER	NUMBER
DATE_ORDERED	DATE
CUSTOMER_PO_NUMBER	VARCHAR2	(50)
_LA:SALES_CHANNEL	CHAR	(62)
STATUS	VARCHAR2	(30)
_LA:TAX_EXEMPTED	CHAR	(52)
_LA:TAX_EXEMPT_REASON	CHAR	(63)
TAX_EXEMPT_NUMBER	VARCHAR2	(80)
CURRENCY	VARCHAR2	(15)
PAYMENT_TYPE_CODE	VARCHAR2	(30)
_LA:SHIPMENT_PRIORITY	CHAR	(70)
_LA:FREIGHT_TERMS	CHAR	(62)
_LA:BOOKED_FLAG	CHAR	(48)
_LA:CANCELLED_FLAG	CHAR	(51)
ORG_ID	NUMBER
HEADER_ID	NUMBER		Yes
ORDER_TYPE_ID	NUMBER		Yes
CUSTOMER_CONTACT_ID	NUMBER
AGREEMENT_ID	NUMBER
PRICE_LIST_ID	NUMBER
SHIP_TO_CUSTOMER_ID	NUMBER
SHIP_TO_CONTACT_ID	NUMBER
SHIP_FROM_ORG_ID	NUMBER
INVOICING_RULE_ID	NUMBER	(15)
BILL_TO_CUSTOMER_ID	NUMBER
BILL_TO_CONTACT_ID	NUMBER
PAYMENT_TERM_ID	NUMBER	(15)
SOURCE_ID	NUMBER
SALESPERSON_ID	NUMBER	(15)
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
END_CUSTOMER_ID	NUMBER			End Customer Id
END_CUSTOMER_CONTACT_ID	NUMBER			End Customer Contact Id
END_CUSTOMER_SITE_USE_ID	NUMBER			End Customer Site Use Id
_LA:IB_OWNER	CHAR	(49)		IB Owner
_LA:IB_CURRENT_LOCATION	CHAR	(71)		IB Current Location
_LA:IB_INSTALLED_AT_LOCATION	CHAR	(76)		Ib Installed At Location

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ORDER_NUMBER
,      CUSTOMER_NUMBER
,      DATE_ORDERED
,      CUSTOMER_PO_NUMBER
,      _LA:SALES_CHANNEL
,      STATUS
,      _LA:TAX_EXEMPTED
,      _LA:TAX_EXEMPT_REASON
,      TAX_EXEMPT_NUMBER
,      CURRENCY
,      PAYMENT_TYPE_CODE
,      _LA:SHIPMENT_PRIORITY
,      _LA:FREIGHT_TERMS
,      _LA:BOOKED_FLAG
,      _LA:CANCELLED_FLAG
,      ORG_ID
,      HEADER_ID
,      ORDER_TYPE_ID
,      CUSTOMER_CONTACT_ID
,      AGREEMENT_ID
,      PRICE_LIST_ID
,      SHIP_TO_CUSTOMER_ID
,      SHIP_TO_CONTACT_ID
,      SHIP_FROM_ORG_ID
,      INVOICING_RULE_ID
,      BILL_TO_CUSTOMER_ID
,      BILL_TO_CONTACT_ID
,      PAYMENT_TERM_ID
,      SOURCE_ID
,      SALESPERSON_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      END_CUSTOMER_ID
,      END_CUSTOMER_CONTACT_ID
,      END_CUSTOMER_SITE_USE_ID
,      _LA:IB_OWNER
,      _LA:IB_CURRENT_LOCATION
,      _LA:IB_INSTALLED_AT_LOCATION
FROM APPS.OEBV_ORDER_HEADERS;

Dependencies

[top of page]

APPS.OEBV_ORDER_HEADERS references the following:

APPS: OE_ORDER_HEADERS

APPS.OEBV_ORDER_HEADERS is not referenced by any database object