[Home] [Help] [Dependency Information]
Object Name: | ASO_SEARCH_QUOTES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ASO.ASO_SEARCH_QUOTES_V |
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 | Yes | Quote Header Id from Aso_Quote_Headers_V | |
QUOTE_NAME | VARCHAR2 | (240) | Quote Name from Aso_Quote_Headers_V | |
COMPANY | VARCHAR2 | (4000) | Organizatin Name from Aso_Quote_Headers_V | |
ACCOUNT | VARCHAR2 | (30) | Account Number from Aso_Quote_Headers_V | |
CATEGORY | VARCHAR2 | (240) | Quote_Category_Code from Aso_Quote_Headers_V | |
FIRST_NAME | VARCHAR2 | (4000) | Person_First_Name from Aso_Quote_Headers_V | |
LAST_NAME | VARCHAR2 | (4000) | Person_Last_Name from Aso_Quote_Headers_V | |
QUOTE_NUMBER | NUMBER | Yes | Quote Number from Aso_Quote_Headers_V | |
VERSION | NUMBER | Yes | Quote Version from Aso_Quote_Headers_V | |
STATUS | VARCHAR2 | (240) | Quote Status from Aso_Quote_Headers_V | |
EXP_DATE | DATE | Quote Expiration Date from Aso_Quote_Headers_V | ||
QUOTE_PRICE | NUMBER | Total Quote Price Quote from Aso_Quote_Headers_V |
Cut, paste (and edit) the following text to query this object:
SELECT QUOTE_HEADER_ID
, QUOTE_NAME
, COMPANY
, ACCOUNT
, CATEGORY
, FIRST_NAME
, LAST_NAME
, QUOTE_NUMBER
, VERSION
, STATUS
, EXP_DATE
, QUOTE_PRICE
FROM APPS.ASO_SEARCH_QUOTES_V;
APPS.ASO_SEARCH_QUOTES_V is not referenced by any database object
|
|
|