View: ASO_QUOTE_VERSIONS_V

Product:	ASO - Order Capture
Description:	ASO_QUOTE_VERSIONS_V is a join view of aso_quote_headers_all quote,aso_quote_statuses_tl status &fnd_user
Implementation/DBA Data:	APPS.ASO_QUOTE_VERSIONS_V

View Text

SELECT QUOTE.ROWID ROW_ID
, QUOTE.QUOTE_HEADER_ID
, QUOTE.LAST_UPDATE_DATE
, QUOTE.LAST_UPDATED_BY
, QUOTE.CREATION_DATE
, QUOTE.CREATED_BY
, QUOTE.LAST_UPDATE_LOGIN
, QUOTE.REQUEST_ID
, QUOTE.PROGRAM_APPLICATION_ID
, QUOTE.PROGRAM_ID
, QUOTE.PROGRAM_UPDATE_DATE
, FND_USER.USER_NAME CREATED_BY_USER_NAME
, QUOTE.QUOTE_NUMBER
, QUOTE.QUOTE_VERSION
, QUOTE.QUOTE_NAME
, STATUS.MEANING
, QUOTE.QUOTE_EXPIRATION_DATE
, QUOTE.TOTAL_QUOTE_PRICE
FROM ASO_QUOTE_HEADERS_ALL QUOTE
, ASO_QUOTE_STATUSES_TL STATUS
, FND_USER
WHERE STATUS.QUOTE_STATUS_ID(+) = QUOTE.QUOTE_STATUS_ID
AND STATUS.LANGUAGE(+) = USERENV('LANG')
AND FND_USER.USER_ID = QUOTE.CREATED_BY

Columns