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]

TABLE: QP.QP_LIST_HEADERS_B

Object Details

Object Name:	QP_LIST_HEADERS_B
Object Type:	TABLE
Owner:	QP
FND Design Data:	QP.QP_LIST_HEADERS_B
Subobject Name:
Status:	VALID

QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QP_LIST_HEADERS_B_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	LIST_HEADER_ID
QP_LIST_HEADERS_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GSA_INDICATOR LIST_HEADER_ID SOURCE_SYSTEM_CODE ACTIVE_FLAG CURRENCY_CODE LIST_TYPE_CODE
QP_LIST_HEADERS_B_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CURRENCY_CODE ACTIVE_FLAG LIST_HEADER_ID
QP_LIST_HEADERS_B_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LIST_TYPE_CODE
QP_LIST_HEADERS_B_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LIST_SOURCE_CODE ORIG_SYSTEM_HEADER_REF
QP_LIST_HEADERS_B_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCKED_FROM_LIST_HEADER_ID SOURCE_SYSTEM_CODE
QP_LIST_HEADERS_B_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTIVE_FLAG LIST_HEADER_ID CURRENCY_CODE
QP_LIST_HEADERS_B_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORIG_SYSTEM_HEADER_REF
QP_LIST_HEADERS_B_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LIST_HEADER_ID LIST_TYPE_CODE GSA_INDICATOR ACTIVE_FLAG CURRENCY_CODE START_DATE_ACTIVE END_DATE_ACTIVE

Columns

Name	Datatype	Length	Mandatory	Comments
LIST_HEADER_ID	NUMBER		Yes	System generated unique identifier
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column
PROGRAM_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
REQUEST_ID	NUMBER			Standard Who column
LIST_TYPE_CODE	VARCHAR2	(30)	Yes	This stores the type of modifier list, for example price list, discount list or promotion. Based on Lookup Type LIST_TYPE_CODE.
START_DATE_ACTIVE	DATE			This is the start date of the effective period for the modifier list
END_DATE_ACTIVE	DATE			This is the end date of the effective period for the modifier list
AUTOMATIC_FLAG	VARCHAR2	(1)		The flag is used as a defaulting mechanism ONLY, the value is defaulted to the Automatic Flag on QP_LIST_LINES when a new line record is created. The column is NOT referenced by the pricing engine.
CURRENCY_CODE	VARCHAR2	(30)		The currency of the list.
ROUNDING_FACTOR	NUMBER			Decimal position where rounding occurs, e.g. a rounding factor of -2 would mean that 100.256 will be rounded to 100.26
SHIP_METHOD_CODE	VARCHAR2	(30)		Freight carrier on price list. Used for defaulting purposes in Order Management.
FREIGHT_TERMS_CODE	VARCHAR2	(30)		Freight Terms for price list. Used for defaulting purposes in Order Management.
TERMS_ID	NUMBER			Payment Terms on price list. Used for defaulting purposes in Order Management.
COMMENTS	VARCHAR2	(2000)		Used to record additional descriptive text for a price list or modifier list.
DISCOUNT_LINES_FLAG	VARCHAR2	(1)		This column is used for backward compatibility. Indicates whether there are discount lines for the list.
GSA_INDICATOR	VARCHAR2	(1)		Used to indicate that the list is a GSA list. This is only applicable for discount lists.
PRORATE_FLAG	VARCHAR2	(30)		Reserved for future use.
SOURCE_SYSTEM_CODE	VARCHAR2	(30)		Source system which created this record, based on Lookup Type 'SOURCE_SYSTEM'.
ASK_FOR_FLAG	VARCHAR2	(1)		Indicates whether the user must ask for the "List", e.g. quote a promotion number, to get the benefits on the list. The pricing engine ignores any lists where 'Ask For = Y' if they have not been quoted on the pricing request.
ACTIVE_FLAG	VARCHAR2	(1)		Indicates if the list is active or not. The pricing engine ignores lists which are "inactive", i.e Active_Flag = "N - No"
PARENT_LIST_HEADER_ID	NUMBER			If the List Type is "Deal", this field can be used to reference any "parent" promotion. Note: This is only used for reporting purposes, the pricing engine does not consider this relationship when deciding which lists are eligible to be applied to the request.
START_DATE_ACTIVE_FIRST	DATE			Start Date of the first effective date range.
END_DATE_ACTIVE_FIRST	DATE			End Date of the first effective date range.
ACTIVE_DATE_FIRST_TYPE	VARCHAR2	(30)		The type of date used in the "first" active date range. This is optional for a deal or promotion list type. Based on Lookup Type 'Effective Date Types'.
START_DATE_ACTIVE_SECOND	DATE			Start Date of the second effective date range.
END_DATE_ACTIVE_SECOND	DATE			End Date of the second effective date range.
ACTIVE_DATE_SECOND_TYPE	VARCHAR2	(30)		The type of date used in the "second" active date range. This is optional for a deal or promotion list type. Based on Lookup Type 'Effective Date Types'.
CONTEXT	VARCHAR2	(30)		Descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flexfield segment
LIMIT_EXISTS_FLAG	VARCHAR2	(1)		Indicates whether there are Limits associated to this List Header.
MOBILE_DOWNLOAD	VARCHAR2	(1)		Indicates whether the price list will be downloaded for the offline Mobile application.
CURRENCY_HEADER_ID	NUMBER			Identifies Multi-Currency List associated with a Price List. This is primary key of QP_CURRENCY_LISTS_B table.
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
SOLD_TO_ORG_ID	NUMBER			This column is used as a reference for customer_item_id in qp_list_lines. This column does not indicate any pricing relationship with the customer.
LOCKED_FROM_LIST_HEADER_ID	NUMBER			To store the parent list header id from which the locked list header is created.

Query Text

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


SELECT LIST_HEADER_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      LIST_TYPE_CODE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      AUTOMATIC_FLAG
,      CURRENCY_CODE
,      ROUNDING_FACTOR
,      SHIP_METHOD_CODE
,      FREIGHT_TERMS_CODE
,      TERMS_ID
,      COMMENTS
,      DISCOUNT_LINES_FLAG
,      GSA_INDICATOR
,      PRORATE_FLAG
,      SOURCE_SYSTEM_CODE
,      ASK_FOR_FLAG
,      ACTIVE_FLAG
,      PARENT_LIST_HEADER_ID
,      START_DATE_ACTIVE_FIRST
,      END_DATE_ACTIVE_FIRST
,      ACTIVE_DATE_FIRST_TYPE
,      START_DATE_ACTIVE_SECOND
,      END_DATE_ACTIVE_SECOND
,      ACTIVE_DATE_SECOND_TYPE
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LIMIT_EXISTS_FLAG
,      MOBILE_DOWNLOAD
,      CURRENCY_HEADER_ID
,      PTE_CODE
,      LIST_SOURCE_CODE
,      ORIG_SYSTEM_HEADER_REF
,      ORIG_ORG_ID
,      GLOBAL_FLAG
,      SHAREABLE_FLAG
,      SOLD_TO_ORG_ID
,      LOCKED_FROM_LIST_HEADER_ID
FROM QP.QP_LIST_HEADERS_B;

Dependencies

[top of page]

QP.QP_LIST_HEADERS_B does not reference any database object

QP.QP_LIST_HEADERS_B is referenced by following:

APPS: QP_LIST_HEADERS_B
PUBLIC: QP_LIST_HEADERS_ALL_B