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_QUOTE_HDRS_BALI_V

Object Details

Object Name:	ASO_PVT_CUST_QUOTE_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
QUOTE_NAME	VARCHAR2	(240)		Quote name
QUOTE_NUMBER	NUMBER		Yes	Quote number. Quote number and version uniquely identifies a quote
QUOTE_NUMBER_VERSION	VARCHAR2	(81)		Quote Number and Quote Version
CREATION_DATE	DATE		Yes	Quote Creation Date
QUOTE_STATUS	VARCHAR2	(0)		Quote Status
QUOTE_TOTAL	NUMBER			Total Amount of Quote
QUOTE_EXPIRATION_DATE	DATE			Expiration Date for the Quote
ACCOUNT_NUMBER	VARCHAR2	(0)		Customer Account Number
QUOTE_HEADER_ID	NUMBER		Yes	Quote Header Identifier
CUST_ACCOUNT_ID	NUMBER			Customer Account Id of the sold-to party, if sold-to party is of type person or organization. If sold-to party happens to be of type relationship, the customer accounr id will be that of the object of the relationship.
PARTY_ID	NUMBER			Customer Party Identifier
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency Code
SOLD_TO_CONTACT_NAME	VARCHAR2	(0)		Sold to contact name
RESOURCE_ID	NUMBER			Resource Identifier
RESOURCE_NAME	VARCHAR2	(0)		Resource Name
QTE_PARTY_ID	NUMBER			Party Id of the sold-to party. Can be of type person, organization, or party relationship.
APP_PARTY_TYPE	VARCHAR2	(0)		Party Type
QUOTE_STATUS_ID	NUMBER		Yes	Quote Status Id
OPERATING_UNIT	VARCHAR2	(240)	Yes	Current Operating Unit
ORG_ID	NUMBER			Organization Identifier

Query Text

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


SELECT QUOTE_NAME
,      QUOTE_NUMBER
,      QUOTE_NUMBER_VERSION
,      CREATION_DATE
,      QUOTE_STATUS
,      QUOTE_TOTAL
,      QUOTE_EXPIRATION_DATE
,      ACCOUNT_NUMBER
,      QUOTE_HEADER_ID
,      CUST_ACCOUNT_ID
,      PARTY_ID
,      CURRENCY_CODE
,      SOLD_TO_CONTACT_NAME
,      RESOURCE_ID
,      RESOURCE_NAME
,      QTE_PARTY_ID
,      APP_PARTY_TYPE
,      QUOTE_STATUS_ID
,      OPERATING_UNIT
,      ORG_ID
FROM APPS.ASO_PVT_CUST_QUOTE_HDRS_BALI_V;

Dependencies

[top of page]

APPS.ASO_PVT_CUST_QUOTE_HDRS_BALI_V references the following:

APPS: ASO_QUOTE_HEADERS_ALL; HR_OPERATING_UNITS; MO_GLOBAL - show dependent code

APPS.ASO_PVT_CUST_QUOTE_HDRS_BALI_V is not referenced by any database object