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


VIEW: APPS.AST_QUOTES_UWQ_V

Object Details
Object Name: AST_QUOTES_UWQ_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAST.AST_QUOTES_UWQ_V
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

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
IEU_OBJECT_FUNCTION VARCHAR2 (30)
IEU_OBJECT_PARAMETERS CHAR (32)
IEU_MEDIA_TYPE_UUID CHAR (0)
IEU_PARAM_PK_COL CHAR (15)
IEU_PARAM_PK_VALUE VARCHAR2 (40)
RESOURCE_TYPE VARCHAR2 (13)
CUSTOMER_NAME VARCHAR2 (360)
FIRST_NAME VARCHAR2 (150)
LAST_NAME VARCHAR2 (150)
PARTY_TYPE VARCHAR2 (30) Yes
ACCOUNT_NUMBER VARCHAR2 (30)
QUOTE_NAME VARCHAR2 (240)
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BYNAME VARCHAR2 (360)
QUOTE_NUMBER VARCHAR2 (83)
QUOTE_EXPIRATION_DATE DATE

QUOTE_STATUS_ID NUMBER
Yes
TOTAL_LIST_PRICE NUMBER

CURRENCY_CODE VARCHAR2 (15) Yes
TOTAL_ADJUSTED_AMOUNT NUMBER

TOTAL_ADJUSTED_PERCENT NUMBER

TOTAL_TAX NUMBER

SURCHARGE NUMBER

TOTAL_SHIPPING_CHARGE NUMBER

TOTAL_QUOTE_PRICE NUMBER

RESOURCE_ID NUMBER

STATUS_CODE VARCHAR2 (30)
QUOTE_STATUS VARCHAR2 (240)
EMPLOYEE_PERSON_ID NUMBER

Query Text

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


SELECT IEU_OBJECT_FUNCTION
,      IEU_OBJECT_PARAMETERS
,      IEU_MEDIA_TYPE_UUID
,      IEU_PARAM_PK_COL
,      IEU_PARAM_PK_VALUE
,      RESOURCE_TYPE
,      CUSTOMER_NAME
,      FIRST_NAME
,      LAST_NAME
,      PARTY_TYPE
,      ACCOUNT_NUMBER
,      QUOTE_NAME
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATED_BYNAME
,      QUOTE_NUMBER
,      QUOTE_EXPIRATION_DATE
,      QUOTE_STATUS_ID
,      TOTAL_LIST_PRICE
,      CURRENCY_CODE
,      TOTAL_ADJUSTED_AMOUNT
,      TOTAL_ADJUSTED_PERCENT
,      TOTAL_TAX
,      SURCHARGE
,      TOTAL_SHIPPING_CHARGE
,      TOTAL_QUOTE_PRICE
,      RESOURCE_ID
,      STATUS_CODE
,      QUOTE_STATUS
,      EMPLOYEE_PERSON_ID
FROM APPS.AST_QUOTES_UWQ_V;

Dependencies

[top of page]

APPS.AST_QUOTES_UWQ_V references the following:

SchemaAPPS
SynonymASO_QUOTE_HEADERS_ALL
ViewASO_QUOTE_STATUSES_VL
SynonymFND_USER
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_PARTIES
SynonymHZ_RELATIONSHIPS
SynonymJTF_OBJECTS_B
SynonymJTF_RS_RESOURCE_EXTNS

APPS.AST_QUOTES_UWQ_V is not referenced by any database object