[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | QP_LIST_SUMMARY_VL |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  QP.QP_LIST_SUMMARY_VL
|
| Subobject Name: | |
| Status: | VALID |
MultiLingual view (a language resolved view of the data.)
This view is used to display the Modifier Header summary for a given query criteria in the Pricing Organizer.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| 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 | |
| CURRENCY_CODE | VARCHAR2 | (30) | The currency of the list. | |
| 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. | |
| LIST_HEADER_ID | NUMBER | Yes | Primary Key of QP_LIST_HEADERS_B. System Generated ID | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| 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. | |
| 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. |
| TERMS_ID | NUMBER | Payment Terms on price list. Used for defaulting purposes in Order Management. | ||
| 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 | ||
| REQUEST_ID | NUMBER | 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 | ||
| DISCOUNT_LINES_FLAG | VARCHAR2 | (1) | This column is used for backward compatibility. Indicates whether there are discount lines for the list. | |
| NAME | VARCHAR2 | (240) | Yes | Price List name or Modifier List number. |
| DESCRIPTION | VARCHAR2 | (2000) | Price List Description or Modifier List Name. | |
| VERSION_NO | VARCHAR2 | (30) | List version number. This is user-defined for List Types of Promotion or Deal. | |
| COMMENTS | VARCHAR2 | (2000) | Used to record additional descriptive text for a price list or modifier 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. | |
| 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'. | |
| 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" | |
| LIST_TYPE | VARCHAR2 | (4000) | ||
| LAST_UPDATED | VARCHAR2 | (4000) | ||
| ACTIVE_DATE_FIRST | VARCHAR2 | (4000) | ||
| ACTIVE_DATE_SECOND | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CURRENCY_CODE
, SHIP_METHOD_CODE
, FREIGHT_TERMS_CODE
, LIST_HEADER_ID
, CREATION_DATE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, AUTOMATIC_FLAG
, LIST_TYPE_CODE
, TERMS_ID
, ROUNDING_FACTOR
, REQUEST_ID
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, DISCOUNT_LINES_FLAG
, NAME
, DESCRIPTION
, VERSION_NO
, COMMENTS
, GSA_INDICATOR
, PRORATE_FLAG
, SOURCE_SYSTEM_CODE
, ASK_FOR_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
, ACTIVE_FLAG
, LIST_TYPE
, LAST_UPDATED
, ACTIVE_DATE_FIRST
, ACTIVE_DATE_SECOND
FROM APPS.QP_LIST_SUMMARY_VL;
APPS
FND_USER_AP_PKG
- show dependent code
QP_LIST_HEADERS_B
QP_LIST_HEADERS_TL
QP_QP_FORM_PRICING_ATTR
- show dependent code
APPS.QP_LIST_SUMMARY_VL is not referenced by any database object
|
|
|
|