VIEW: APPS.ASO_QUOTE_VERSIONS_V

Source

View Text - Preformatted

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 , FND_USER1.USER_NAME LAST_UPDATED_BY_USER_NAME , QUOTE.QUOTE_NUMBER , QUOTE.QUOTE_VERSION , QUOTE.QUOTE_NAME , STATUS.MEANING , QUOTE.QUOTE_EXPIRATION_DATE , QUOTE.TOTAL_QUOTE_PRICE ,QUOTE.CURRENCY_CODE ,fnd_cur.name from aso_quote_headers quote, aso_quote_statuses_tl status, fnd_user, fnd_user fnd_user1, fnd_currencies_vl fnd_cur WHERE STATUS.QUOTE_STATUS_ID = QUOTE.QUOTE_STATUS_ID AND STATUS.LANGUAGE(+) = userenv('LANG') AND FND_USER.USER_ID = QUOTE.CREATED_BY AND FND_USER1.USER_ID = QUOTE.LAST_UPDATED_BY AND fnd_cur.currency_code = quote.currency_code

View Text - HTML Formatted

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
, FND_USER1.USER_NAME LAST_UPDATED_BY_USER_NAME
, QUOTE.QUOTE_NUMBER
, QUOTE.QUOTE_VERSION
, QUOTE.QUOTE_NAME
, STATUS.MEANING
, QUOTE.QUOTE_EXPIRATION_DATE
, QUOTE.TOTAL_QUOTE_PRICE
, QUOTE.CURRENCY_CODE
, FND_CUR.NAME
FROM ASO_QUOTE_HEADERS QUOTE
, ASO_QUOTE_STATUSES_TL STATUS
, FND_USER
, FND_USER FND_USER1
, FND_CURRENCIES_VL FND_CUR
WHERE STATUS.QUOTE_STATUS_ID = QUOTE.QUOTE_STATUS_ID
AND STATUS.LANGUAGE(+) = USERENV('LANG')
AND FND_USER.USER_ID = QUOTE.CREATED_BY
AND FND_USER1.USER_ID = QUOTE.LAST_UPDATED_BY
AND FND_CUR.CURRENCY_CODE = QUOTE.CURRENCY_CODE