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_AK_QUOTE_OPPTY_V

Object Details

Object Name:	ASO_AK_QUOTE_OPPTY_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
O_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
O_ATTRIBUTE1	VARCHAR2	(240)		Descriptive flexfield segment
O_ATTRIBUTE10	VARCHAR2	(240)		Descriptive flexfield segment
O_ATTRIBUTE11	VARCHAR2	(240)		Descriptive flexfield segment
O_ATTRIBUTE12	VARCHAR2	(240)		Descriptive flexfield segment
O_ATTRIBUTE13	VARCHAR2	(240)		Descriptive flexfield segment
O_ATTRIBUTE14	VARCHAR2	(240)		Descriptive flexfield segment
O_ATTRIBUTE15	VARCHAR2	(240)		Descriptive flexfield segment
O_ATTRIBUTE16	VARCHAR2	(240)		Descriptive flexfield segment
O_ATTRIBUTE17	VARCHAR2	(240)		Descriptive flexfield segment
O_ATTRIBUTE18	VARCHAR2	(240)		Descriptive flexfield segment
O_ATTRIBUTE19	VARCHAR2	(240)		Descriptive flexfield segment
O_ATTRIBUTE2	VARCHAR2	(240)		Descriptive flexfield segment
O_ATTRIBUTE20	VARCHAR2	(240)		Descriptive flexfield segment
O_ATTRIBUTE3	VARCHAR2	(240)		Descriptive flexfield segment
O_ATTRIBUTE4	VARCHAR2	(240)		Descriptive flexfield segment
O_ATTRIBUTE5	VARCHAR2	(240)		Descriptive flexfield segment
O_ATTRIBUTE6	VARCHAR2	(240)		Descriptive flexfield segment
O_ATTRIBUTE7	VARCHAR2	(240)		Descriptive flexfield segment
O_ATTRIBUTE8	VARCHAR2	(240)		Descriptive flexfield segment
O_ATTRIBUTE9	VARCHAR2	(240)		Descriptive flexfield segment
O_AUTOMATIC_PRICE_FLAG	VARCHAR2	(1)		This flag is used to denote if the quote is in automatic or manual mode of pricing
O_AUTOMATIC_TAX_FLAG	VARCHAR2	(1)		This flag denotes if the calculation of tax is in automatic or manual mode
O_CONTRACT_ID	NUMBER			Contract identifier
O_CONTRACT_TEMPLATE_ID	NUMBER			Template identifier
O_CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
O_CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency code
O_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.
O_CUST_PARTY_ID	NUMBER			CUSTOMER PARTY IDENTIFIER
O_END_CUST_CUST_ACCT_ID	NUMBER			End Customer cust account Id Identifier
O_END_CUST_CUST_PTY_ID	NUMBER			End Customer cust party id identifier
O_END_CUST_PTY_ID	NUMBER			End Customer Party Identifier
O_END_CUST_PTY_SITE_ID	NUMBER			End Customer Party Site ID Identifier
O_INV_CUST_ACCT_ID	NUMBER			Bill to customer account identifier
O_INV_CUST_PTY_ID	NUMBER			INVOICE TO CUST PARTY IDENTIFIER
O_INV_PTY_ID	NUMBER			Bill to contact identifier
O_INV_PTY_SITE_ID	NUMBER			Bill to site identifier
O_LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
O_MKTING_SRC_CODE_ID	NUMBER			Campaign that is applied to this quote
O_OBJECT_VERSION_NUMBER	NUMBER			Used in hosted environments
O_ORDER_TYPE_ID	NUMBER			Order type identifier, determines the type of order to be created
O_ORG_ID	NUMBER			Organization identifier
O_PARTY_ID	NUMBER			Party Id of the sold-to party. Can be of type person, organization, or party relationship.
O_PHONE_ID	NUMBER			Phone Identifier
O_PRICE_FROZEN_DATE	DATE			Price Frozen Date
O_PRICE_LIST_ID	NUMBER			Price list identifier
O_QUOTE_EXP_DATE	DATE			Expiration date of the quote
O_QUOTE_HEADER_ID	NUMBER		Yes	Unique identifier for quote
O_QUOTE_NAME	VARCHAR2	(240)		Quote name
O_QUOTE_STATUS_ID	NUMBER		Yes	Quote status
O_RESOURCE_GRP_ID	NUMBER			RESOURCE GRP ID
O_RESOURCE_ID	NUMBER			RESOURCE Identifier from jtf_rs_srp_vl
O_SALES_CHANNEL_CODE	VARCHAR2	(30)		Sales Channel Code
O_SOLD_TO_PARTY_SITE_ID	NUMBER			SOLD TO PARTY SITE ID
O_APPLICATION_TYPE_CODE	VARCHAR2	(30)
O_QUOTE_TO_CUST_TYPE	VARCHAR2	(30)
O_OPPTY_ID	NUMBER
O_OPPTY_CURRENCY_CODE	VARCHAR2	(15)
O_OPPTY_CHANNEL_CODE	VARCHAR2	(30)
O_OPPTY_QUOTE_NAME	VARCHAR2	(240)
O_OPPTY_CUST_PARTY_ID	NUMBER
O_OPPTY_MKTG_SRC_CD_ID	NUMBER
O_OPPTY_SLD_PTY_ST_ID	NUMBER
O_OPPTY_SLD_TO_CONT_ID	NUMBER
O_CREDIT_CARD_CODE	VARCHAR2	(30)
O_CREDIT_CARD_EXP_DATE	DATE
O_CREDIT_CARD_HLD_NAME	VARCHAR2	(80)
O_CUST_PO_NUMBER	VARCHAR2	(50)
O_PAYMENT_REF_NUMBER	VARCHAR2	(240)
O_PAYMENT_TERM_ID	NUMBER
O_PAYMENT_TYPE_CODE	VARCHAR2	(30)
O_DEMAND_CLASS_CODE	VARCHAR2	(30)
O_FOB_CODE	VARCHAR2	(30)
O_FREIGHT_TERMS_CODE	VARCHAR2	(30)
O_PACKING_INSTRUCTIONS	VARCHAR2	(2000)
O_REQUEST_DATE	DATE
O_REQUEST_DATE_TYPE	VARCHAR2	(30)
O_SHIP_METHOD_CODE	VARCHAR2	(30)
O_SHIP_TO_CUST_ACCT_ID	NUMBER
O_SHIP_TO_CUST_PTY_ID	NUMBER
O_SHIP_TO_PTY_ID	NUMBER
O_SHIP_TO_PTY_SITE_ID	NUMBER
O_SHIPMENT_PRIORITY_CODE	VARCHAR2	(30)
O_SHIPPING_INSTRUCTIONS	VARCHAR2	(2000)

Query Text

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


SELECT O_ATTRIBUTE_CATEGORY
,      O_ATTRIBUTE1
,      O_ATTRIBUTE10
,      O_ATTRIBUTE11
,      O_ATTRIBUTE12
,      O_ATTRIBUTE13
,      O_ATTRIBUTE14
,      O_ATTRIBUTE15
,      O_ATTRIBUTE16
,      O_ATTRIBUTE17
,      O_ATTRIBUTE18
,      O_ATTRIBUTE19
,      O_ATTRIBUTE2
,      O_ATTRIBUTE20
,      O_ATTRIBUTE3
,      O_ATTRIBUTE4
,      O_ATTRIBUTE5
,      O_ATTRIBUTE6
,      O_ATTRIBUTE7
,      O_ATTRIBUTE8
,      O_ATTRIBUTE9
,      O_AUTOMATIC_PRICE_FLAG
,      O_AUTOMATIC_TAX_FLAG
,      O_CONTRACT_ID
,      O_CONTRACT_TEMPLATE_ID
,      O_CREATED_BY
,      O_CURRENCY_CODE
,      O_CUST_ACCOUNT_ID
,      O_CUST_PARTY_ID
,      O_END_CUST_CUST_ACCT_ID
,      O_END_CUST_CUST_PTY_ID
,      O_END_CUST_PTY_ID
,      O_END_CUST_PTY_SITE_ID
,      O_INV_CUST_ACCT_ID
,      O_INV_CUST_PTY_ID
,      O_INV_PTY_ID
,      O_INV_PTY_SITE_ID
,      O_LAST_UPDATE_DATE
,      O_MKTING_SRC_CODE_ID
,      O_OBJECT_VERSION_NUMBER
,      O_ORDER_TYPE_ID
,      O_ORG_ID
,      O_PARTY_ID
,      O_PHONE_ID
,      O_PRICE_FROZEN_DATE
,      O_PRICE_LIST_ID
,      O_QUOTE_EXP_DATE
,      O_QUOTE_HEADER_ID
,      O_QUOTE_NAME
,      O_QUOTE_STATUS_ID
,      O_RESOURCE_GRP_ID
,      O_RESOURCE_ID
,      O_SALES_CHANNEL_CODE
,      O_SOLD_TO_PARTY_SITE_ID
,      O_APPLICATION_TYPE_CODE
,      O_QUOTE_TO_CUST_TYPE
,      O_OPPTY_ID
,      O_OPPTY_CURRENCY_CODE
,      O_OPPTY_CHANNEL_CODE
,      O_OPPTY_QUOTE_NAME
,      O_OPPTY_CUST_PARTY_ID
,      O_OPPTY_MKTG_SRC_CD_ID
,      O_OPPTY_SLD_PTY_ST_ID
,      O_OPPTY_SLD_TO_CONT_ID
,      O_CREDIT_CARD_CODE
,      O_CREDIT_CARD_EXP_DATE
,      O_CREDIT_CARD_HLD_NAME
,      O_CUST_PO_NUMBER
,      O_PAYMENT_REF_NUMBER
,      O_PAYMENT_TERM_ID
,      O_PAYMENT_TYPE_CODE
,      O_DEMAND_CLASS_CODE
,      O_FOB_CODE
,      O_FREIGHT_TERMS_CODE
,      O_PACKING_INSTRUCTIONS
,      O_REQUEST_DATE
,      O_REQUEST_DATE_TYPE
,      O_SHIP_METHOD_CODE
,      O_SHIP_TO_CUST_ACCT_ID
,      O_SHIP_TO_CUST_PTY_ID
,      O_SHIP_TO_PTY_ID
,      O_SHIP_TO_PTY_SITE_ID
,      O_SHIPMENT_PRIORITY_CODE
,      O_SHIPPING_INSTRUCTIONS
FROM APPS.ASO_AK_QUOTE_OPPTY_V;

Dependencies

[top of page]

APPS.ASO_AK_QUOTE_OPPTY_V references the following:

APPS: ASO_PAYMENTS; ASO_QUOTE_HEADERS; ASO_QUOTE_RELATED_OBJECTS; ASO_SHIPMENTS

APPS.ASO_AK_QUOTE_OPPTY_V is referenced by following:

APPS: ASO_DEFAULTING_INT - show dependent code; ASO_DEFAULTING_UTIL - show dependent code; ASO_DEFAULTING_UTIL - show dependent code; ASO_QUOTE_OPPTY_DEF_HDLR - show dependent code; OE_QUOTE_OPPTY_SECURITY - show dependent code; QOT_DEFAULT_PVT - show dependent code