View: QPBV_PROMOTION_HEADERS

Product:	QP - Advanced Pricing
Description:	This view gives information about Deal and Promotion type of Modifier headers.
Implementation/DBA Data:	APPS.QPBV_PROMOTION_HEADERS

View Text

SELECT TL.NAME
, TL.DESCRIPTION
, LH.AUTOMATIC_FLAG
, LH.START_DATE_ACTIVE
, LH.END_DATE_ACTIVE
, LH.COMMENTS
, LH.ACTIVE_FLAG
, TL.VERSION_NO
, LH.ASK_FOR_FLAG
, LH.PARENT_LIST_HEADER_ID
, LH.START_DATE_ACTIVE_FIRST
, LH.END_DATE_ACTIVE_FIRST
, LH.START_DATE_ACTIVE_SECOND
, LH.END_DATE_ACTIVE_SECOND
, LH.CURRENCY_CODE
, LH.LIST_TYPE_CODE
, LH.SOURCE_SYSTEM_CODE
, LH.ACTIVE_DATE_FIRST_TYPE
, LH.ACTIVE_DATE_SECOND_TYPE
, LH.LIST_HEADER_ID
, LH.CREATION_DATE
, LH.CREATED_BY
, LH.LAST_UPDATE_DATE
, LH.LAST_UPDATED_BY
FROM QP_LIST_HEADERS_B LH
, QP_LIST_HEADERS_TL TL
WHERE LH.LIST_HEADER_ID = TL.LIST_HEADER_ID
AND LH.LIST_TYPE_CODE IN ('DEL'
, 'PRO')
AND TL.LANGUAGE = USERENV('LANG')

Columns