Product: | AS - Sales Foundation |
---|---|
Description: | Quote versions view |
Implementation/DBA Data: | Not implemented in this database |
SELECT AQSL.ROWID ROW_ID
, AQSL.QUOTE_ID
, AQSL.LAST_UPDATE_DATE
, AQSL.LAST_UPDATED_BY
, AQSL.CREATION_DATE
, AQSL.CREATED_BY
, AQSL.LAST_UPDATE_LOGIN
, AQSL.REQUEST_ID
, AQSL.PROGRAM_APPLICATION_ID
, AQSL.PROGRAM_ID
, AQSL.PROGRAM_UPDATE_DATE
, AQSL.QUOTE_NUMBER
, AQSL.QUOTE_VERSION
, AQ.QUOTE_NAME
, AL.MEANING
, AQ.QUOTE_END_DATE
, AQ2.QUOTE_NUMBER || '/' || AQ2.QUOTE_VERSION SOURCE_QUOTE
, SPL.NAME PRICE_LIST_NAME
, AQSL.TOTAL_DISCOUNT_AMOUNT
, AQSL.TOTAL_QUOTE_PRICE
FROM AS_QUOTE_STATUS_LOG AQSL
, AS_QUOTES AQ
, AS_QUOTES AQ2
, SO_PRICE_LISTS_VL SPL
, AS_LOOKUPS AL
WHERE AL.LOOKUP_TYPE (+) = 'QUOTE_STATUS'
AND SPL.PRICE_LIST_ID (+) = AQSL.PRICE_LIST_ID
AND AL.LOOKUP_CODE (+) = AQSL.QUOTE_STATUS
AND AQ2.QUOTE_ID (+) = AQ.ORIGINAL_QUOTE_ID
AND AQ.QUOTE_ID = AQSL.QUOTE_ID