Product: | AMS - Marketing |
---|---|
Description: | This view stores offers' detail along with the header infomation. |
Implementation/DBA Data: | APPS.AMS_OFFERS_V |
SELECT QLH.LIST_HEADER_ID
, QLH.NAME
, QLH.CURRENCY_CODE
, QLH.ACTIVE_FLAG
, QLH.START_DATE_ACTIVE
, QLH.END_DATE_ACTIVE
, QLH.DESCRIPTION
, OFF.STATUS_CODE
, OFF.STATUS_DATE
, OFF.USER_STATUS_ID
, OFF.CUSTOM_SETUP_ID
, OZF_PRICE_LIST_PVT.GET_USER_STATUS_NAME(OFF.USER_STATUS_ID) USER_STATUS_NAME
, OFF.OWNER_ID
, OFF.OBJECT_VERSION_NUMBER
, QLH.CONTEXT
, QLH.ATTRIBUTE1
, QLH.ATTRIBUTE2
, QLH.ATTRIBUTE3
, QLH.ATTRIBUTE4
, QLH.ATTRIBUTE5
, QLH.ATTRIBUTE6
, QLH.ATTRIBUTE7
, QLH.ATTRIBUTE8
, QLH.ATTRIBUTE9
, QLH.ATTRIBUTE10
, QLH.ATTRIBUTE11
, QLH.ATTRIBUTE12
, QLH.ATTRIBUTE13
, QLH.ATTRIBUTE14
, QLH.ATTRIBUTE15
, OFF.CREATION_DATE
, OFF.LAST_UPDATE_DATE
, OFF.LAST_UPDATE_LOGIN
, OFF.LAST_UPDATED_BY
, OFF.CREATED_BY
, QLH.SOURCE_SYSTEM_CODE
, QLH.CURRENCY_HEADER_ID
FROM QP_LIST_HEADERS_VL QLH
, OZF_OFFERS OFF
WHERE QLH.LIST_HEADER_ID=OFF.QP_LIST_HEADER_ID
AND QLH.LIST_TYPE_CODE='PRO'