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

Object Details

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

View Type

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

This is an ORG independent view and it is used in the orders tab in Telesales Ebusiness Center workbench to show the order information.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
HEADER_ID	NUMBER		Yes	Order Header Identifier
ORG_ID	NUMBER			Operating Unit which performed this transaction
ORG_NAME	VARCHAR2	(240)		Org Name
ORDER_NUMBER	NUMBER		Yes	Order Number
FLOW_STATUS_CODE	VARCHAR2	(30)		Flow Status Code
FLOW_STATUS	VARCHAR2	(80)		Flow Status
ORDER_TYPE_ID	NUMBER		Yes	Order Type Id
ORDER_TYPE	VARCHAR2	(30)	Yes	Order Type
ORDER_SOURCE_ID	NUMBER			Order Source Id
ORDER_SOURCE	VARCHAR2	(240)		Order Source
CREATION_DATE	DATE		Yes	Creation Date
TRANSACTIONAL_CURR_CODE	VARCHAR2	(15)		Transactional Currency Code
SOLD_TO_ORG_ID	NUMBER			Customer Id
SOLD_TO_CONTACT_ID	NUMBER			Contact Id of the Sold To customer
SOLD_TO_CONTACT	VARCHAR2	(383)		Contact name of the Sold To customer
ACCOUNT_NUMBER	VARCHAR2	(30)		Account Number
PARTY_ID	NUMBER	(15)		Party Id
SALESREP_NAME	VARCHAR2	(360)		Salesrep name
SALESREP_ID	NUMBER	(15)		Salesrep identifier
SALES_CHANNEL_CODE	VARCHAR2	(30)		Sales channel code
SALES_CHANNEL	VARCHAR2	(80)		Sales channel
ORDER_TOTAL	VARCHAR2	(0)		Order total
ORDER_TOTAL_NUMERIC	NUMBER			Order Total in numeric format as opposed to the character format of column ORDER TOTAL.

Query Text

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


SELECT HEADER_ID
,      ORG_ID
,      ORG_NAME
,      ORDER_NUMBER
,      FLOW_STATUS_CODE
,      FLOW_STATUS
,      ORDER_TYPE_ID
,      ORDER_TYPE
,      ORDER_SOURCE_ID
,      ORDER_SOURCE
,      CREATION_DATE
,      TRANSACTIONAL_CURR_CODE
,      SOLD_TO_ORG_ID
,      SOLD_TO_CONTACT_ID
,      SOLD_TO_CONTACT
,      ACCOUNT_NUMBER
,      PARTY_ID
,      SALESREP_NAME
,      SALESREP_ID
,      SALES_CHANNEL_CODE
,      SALES_CHANNEL
,      ORDER_TOTAL
,      ORDER_TOTAL_NUMERIC
FROM APPS.OE_AS_ORDER_HEADERS_V;

Dependencies

[top of page]

APPS.OE_AS_ORDER_HEADERS_V references the following:

APPS: AR_LOOKUPS; HR_OPERATING_UNITS; HZ_CUST_ACCOUNTS; HZ_CUST_ACCOUNT_ROLES; HZ_PARTIES; HZ_RELATIONSHIPS; JTF_RS_RESOURCE_EXTNS_VL; OE_LOOKUPS; OE_OE_TOTALS_SUMMARY - show dependent code; OE_ORDER_HEADERS_ALL; OE_ORDER_SOURCES; OE_TRANSACTION_TYPES_TL; RA_SALESREPS_ALL

APPS.OE_AS_ORDER_HEADERS_V is not referenced by any database object