DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AST_QUOTES_MV

Object Details
Object Name: AST_QUOTES_MV
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
QUOTE_NAME VARCHAR2 (240)
QUOTE_NUMBER_VERSION VARCHAR2 (81)
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
QUOTE_STATUS_ID NUMBER
Yes
QUOTE_STATUS VARCHAR2 (240)
QUOTE_TOTAL NUMBER

QUOTE_EXPIRATION_DATE DATE

ACCOUNT_NUMBER VARCHAR2 (30)
QUOTE_HEADER_ID NUMBER
Yes
CUST_ACCOUNT_ID NUMBER

ACCOUNT_PARTY_ID NUMBER (15)
CURRENCY_CODE VARCHAR2 (15) Yes
SOLD_TO_CONTACT_NAME VARCHAR2 (360)
RESOURCE_ID NUMBER

RESOURCE_NAME VARCHAR2 (240)
CUSTOMER_ID NUMBER

SOLD_TO_CONTACT_PARTY_TYPE VARCHAR2 (30)
ORG_ID NUMBER

LANG VARCHAR2 (4) Yes
Query Text

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


SELECT QUOTE_NAME
,      QUOTE_NUMBER_VERSION
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      QUOTE_STATUS_ID
,      QUOTE_STATUS
,      QUOTE_TOTAL
,      QUOTE_EXPIRATION_DATE
,      ACCOUNT_NUMBER
,      QUOTE_HEADER_ID
,      CUST_ACCOUNT_ID
,      ACCOUNT_PARTY_ID
,      CURRENCY_CODE
,      SOLD_TO_CONTACT_NAME
,      RESOURCE_ID
,      RESOURCE_NAME
,      CUSTOMER_ID
,      SOLD_TO_CONTACT_PARTY_TYPE
,      ORG_ID
,      LANG
FROM APPS.AST_QUOTES_MV;

Dependencies

[top of page]

APPS.AST_QUOTES_MV references the following:

SchemaAPPS
SynonymASO_QUOTE_HEADERS_ALL
SynonymASO_QUOTE_STATUSES_B
SynonymASO_QUOTE_STATUSES_TL
SynonymFND_LANGUAGES
SynonymFND_PROFILE_OPTIONS
SynonymFND_PROFILE_OPTION_VALUES
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_PARTIES
SynonymHZ_RELATIONSHIPS
SynonymJTF_RS_SALESREPS

APPS.AST_QUOTES_MV is not referenced by any database object