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_RELATED_RECORDS_V

Object Details

Object Name:	ASO_AK_QUOTE_RELATED_RECORDS_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	Comments
R_CONTRACT_ID	NUMBER		Contract identifier
R_PRICE_LIST_ID	NUMBER		Price list identifier
R_INVOICE_TO_CUST_ACCOUNT_ID	NUMBER		Bill to customer account identifier
R_INVOICE_TO_CUST_PARTY_ID	NUMBER		INVOICE TO CUST PARTY IDENTIFIER
R_INVOICE_TO_PARTY_ID	NUMBER		Bill to contact identifier
R_INVOICE_TO_PARTY_SITE_ID	NUMBER		Bill to site identifier
R_SHIP_TO_CUST_ACCOUNT_ID	NUMBER		Ship tp customer account identier
R_SHIP_TO_CUST_PARTY_ID	NUMBER		SHIP TO CUST PARTY IDENTIFIER
R_SHIP_TO_PARTY_ID	NUMBER		Ship to contact identifier
R_SHIP_TO_PARTY_SITE_ID	NUMBER		Ship to site use identifier
R_END_CUSTOMER_CUST_ACCOUNT_ID	NUMBER		End Customer cust account Id Identifier
R_END_CUSTOMER_CUST_PARTY_ID	NUMBER		End Customer cust party id identifier
R_END_CUSTOMER_PARTY_ID	NUMBER		End Customer Party Identifier
R_END_CUSTOMER_PARTY_SITE_ID	NUMBER		End Customer Party Site ID Identifier
R_PAYMENT_TERM_ID	NUMBER		Payment term identifier
R_CUST_PO_NUMBER	VARCHAR2	(50)	Customer PO number
R_PAYMENT_TYPE_CODE	VARCHAR2	(30)	Payment type code from ASO_I_PAYMENT_TYPES_V
R_CREDIT_CARD_CODE	VARCHAR2	(30)	Credit card code
R_CREDIT_CARD_EXPIRATION_DATE	DATE		Credit card expiration date
R_CREDIT_CARD_HOLDER_NAME	VARCHAR2	(80)	Name of credit card holder
R_PAYMENT_REF_NUMBER	VARCHAR2	(240)	Stores the reference number for the selected payment_type_code. For example, if payment type is Credit Card, this column stores the credit card number.
R_REQUEST_DATE	DATE		Need by date
R_SHIP_METHOD_CODE	VARCHAR2	(30)	Freight Carrier and method. Foreign key to table Org_Freight
R_SHIPMENT_PRIORITY_CODE	VARCHAR2	(30)	SHIPMENT PRIORITY CODE
R_FREIGHT_TERMS_CODE	VARCHAR2	(30)	Freight term. Applicable only at header level
R_FOB_CODE	VARCHAR2	(30)	Point of ownership transfer
R_DEMAND_CLASS_CODE	VARCHAR2	(30)	Demand Class Code
R_SHIPPING_INSTRUCTIONS	VARCHAR2	(2000)	Special shipping instructions
R_PACKING_INSTRUCTIONS	VARCHAR2	(2000)	Special packing instructions

Query Text

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


SELECT R_CONTRACT_ID
,      R_PRICE_LIST_ID
,      R_INVOICE_TO_CUST_ACCOUNT_ID
,      R_INVOICE_TO_CUST_PARTY_ID
,      R_INVOICE_TO_PARTY_ID
,      R_INVOICE_TO_PARTY_SITE_ID
,      R_SHIP_TO_CUST_ACCOUNT_ID
,      R_SHIP_TO_CUST_PARTY_ID
,      R_SHIP_TO_PARTY_ID
,      R_SHIP_TO_PARTY_SITE_ID
,      R_END_CUSTOMER_CUST_ACCOUNT_ID
,      R_END_CUSTOMER_CUST_PARTY_ID
,      R_END_CUSTOMER_PARTY_ID
,      R_END_CUSTOMER_PARTY_SITE_ID
,      R_PAYMENT_TERM_ID
,      R_CUST_PO_NUMBER
,      R_PAYMENT_TYPE_CODE
,      R_CREDIT_CARD_CODE
,      R_CREDIT_CARD_EXPIRATION_DATE
,      R_CREDIT_CARD_HOLDER_NAME
,      R_PAYMENT_REF_NUMBER
,      R_REQUEST_DATE
,      R_SHIP_METHOD_CODE
,      R_SHIPMENT_PRIORITY_CODE
,      R_FREIGHT_TERMS_CODE
,      R_FOB_CODE
,      R_DEMAND_CLASS_CODE
,      R_SHIPPING_INSTRUCTIONS
,      R_PACKING_INSTRUCTIONS
FROM APPS.ASO_AK_QUOTE_RELATED_RECORDS_V;

Dependencies

[top of page]

APPS.ASO_AK_QUOTE_RELATED_RECORDS_V references the following:

APPS: ASO_PAYMENTS; ASO_QUOTE_HEADERS_ALL; ASO_SHIPMENTS

APPS.ASO_AK_QUOTE_RELATED_RECORDS_V is not referenced by any database object