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.QPFV_PROMOTION_HEADERS

Object Details

Object Name:	QPFV_PROMOTION_HEADERS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	QP.QPFV_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)
CURRENCY_NAME	VARCHAR2	(80)		This is the name of the currency code.
LIST_TYPE_CODE	VARCHAR2	(30)	Yes
_LA:LIST_TYPE_CODE	CHAR	(55)
SOURCE_SYSTEM_CODE	VARCHAR2	(30)
_LA:SOURCE_SYSTEM_CODE	CHAR	(58)
ACTIVE_DATE_FIRST_TYPE	VARCHAR2	(30)
_LA:ACTIVE_DATE_FIRST_TYPE	CHAR	(69)
ACTIVE_DATE_SECOND_TYPE	VARCHAR2	(30)
_LA:ACTIVE_DATE_SECOND_TYPE	CHAR	(70)
LIST_HEADER_ID	NUMBER		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
_DF	CHAR	(25)		Descriptive Flexfield column values of qp_list_headers_b table.
PTE_CODE	VARCHAR2	(30)
_LA:PTE_CODE	CHAR	(46)
LIST_SOURCE_CODE	VARCHAR2	(30)
ORIG_SYSTEM_HEADER_REF	VARCHAR2	(50)
ORIG_ORG_ID	NUMBER
GLOBAL_FLAG	VARCHAR2	(1)
SHAREABLE_FLAG	VARCHAR2	(1)

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
,      CURRENCY_NAME
,      LIST_TYPE_CODE
,      _LA:LIST_TYPE_CODE
,      SOURCE_SYSTEM_CODE
,      _LA:SOURCE_SYSTEM_CODE
,      ACTIVE_DATE_FIRST_TYPE
,      _LA:ACTIVE_DATE_FIRST_TYPE
,      ACTIVE_DATE_SECOND_TYPE
,      _LA:ACTIVE_DATE_SECOND_TYPE
,      LIST_HEADER_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      _DF
,      PTE_CODE
,      _LA:PTE_CODE
,      LIST_SOURCE_CODE
,      ORIG_SYSTEM_HEADER_REF
,      ORIG_ORG_ID
,      GLOBAL_FLAG
,      SHAREABLE_FLAG
FROM APPS.QPFV_PROMOTION_HEADERS;

Dependencies

[top of page]

APPS.QPFV_PROMOTION_HEADERS references the following:

APPS: FND_CURRENCIES_VL; QP_LIST_HEADERS_B; QP_LIST_HEADERS_TL

APPS.QPFV_PROMOTION_HEADERS is not referenced by any database object