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_INTERFACE_LIST_HEADERS

Object Details

Object Name:	QP_INTERFACE_LIST_HEADERS
Object Type:	TABLE
Owner:	QP
FND Design Data:	QP.QP_INTERFACE_LIST_HEADERS
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.
Scope: public
Product: QP
Display Name: Interface List Headers
Category: BUSINESS_ENTITY QP_PRICE_LIST

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QP_INTERFACE_LIST_HEADERS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REQUEST_ID PROCESS_STATUS_FLAG INTERFACE_ACTION_CODE
QP_INTERFACE_LIST_HEADERS_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	LIST_SOURCE_CODE ORIG_SYS_HEADER_REF
QP_INTERFACE_LIST_HEADERS_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	NAME LIST_TYPE_CODE

Columns

Name	Datatype	Length	Comments
LIST_HEADER_ID	NUMBER		Primary Key of QP_LIST_HEADERS_B. System Generated ID
CREATION_DATE	DATE		Standard Who column
CREATED_BY	NUMBER		Standard Who column
LAST_UPDATE_DATE	DATE		Standard Who column
LAST_UPDATED_BY	NUMBER		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)	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	VARCHAR2	(30)	This is the start date of the effective period for the modifier list
END_DATE_ACTIVE	VARCHAR2	(30)	This is the end date of the effective period for the modifier list
SOURCE_LANG	VARCHAR2	(4)	The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
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.
NAME	VARCHAR2	(240)	Price List name or Modifier List number.
DESCRIPTION	VARCHAR2	(2000)	Price List Description or Modifier List Name.
CURRENCY_CODE	VARCHAR2	(30)	The currency of the list.
VERSION_NO	VARCHAR2	(30)	List version number. This is user-defined for List Types of Promotion or Deal.
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.
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_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_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'.
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.
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
LANGUAGE	VARCHAR2	(4)	Language
PROCESS_ID	NUMBER		Process Id for transaction
PROCESS_TYPE	VARCHAR2	(30)	Process type of Calling Application
INTERFACE_ACTION_CODE	VARCHAR2	(30)	Update/Insert/Delete code
LOCK_FLAG	VARCHAR2	(2)	Locking indicator for transaction
PROCESS_FLAG	VARCHAR2	(2)	Process flag for transaction
DELETE_FLAG	VARCHAR2	(2)	Delete flag for transaction
PROCESS_STATUS_FLAG	VARCHAR2	(2)	Process Status Flag for transaction
MOBILE_DOWNLOAD	VARCHAR2	(1)	Indicates whether the price list will be downloaded for the offline Mobile application.
CURRENCY_HEADER	VARCHAR2	(50)	Currency header ID if NULL is picked using this value.
CURRENCY_HEADER_ID	NUMBER		Identifies Multi-Currency List associated with a Price List.
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)	Indicate the origin of the price list. A pricelist created by Blanket Orders will populate LIST_SOURCE_CODE with 'BSO'
ORIG_SYS_HEADER_REF	VARCHAR2	(50)	Unique identification of the price list in the external application from where the price list is imported.
ORIG_ORG_ID	NUMBER		The Organization which created the price list/modifier.
GLOBAL_FLAG	VARCHAR2	(1)	Indicate whether the price list/modifier is available globally.
ATTRIBUTE_STATUS	VARCHAR2	(50)	Indicate the error in the attribute validation.
SHIP_METHOD	VARCHAR2	(50)	SHIP_METHOD_CODE if NULL, is retrieved using this value.
FREIGHT_TERMS	VARCHAR2	(50)	FREIGHT_TERMS_CODE if NULL is retrieved using this value.
TERMS	VARCHAR2	(50)	TERMS_ID if NULL is retrieved using this value.

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
,      SOURCE_LANG
,      AUTOMATIC_FLAG
,      NAME
,      DESCRIPTION
,      CURRENCY_CODE
,      VERSION_NO
,      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
,      ACTIVE_DATE_FIRST_TYPE
,      START_DATE_ACTIVE_FIRST
,      END_DATE_ACTIVE_FIRST
,      ACTIVE_DATE_SECOND_TYPE
,      START_DATE_ACTIVE_SECOND
,      END_DATE_ACTIVE_SECOND
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LANGUAGE
,      PROCESS_ID
,      PROCESS_TYPE
,      INTERFACE_ACTION_CODE
,      LOCK_FLAG
,      PROCESS_FLAG
,      DELETE_FLAG
,      PROCESS_STATUS_FLAG
,      MOBILE_DOWNLOAD
,      CURRENCY_HEADER
,      CURRENCY_HEADER_ID
,      PTE_CODE
,      LIST_SOURCE_CODE
,      ORIG_SYS_HEADER_REF
,      ORIG_ORG_ID
,      GLOBAL_FLAG
,      ATTRIBUTE_STATUS
,      SHIP_METHOD
,      FREIGHT_TERMS
,      TERMS
FROM QP.QP_INTERFACE_LIST_HEADERS;

Dependencies

[top of page]

QP.QP_INTERFACE_LIST_HEADERS does not reference any database object

QP.QP_INTERFACE_LIST_HEADERS is referenced by following:

QP: QP_INTERFACE_LIST_HEADERS#