[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| 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
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| QP_INTERFACE_LIST_HEADERS_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
 REQUEST_ID
PROCESS_STATUS_FLAG
|
| 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
|
| Name | Datatype | Length | Mandatory | 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. |
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;
QP.QP_INTERFACE_LIST_HEADERS does not reference any database object
QP.QP_INTERFACE_LIST_HEADERS is referenced by following:
APPS
QP_INTERFACE_LIST_HEADERS
|
|
|
|