[Home] [Help] [Dependency Information]
Object Name: | ASO_PVT_QUOTE_SEARCH_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUOTE_HEADER_ID | NUMBER | Unique identifier for quote | ||
PARTY_ID | NUMBER | A foreign key to the HZ_PARTY table. | ||
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. | ||
QUOTE_NAME | VARCHAR2 | (0) | Quote name | |
QUOTE_NUMBER | NUMBER | Quote number. Quote number and version uniquely identifies a quote | ||
QUOTE_VERSION | NUMBER | Quote version. Quote number and quote version uniquely identifies a quote | ||
WEB_PUBLISH | VARCHAR2 | (0) | PUBLISH FLAG | |
EXPIRATION_DATE | DATE | Expiration date of the quote | ||
CUSTOMER_NAME | VARCHAR2 | (0) | Name of this party | |
CUSTOMER_TYPE | VARCHAR2 | (0) | The party type can only be Person, Organization, Group or Relationship. | |
ACCOUNT_NUMBER | VARCHAR2 | (0) | Account Number | |
CONTACT_NAME | VARCHAR2 | (0) | Name of this party | |
CONTACT_TYPE | VARCHAR2 | (0) | The party type can only be Person, Organization, Group or Relationship. | |
OPPORTUNITY_NAME | VARCHAR2 | (0) | ||
QUOTE_AMOUNT | NUMBER | |||
MAX_VERSION_FLAG | VARCHAR2 | (0) | ||
CURRENCY | VARCHAR2 | (0) | ||
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
UPDATE_DATE | DATE | |||
PRICE_LIST_ID | NUMBER | |||
ORDER_TYPE_ID | NUMBER | |||
CONTRACT_ID | NUMBER | |||
RESOURCE_ID | NUMBER | |||
RESOURCE_GRP_ID | NUMBER | |||
SALES_CHANNEL_CODE | VARCHAR2 | (0) | ||
MARKETING_SOURCE_CODE_ID | NUMBER | |||
PHONE_ID | NUMBER | |||
QUOTE_STATUS | VARCHAR2 | (0) | ||
ORDER_NUMBER | NUMBER | |||
CURRENCY_NAME | VARCHAR2 | (0) | ||
OPERATING_UNIT | VARCHAR2 | (0) |
Cut, paste (and edit) the following text to query this object:
SELECT QUOTE_HEADER_ID
, PARTY_ID
, CUST_ACCOUNT_ID
, QUOTE_NAME
, QUOTE_NUMBER
, QUOTE_VERSION
, WEB_PUBLISH
, EXPIRATION_DATE
, CUSTOMER_NAME
, CUSTOMER_TYPE
, ACCOUNT_NUMBER
, CONTACT_NAME
, CONTACT_TYPE
, OPPORTUNITY_NAME
, QUOTE_AMOUNT
, MAX_VERSION_FLAG
, CURRENCY
, CREATION_DATE
, UPDATE_DATE
, PRICE_LIST_ID
, ORDER_TYPE_ID
, CONTRACT_ID
, RESOURCE_ID
, RESOURCE_GRP_ID
, SALES_CHANNEL_CODE
, MARKETING_SOURCE_CODE_ID
, PHONE_ID
, QUOTE_STATUS
, ORDER_NUMBER
, CURRENCY_NAME
, OPERATING_UNIT
FROM APPS.ASO_PVT_QUOTE_SEARCH_V;
APPS.ASO_PVT_QUOTE_SEARCH_V is not referenced by any database object
|
|
|