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

Object Details

Object Name:	ASO_I_ORDER_HEADERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ASO.ASO_I_ORDER_HEADERS_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
HEADER_ID	NUMBER		Yes	order header id. Unique identifier of an order
ORG_ID	NUMBER			Organization identifier
SOURCE_DOCUMENT_TYPE_ID	NUMBER			source information from where this order originated
SOURCE_DOCUMENT_ID	NUMBER			SOURCE DOCUMENT IDENTIFIER
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
ORIG_SYS_DOCUMENT_REF	VARCHAR2	(50)		Order original source information
ORDER_NUMBER	NUMBER		Yes	user visible order identifier
ORDER_TYPE_ID	NUMBER		Yes	order type identifier (e.g., Standard, Return etc)
ORDER_TYPE_NAME	VARCHAR2	(30)	Yes	order type name
ORDERED_DATE	DATE			Date order was placed
PRICE_LIST_ID	NUMBER			price list used for this order
CUST_ACCT_ID	NUMBER			sold to customer. Foreign key reference to hz_cust_accounts
CUSTOMER_NAME	VARCHAR2	(360)	Yes	sold to customer name
CUSTOMER_NUMBER	VARCHAR2	(30)	Yes	user visible customer identifier
PARTY_ID	NUMBER	(15)	Yes	party id of the sold to customer. Foregn key reference to hz_parties
CONTACT_PARTY_ID	NUMBER	(15)		CONTACT PARTY IDENTIFIER
CONTACT_ACCT_ID	NUMBER	(15)		CONTACT ACCT IDENTIFIER
SALESREP_ID	NUMBER	(15)		Primary salesrep on this order
PAYMENT_AMOUNT	NUMBER			Amount being paid
CURRENCY_CODE	VARCHAR2	(15)		Currency for this order
AGREEMENT_ID	NUMBER			Agreement associated with the order
CUST_PO_NUMBER	VARCHAR2	(50)		Customer purchase order number
PAYMENT_TYPE_CODE	VARCHAR2	(30)		Payment type
CANCELLED_FLAG	VARCHAR2	(1)		Indicates whether the order has been cancelled ('Y') or not ('N')
OPEN_FLAG	VARCHAR2	(1)	Yes	Indicates whether the order has been closed('Y') or not ('N')
BOOKED_FLAG	VARCHAR2	(1)	Yes	Indicates whether the order has been booked('Y') or not ('N')
SHIP_TO_ORG_ID	NUMBER			Order level ship to customer/address information
INVOICE_TO_ORG_ID	NUMBER			Order level bill to customer/address information
INVOICE_TO_CONTACT_ID	NUMBER			Order level invoice contact information
ORDER_SOURCE_ID	NUMBER			orginating source of the order
RETURN_REASON_CODE	VARCHAR2	(30)		reason for return
SALES_CHANNEL_CODE	VARCHAR2	(30)		Sales channel through which order was placed
EXCHANGE_RATE	NUMBER			Rate of currency conversion
EXCHANGE_TYPE_CODE	VARCHAR2	(30)		Type of currency conversion
PAYMENT_TERM_ID	NUMBER	(15)		Payment terms
PAYMENT_TERM	VARCHAR2	(15)		Payment terms
INVOICE_TO_ADDRESS1	VARCHAR2	(240)		Address line 1 of invoice address
INVOICE_TO_ADDRESS2	VARCHAR2	(240)		Address line 2 of invoice address
INVOICE_TO_ADDRESS3	VARCHAR2	(240)		Address line 3 of invoice address
INVOICE_TO_ADDRESS4	VARCHAR2	(0)		Address line 4 of invoice address
INVOICE_TO_CITY	VARCHAR2	(60)		City for invoice address
INVOICE_TO_STATE	VARCHAR2	(60)		State for invoice address
INVOICE_TO_POSTAL_CODE	VARCHAR2	(60)		Postal Code for invoice address
INVOICE_TO_COUNTY	VARCHAR2	(0)		County for invoice address
INVOICE_TO_PROVINCE	VARCHAR2	(0)		Province for invoice address
INVOICE_TO_COUNTRY	VARCHAR2	(60)		Country for invoice address
INVOICE_TO_COUNTRY_CODE	VARCHAR2	(0)		Country code for invoice address
SHIP_TO_ADDRESS1	VARCHAR2	(240)		Address line 1 of ship address
SHIP_TO_ADDRESS2	VARCHAR2	(240)		Address line 2 of ship address
SHIP_TO_ADDRESS3	VARCHAR2	(240)		Address line 3 of ship address
SHIP_TO_ADDRESS4	VARCHAR2	(0)		Address line 4 of ship address
SHIP_TO_CITY	VARCHAR2	(60)		City of ship address
SHIP_TO_STATE	VARCHAR2	(60)		State of ship address
SHIP_TO_POSTAL_CODE	VARCHAR2	(60)		Postal code of ship address
SHIP_TO_COUNTY	VARCHAR2	(0)		County of ship address
SHIP_TO_PROVINCE	VARCHAR2	(0)		Province of ship address
SHIP_TO_COUNTRY	VARCHAR2	(60)		County of ship address
SHIP_TO_COUNTRY_CODE	VARCHAR2	(0)		country code of ship address
SHIP_METHOD_CODE	VARCHAR2	(30)		Ship method
FREIGHT_CARRIER_CODE	VARCHAR2	(30)		Freight carrier
FOB_POINT_CODE	VARCHAR2	(30)		Point of ownership transfer
FREIGHT_TERMS_CODE	VARCHAR2	(30)		Freight terms
SHIPMENT_PRIORITY_CODE	VARCHAR2	(30)		Shipment priority
REQUEST_DATE	DATE			Customer request date
TAX_EXEMPT_FLAG	VARCHAR2	(1)		Tax exempt indicator
TAX_EXEMPT_NUMBER	VARCHAR2	(80)		TAx exempt certificate number
TAX_EXEMPT_REASON_CODE	VARCHAR2	(30)		Tax exemption reason
MARKETING_SOURCE_CODE_ID	NUMBER			Campaign that is applied to this order
ORDER_CATEGORY_CODE	VARCHAR2	(30)	Yes	order category
VERSION_NUMBER	NUMBER		Yes	version number and order number can be used to uniquely identify an order
CREDIT_CARD_CODE	VARCHAR2	(80)		Credit card name
CREDIT_CARD_NUMBER	VARCHAR2	(80)		Credit card number
CREDIT_CARD_EXPIRATION_DATE	DATE			Credit card expiration date

Query Text

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


SELECT HEADER_ID
,      ORG_ID
,      SOURCE_DOCUMENT_TYPE_ID
,      SOURCE_DOCUMENT_ID
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      ORIG_SYS_DOCUMENT_REF
,      ORDER_NUMBER
,      ORDER_TYPE_ID
,      ORDER_TYPE_NAME
,      ORDERED_DATE
,      PRICE_LIST_ID
,      CUST_ACCT_ID
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      PARTY_ID
,      CONTACT_PARTY_ID
,      CONTACT_ACCT_ID
,      SALESREP_ID
,      PAYMENT_AMOUNT
,      CURRENCY_CODE
,      AGREEMENT_ID
,      CUST_PO_NUMBER
,      PAYMENT_TYPE_CODE
,      CANCELLED_FLAG
,      OPEN_FLAG
,      BOOKED_FLAG
,      SHIP_TO_ORG_ID
,      INVOICE_TO_ORG_ID
,      INVOICE_TO_CONTACT_ID
,      ORDER_SOURCE_ID
,      RETURN_REASON_CODE
,      SALES_CHANNEL_CODE
,      EXCHANGE_RATE
,      EXCHANGE_TYPE_CODE
,      PAYMENT_TERM_ID
,      PAYMENT_TERM
,      INVOICE_TO_ADDRESS1
,      INVOICE_TO_ADDRESS2
,      INVOICE_TO_ADDRESS3
,      INVOICE_TO_ADDRESS4
,      INVOICE_TO_CITY
,      INVOICE_TO_STATE
,      INVOICE_TO_POSTAL_CODE
,      INVOICE_TO_COUNTY
,      INVOICE_TO_PROVINCE
,      INVOICE_TO_COUNTRY
,      INVOICE_TO_COUNTRY_CODE
,      SHIP_TO_ADDRESS1
,      SHIP_TO_ADDRESS2
,      SHIP_TO_ADDRESS3
,      SHIP_TO_ADDRESS4
,      SHIP_TO_CITY
,      SHIP_TO_STATE
,      SHIP_TO_POSTAL_CODE
,      SHIP_TO_COUNTY
,      SHIP_TO_PROVINCE
,      SHIP_TO_COUNTRY
,      SHIP_TO_COUNTRY_CODE
,      SHIP_METHOD_CODE
,      FREIGHT_CARRIER_CODE
,      FOB_POINT_CODE
,      FREIGHT_TERMS_CODE
,      SHIPMENT_PRIORITY_CODE
,      REQUEST_DATE
,      TAX_EXEMPT_FLAG
,      TAX_EXEMPT_NUMBER
,      TAX_EXEMPT_REASON_CODE
,      MARKETING_SOURCE_CODE_ID
,      ORDER_CATEGORY_CODE
,      VERSION_NUMBER
,      CREDIT_CARD_CODE
,      CREDIT_CARD_NUMBER
,      CREDIT_CARD_EXPIRATION_DATE
FROM APPS.ASO_I_ORDER_HEADERS_V;

Dependencies

[top of page]

APPS.ASO_I_ORDER_HEADERS_V references the following:

APPS: HZ_CUST_ACCOUNTS; HZ_CUST_ACCOUNT_ROLES; HZ_PARTIES; OE_INVOICE_TO_ORGS_V; OE_ORDER_HEADERS; OE_SHIP_TO_ORGS_V; OE_TRANSACTION_TYPES_VL; RA_TERMS_VL

APPS.ASO_I_ORDER_HEADERS_V is referenced by following:

APPS: ASO_RETURNS_V; BIM_FCTV_OPPR_CYCLE; BIM_FCTV_SALES_CYCLE