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_PVT_CUST_ORDER_HDRS_BALI_V

Object Details

Object Name:	ASO_PVT_CUST_ORDER_HDRS_BALI_V
Object Type:	VIEW
Owner:	APPS
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
ORDER_NUMBER	NUMBER		Yes	User-visible number of the order
ORDER_TOTAL	NUMBER			Total Amount of the order
ORDERED_DATE	DATE			Ordered Date
PARTY_ID	NUMBER			Customer Contact
CUST_ACCOUNT_ID	NUMBER			Sold to customer
HEADER_ID	NUMBER		Yes	Order Header Identifier
QUOTE_NAME	VARCHAR2	(0)		Quote Name
QUOTE_NUMBER_VERS	VARCHAR2	(0)		Quote Number and Quote Version
ORDER_STATUS	VARCHAR2	(0)		Order Status
QUOTE_HEADER_ID	VARCHAR2	(0)		Quote Header Identifier
ACCOUNT_NUMBER	VARCHAR2	(0)		Customer Account Number
CURRENCY_CODE	VARCHAR2	(15)		Currency Code
SOLD_TO_CONTACT_NAME	VARCHAR2	(0)		Customer Contact Name
RESOURCE_ID	NUMBER	(15)		Resource Identifier
RESOURCE_NAME	VARCHAR2	(0)		Resource Name
QTE_PARTY_ID	VARCHAR2	(0)		Quote sold to customer party id
APP_PARTY_TYPE	VARCHAR2	(0)		Party Type
FLOW_STATUS_CODE	VARCHAR2	(30)		Workflow status for the header
OPERATING_UNIT	VARCHAR2	(240)	Yes	Current Operating Unit

Query Text

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


SELECT ORDER_NUMBER
,      ORDER_TOTAL
,      ORDERED_DATE
,      PARTY_ID
,      CUST_ACCOUNT_ID
,      HEADER_ID
,      QUOTE_NAME
,      QUOTE_NUMBER_VERS
,      ORDER_STATUS
,      QUOTE_HEADER_ID
,      ACCOUNT_NUMBER
,      CURRENCY_CODE
,      SOLD_TO_CONTACT_NAME
,      RESOURCE_ID
,      RESOURCE_NAME
,      QTE_PARTY_ID
,      APP_PARTY_TYPE
,      FLOW_STATUS_CODE
,      OPERATING_UNIT
FROM APPS.ASO_PVT_CUST_ORDER_HDRS_BALI_V;

Dependencies

[top of page]

APPS.ASO_PVT_CUST_ORDER_HDRS_BALI_V references the following:

APPS: ASO_ORDER_INT - show dependent code; HR_OPERATING_UNITS; MO_GLOBAL - show dependent code; OE_ORDER_HEADERS_ALL

APPS.ASO_PVT_CUST_ORDER_HDRS_BALI_V is not referenced by any database object