eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.QPBV_PROMOTION_HEADERS

Object Details

Object Name:	QPBV_PROMOTION_HEADERS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	QP.QPBV_PROMOTION_HEADERS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This view gives information about Deal and Promotion type of Modifier headers.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROMOTION_NUMBER	VARCHAR2	(240)	Yes
NAME	VARCHAR2	(2000)
AUTOMATIC_FLAG	VARCHAR2	(1)
START_DATE_ACTIVE	DATE
END_DATE_ACTIVE	DATE
DESCRIPTION	VARCHAR2	(2000)
ACTIVE_FLAG	VARCHAR2	(1)
VERSION_NO	VARCHAR2	(30)
ASK_FOR_FLAG	VARCHAR2	(1)
PARENT_LIST_HEADER_ID	NUMBER
START_DATE_ACTIVE_FIRST	DATE
END_DATE_ACTIVE_FIRST	DATE
START_DATE_ACTIVE_SECOND	DATE
END_DATE_ACTIVE_SECOND	DATE
CURRENCY_CODE	VARCHAR2	(30)
LIST_TYPE_CODE	VARCHAR2	(30)	Yes
SOURCE_SYSTEM_CODE	VARCHAR2	(30)
ACTIVE_DATE_FIRST_TYPE	VARCHAR2	(30)
ACTIVE_DATE_SECOND_TYPE	VARCHAR2	(30)
LIST_HEADER_ID	NUMBER		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
PTE_CODE	VARCHAR2	(30)		If the list header is a Modifier , this column indicates Pricing Transaction Entity that created it.
LIST_SOURCE_CODE	VARCHAR2	(30)		This column identifies the source system that creates price list.
ORIG_SYSTEM_HEADER_REF	VARCHAR2	(50)		Id of the source system that creates price list is stored in this column.
ORIG_ORG_ID	NUMBER			This is used by runtime engine security. Every List Header belongs to an Operating Unit that created it. Foreign key to HR_OPERATING_UNITS
GLOBAL_FLAG	VARCHAR2	(1)		Indicates if the entity with this list_header_id can be used globally or by the Operating Unit that created it. The value of this flag helps the pricing Engine to make this decision.
SHAREABLE_FLAG	VARCHAR2	(1)		Indicates whether or not pricelist/modifier can be shared across blankets

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PROMOTION_NUMBER
,      NAME
,      AUTOMATIC_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      DESCRIPTION
,      ACTIVE_FLAG
,      VERSION_NO
,      ASK_FOR_FLAG
,      PARENT_LIST_HEADER_ID
,      START_DATE_ACTIVE_FIRST
,      END_DATE_ACTIVE_FIRST
,      START_DATE_ACTIVE_SECOND
,      END_DATE_ACTIVE_SECOND
,      CURRENCY_CODE
,      LIST_TYPE_CODE
,      SOURCE_SYSTEM_CODE
,      ACTIVE_DATE_FIRST_TYPE
,      ACTIVE_DATE_SECOND_TYPE
,      LIST_HEADER_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      PTE_CODE
,      LIST_SOURCE_CODE
,      ORIG_SYSTEM_HEADER_REF
,      ORIG_ORG_ID
,      GLOBAL_FLAG
,      SHAREABLE_FLAG
FROM APPS.QPBV_PROMOTION_HEADERS;

Dependencies

[top of page]

APPS.QPBV_PROMOTION_HEADERS references the following:

APPS: QP_LIST_HEADERS_B; QP_LIST_HEADERS_TL

APPS.QPBV_PROMOTION_HEADERS is not referenced by any database object