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

VIEW: APPS.ASO_PVT_QUOTE_HEADERS_UI_V

Object Details
Object Name: ASO_PVT_QUOTE_HEADERS_UI_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 Mandatory Comments
ROW_ID ROWID (10)
QUOTE_HEADER_ID NUMBER
Yes
ORDER_ID NUMBER

ORG_ID NUMBER

Organization identifier
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).
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_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (240)
EMPLOYEE_PERSON_ID NUMBER

RESOURCE_ID NUMBER

PRICE_LIST_ID NUMBER

QUOTE_STATUS_ID NUMBER
Yes
QUOTE_SOURCE_CODE VARCHAR2 (240)
SOLD_TO_CONTACT_PARTY_ID NUMBER

SOLD_TO_CUST_ACCT_ID NUMBER

SOLD_TO_CUST_PARTY_ID NUMBER

ORG_CONTACT_ID NUMBER

PHONE_ID NUMBER

QUOTE_NAME VARCHAR2 (240)
QUOTE_NUMBER NUMBER
Yes
QUOTE_VERSION NUMBER
Yes
QUOTE_EXPIRATION_DATE DATE

QUOTE_CATEGORY_CODE VARCHAR2 (240)
CURRENCY_CODE VARCHAR2 (15) Yes
EXCHANGE_RATE NUMBER

EXCHANGE_TYPE_CODE VARCHAR2 (15)
EXCHANGE_RATE_DATE DATE

ORIG_MKTG_SOURCE_CODE_ID NUMBER

MARKETING_SOURCE_CODE_ID NUMBER

ORDERED_DATE DATE

ORDER_TYPE_ID NUMBER

TOTAL_LIST_PRICE NUMBER

TOTAL_ADJUSTED_AMOUNT NUMBER

TOTAL_ADJUSTED_PERCENT NUMBER

TOTAL_TAX NUMBER

SURCHARGE NUMBER

TOTAL_SHIPPING_CHARGE NUMBER

TOTAL_QUOTE_PRICE NUMBER

ACCOUNTING_RULE_ID NUMBER

INVOICING_RULE_ID NUMBER

INVOICE_TO_PARTY_SITE_ID NUMBER

INVOICE_TO_CONTACT_PARTY_ID NUMBER

INVOICE_TO_CUST_ACCOUNT_ID NUMBER

INVOICE_TO_CUST_PARTY_ID NUMBER

END_CUSTOMER_PARTY_ID NUMBER

End Customer or Contact
END_CUSTOMER_CUST_PARTY_ID NUMBER

End Customer
END_CUSTOMER_PARTY_SITE_ID NUMBER

End User Address
END_CUSTOMER_CUST_ACCOUNT_ID NUMBER

End User Account
AUTOMATIC_PRICE_FLAG VARCHAR2 (1)
This flag is used to denote if the quote is in automatic or manual mode of pricing
AUTOMATIC_TAX_FLAG VARCHAR2 (1)
This flag denotes if the calculation of tax is in automatic or manual mode
ASSISTANCE_REQUESTED VARCHAR2 (1)
This flag denotes if there is a sales rep assistance requested for the quote or not.
ASSISTANCE_REASON_CODE VARCHAR2 (30)
Stores the reason for sales rep assistance
HEADER_PAYNOW_CHARGES NUMBER

Header Paynow Charges
CONTRACT_ID NUMBER

PRICE_FROZEN_DATE DATE

QUOTE_PASSWORD VARCHAR2 (240)
PAYMENT_AMOUNT NUMBER

SALES_CHANNEL_CODE VARCHAR2 (30)
CONTRACT_TEMPLATE_ID NUMBER

CONTRACT_TEMPLATE_MAJOR_VER NUMBER

CONTRACT_REQUESTER_ID NUMBER

CONTRACT_APPROVAL_LEVEL VARCHAR2 (30)
PUBLISH_FLAG VARCHAR2 (1)
RESOURCE_GRP_ID NUMBER

SOLD_TO_PARTY_SITE_ID NUMBER

QUOTE_TYPE VARCHAR2 (1)
QUOTE_DESCRIPTION VARCHAR2 (240)
DISPLAY_ARITHMETIC_OPERATOR VARCHAR2 (30)
MAX_VERSION_FLAG VARCHAR2 (1)
OBJECT_VERSION_NUMBER NUMBER

PRICING_STATUS_INDICATOR VARCHAR2 (1)
TAX_STATUS_INDICATOR VARCHAR2 (1)
PRICE_UPDATED_DATE DATE

TAX_UPDATED_DATE DATE

RECALCULATE_FLAG VARCHAR2 (1)
PRICE_REQUEST_ID NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (240)
Descriptive flexfield segment
CREDIT_UPDATE_DATE DATE

Last time credits were updated
Query Text

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


SELECT ROW_ID
,      QUOTE_HEADER_ID
,      ORDER_ID
,      ORG_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORIGINAL_SYSTEM_REFERENCE
,      EMPLOYEE_PERSON_ID
,      RESOURCE_ID
,      PRICE_LIST_ID
,      QUOTE_STATUS_ID
,      QUOTE_SOURCE_CODE
,      SOLD_TO_CONTACT_PARTY_ID
,      SOLD_TO_CUST_ACCT_ID
,      SOLD_TO_CUST_PARTY_ID
,      ORG_CONTACT_ID
,      PHONE_ID
,      QUOTE_NAME
,      QUOTE_NUMBER
,      QUOTE_VERSION
,      QUOTE_EXPIRATION_DATE
,      QUOTE_CATEGORY_CODE
,      CURRENCY_CODE
,      EXCHANGE_RATE
,      EXCHANGE_TYPE_CODE
,      EXCHANGE_RATE_DATE
,      ORIG_MKTG_SOURCE_CODE_ID
,      MARKETING_SOURCE_CODE_ID
,      ORDERED_DATE
,      ORDER_TYPE_ID
,      TOTAL_LIST_PRICE
,      TOTAL_ADJUSTED_AMOUNT
,      TOTAL_ADJUSTED_PERCENT
,      TOTAL_TAX
,      SURCHARGE
,      TOTAL_SHIPPING_CHARGE
,      TOTAL_QUOTE_PRICE
,      ACCOUNTING_RULE_ID
,      INVOICING_RULE_ID
,      INVOICE_TO_PARTY_SITE_ID
,      INVOICE_TO_CONTACT_PARTY_ID
,      INVOICE_TO_CUST_ACCOUNT_ID
,      INVOICE_TO_CUST_PARTY_ID
,      END_CUSTOMER_PARTY_ID
,      END_CUSTOMER_CUST_PARTY_ID
,      END_CUSTOMER_PARTY_SITE_ID
,      END_CUSTOMER_CUST_ACCOUNT_ID
,      AUTOMATIC_PRICE_FLAG
,      AUTOMATIC_TAX_FLAG
,      ASSISTANCE_REQUESTED
,      ASSISTANCE_REASON_CODE
,      HEADER_PAYNOW_CHARGES
,      CONTRACT_ID
,      PRICE_FROZEN_DATE
,      QUOTE_PASSWORD
,      PAYMENT_AMOUNT
,      SALES_CHANNEL_CODE
,      CONTRACT_TEMPLATE_ID
,      CONTRACT_TEMPLATE_MAJOR_VER
,      CONTRACT_REQUESTER_ID
,      CONTRACT_APPROVAL_LEVEL
,      PUBLISH_FLAG
,      RESOURCE_GRP_ID
,      SOLD_TO_PARTY_SITE_ID
,      QUOTE_TYPE
,      QUOTE_DESCRIPTION
,      DISPLAY_ARITHMETIC_OPERATOR
,      MAX_VERSION_FLAG
,      OBJECT_VERSION_NUMBER
,      PRICING_STATUS_INDICATOR
,      TAX_STATUS_INDICATOR
,      PRICE_UPDATED_DATE
,      TAX_UPDATED_DATE
,      RECALCULATE_FLAG
,      PRICE_REQUEST_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      CREDIT_UPDATE_DATE
FROM APPS.ASO_PVT_QUOTE_HEADERS_UI_V;

Dependencies

[top of page]

APPS.ASO_PVT_QUOTE_HEADERS_UI_V references the following:

SchemaAPPS
SynonymASO_QUOTE_HEADERS

APPS.ASO_PVT_QUOTE_HEADERS_UI_V is not referenced by any database object