eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IBE_SH_QUOTE_URL_V

Product:	IBE - iStore
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT Q.QUOTE_HEADER_ID
, Q.ORG_ID
, Q.QUOTE_NAME
, Q.QUOTE_NUMBER
, Q.QUOTE_VERSION
, Q.QUOTE_STATUS_ID
, Q.QUOTE_SOURCE_CODE
, Q.QUOTE_EXPIRATION_DATE
, Q.PRICE_FROZEN_DATE
, Q.QUOTE_PASSWORD
, Q.PARTY_ID
, Q.CUST_ACCOUNT_ID
, Q.ORG_CONTACT_ID
, Q.CURRENCY_CODE
, Q.TOTAL_LIST_PRICE
, Q.TOTAL_ADJUSTED_AMOUNT
, Q.TOTAL_ADJUSTED_PERCENT
, Q.TOTAL_TAX
, Q.TOTAL_SHIPPING_CHARGE
, Q.SURCHARGE
, Q.TOTAL_QUOTE_PRICE
, Q.PAYMENT_AMOUNT
, Q.EXCHANGE_RATE
, Q.EXCHANGE_TYPE_CODE
, Q.EXCHANGE_RATE_DATE
, C.URL
, C.WEB_TYPE
FROM HZ_CONTACT_POINTS C
, ASO_QUOTE_HEADERS_ALL Q
WHERE C.OWNER_TABLE_NAME = 'ASO_QUOTE_HEADERS_ALL'
AND C.OWNER_TABLE_ID = Q.QUOTE_HEADER_ID
AND C.CONTACT_POINT_TYPE = 'WEB'

Columns

Name
QUOTE_HEADER_ID
ORG_ID
QUOTE_NAME
QUOTE_NUMBER
QUOTE_VERSION
QUOTE_STATUS_ID
QUOTE_SOURCE_CODE
QUOTE_EXPIRATION_DATE
PRICE_FROZEN_DATE
QUOTE_PASSWORD
PARTY_ID
CUST_ACCOUNT_ID
ORG_CONTACT_ID
CURRENCY_CODE
TOTAL_LIST_PRICE
TOTAL_ADJUSTED_AMOUNT
TOTAL_ADJUSTED_PERCENT
TOTAL_TAX
TOTAL_SHIPPING_CHARGE
SURCHARGE
TOTAL_QUOTE_PRICE
PAYMENT_AMOUNT
EXCHANGE_RATE
EXCHANGE_TYPE_CODE
EXCHANGE_RATE_DATE
URL
WEB_TYPE