[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | QP_INTERFACE_LIST_LINES |
|---|---|
| Object Type: | TABLE |
| Owner: | QP |
| FND Design Data: |  QP.QP_INTERFACE_LIST_LINES
|
| Subobject Name: | |
| Status: | VALID |
QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. This table stores all types of list lines; price list lines, all types of modifiers including price modifier list lines used to derive factors. The different types of list lines are based on Lookup Type, 'LIST_LINE_TYPE_CODE'.
Scope: public
Product: QP
Display Name: Interface List Lines
Category: BUSINESS_ENTITY QP_PRICE_LIST
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| QP_INTERFACE_LIST_LINES_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
 REQUEST_ID
PROCESS_STATUS_FLAG
ORIG_SYS_LINE_REF
|
| QP_INTERFACE_LIST_LINES_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
ORIG_SYS_HEADER_REF
|
| QP_INTERFACE_LIST_LINES_N3 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
ORIG_SYS_LINE_REF
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LIST_LINE_ID | NUMBER | Indentifies the list line. 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_HEADER_ID | NUMBER | Identifies the List header. | ||
| LIST_LINE_TYPE_CODE | VARCHAR2 | (30) | Type of list line based on lookup type LIST_LINE_TYPE_CODE. | |
| START_DATE_ACTIVE | DATE | Date the list line becomes effective | ||
| END_DATE_ACTIVE | DATE | Date the list line becomes ineffective. | ||
| AUTOMATIC_FLAG | VARCHAR2 | (1) | This indicates whether the modifier should be automatically or manually applied to the transaction. | |
| MODIFIER_LEVEL_CODE | VARCHAR2 | (30) | This indicates at what level, e.g. transaction line or header, a list line qualifies and can be applied to the transaction. Based on lookup type 'MODIFIER_LEVEL_CODE' | |
| PRICE_BY_FORMULA_ID | NUMBER | Identifier of Formula used to dynamically calculate the 'value' at the time of pricing. Mutually exclusive with Generate_Using_Formula_id | ||
| LIST_PRICE | NUMBER | Standard Selling Price or Unit Price. | ||
| LIST_PRICE_UOM_CODE | VARCHAR2 | (3) | No longer used. | |
| PRIMARY_UOM_FLAG | VARCHAR2 | (1) | Used to indicate which is the primary unit of measure (UOM) for a product on a price list. If a price cannot be found for a product in the UOM passed from the transaction application, the pricing engine will convert the transaction quantity to the primary UOM specified. This UOM then becomes the pricing UOM in which all discounts must also be specified. | |
| INVENTORY_ITEM_ID | NUMBER | Inventory item identifier in an item relationship - used for list line type Item Upgrade. | ||
| ORGANIZATION_ID | NUMBER | Organization identifier in an item relationship - used for list line type Item Upgrade. | ||
| RELATED_ITEM_ID | NUMBER | Related inventory item identifier in an item relationship - used for list line type Item Upgrade. | ||
| RELATIONSHIP_TYPE_ID | NUMBER | Relationship type identifier in an item relationship - used for list line type Item Upgrade. | ||
| SUBSTITUTION_CONTEXT | VARCHAR2 | (30) | The context of the substitution attribute - must always be TERMS. Used for modfiers of type Term Substitution. | |
| SUBSTITUTION_ATTRIBUTE | VARCHAR2 | (30) | Identifies the attribute in the TERMS context that will be substituted, e.g. QUALIFIER_ATTRIBUTE1 - Payment Terms. Used for modfiers of type Term Substitution. | |
| SUBSTITUTION_VALUE | VARCHAR2 | (240) | The value of the substitution attribute that will be substituted on the pricing request line, e.g. value '2% 30/net 60' for the Payment Terms attribute. Used for modfiers of type Term Substitution. | |
| REVISION | VARCHAR2 | (50) | Revision reference for pricing agreement lines. | |
| REVISION_DATE | DATE | Date on which this revision was created or updated. Used on pricing agreement lines. | ||
| REVISION_REASON_CODE | VARCHAR2 | (30) | Reason for creating/changing the revision. Used on pricing agreement lines. | |
| PRICE_BREAK_TYPE_CODE | VARCHAR2 | (30) | Type of price break. Based on lookup type PRICE_BREAK_TYPE_CODE. Used for modifiers of type Price Break Header or any single line product modifier with a qualifying condition containing an attribute in the VOLUME context. | |
| PERCENT_PRICE | NUMBER | Price is calculated as a percentage of the price of another item. | ||
| NUMBER_EFFECTIVE_PERIODS | NUMBER | Reserved for future use. | ||
| EFFECTIVE_PERIOD_UOM | VARCHAR2 | (3) | Reserved for future use. | |
| ARITHMETIC_OPERATOR | VARCHAR2 | (30) | Indicates the method of calculating a price or modifier value. Based on Lookup Type ARITHMETIC_OPERATOR. | |
| OPERAND | NUMBER | (32) | The numeric value of the price or modifier, used in conjunction with the ARITHMETIC_OPERATOR to determine the pricing method or method of price adjustment, charge calculation etc.. | |
| OVERRIDE_FLAG | VARCHAR2 | (1) | Indicates whether a modifier value can be overridden at the time of pricing a transaction. | |
| PRINT_ON_INVOICE_FLAG | VARCHAR2 | (1) | Reserved for future use. | |
| REBATE_TRANSACTION_TYPE_CODE | VARCHAR2 | (30) | Reserved for future use. | |
| BASE_QTY | NUMBER | No longer used. | ||
| BASE_UOM_CODE | VARCHAR2 | (3) | No longer used. | |
| ACCRUAL_QTY | NUMBER | No longer used. | ||
| ACCRUAL_UOM_CODE | VARCHAR2 | (3) | No longer used. | |
| ESTIM_ACCRUAL_RATE | NUMBER | Used to indicate the percentage rate at which to accrue (defaults to 100%) or in the case of a coupon the expected rate of redemption of the coupon. Liability would be the accrual or coupon value * ESTIM_ACCRUAL_RATE. | ||
| 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 | |
| COMMENTS | VARCHAR2 | (2000) | Additional descriptive text used on Agreement Lines. | |
| GENERATE_USING_FORMULA_ID | NUMBER | Formula identifier used to calculate the list price based on the attributes of a price list line. | ||
| REPRICE_FLAG | VARCHAR2 | (1) | Used to figure out which price list lines should be repriced while running the update rules prices concurrent program. Used only with price list lines which have formula. | |
| LIST_LINE_NO | VARCHAR2 | (30) | Modifier Number. In the case of Ask For modifiers, this reference must be quoted on the pricing transaction in order to receive the modifier benefit. | |
| ESTIM_GL_VALUE | NUMBER | The discount or surcharge value of the modifier. Used to estimate the discount cost for non-monetary modifiers. | ||
| BENEFIT_PRICE_LIST_LINE_ID | NUMBER | The price list line identifier for modifiers of type 'Promotional Goods'. Used to derive the list price for the promotional goods before discount. | ||
| EXPIRATION_PERIOD_START_DATE | DATE | Used for modifiers of type 'Coupon Issue' to indicate the date that the coupon is effective from. | ||
| NUMBER_EXPIRATION_PERIODS | NUMBER | Used, as alternative to setting the EXPIRATION_DATE, to calculate the expiration date for accruals and coupons. The number of periods, of type EXPIRATION_PERIOD_UOM, in which the accrual or coupon expires. | ||
| EXPIRATION_PERIOD_UOM | VARCHAR2 | (3) | Used, as alternative to setting the EXPIRATION_DATE, to calculate the expiration date for accruals and coupons. The type of Expiration period, e.g. 'week'. | |
| EXPIRATION_DATE | DATE | The expiration date of the accrual or coupon. | ||
| ACCRUAL_FLAG | VARCHAR2 | (1) | Indicates whether the discount is an accrual or not, i.e whether it should be applied retrospectively. | |
| PRICING_PHASE_ID | NUMBER | Pricing Phase identifier. | ||
| PRICING_GROUP_SEQUENCE | NUMBER | The pricing group sequence or pricing bucket for the modifier, based on lookup type PRICING_GROUP_SEQUENCE. | ||
| INCOMPATIBILITY_GRP_CODE | VARCHAR2 | (30) | References the Incompatibility Group that the modifier is assigned to , based on lookup type INCOMPATIBILITY GROUPS. | |
| PRODUCT_PRECEDENCE | NUMBER | The precedence number, or selectivity, of the modifier in the item context in the Pricing Attribute Descriptive Flexfield. Used by the pricing engine for incompatibility resolution. | ||
| PRORATION_TYPE_CODE | VARCHAR2 | (30) | Reserved for future use. | |
| ACCRUAL_CONVERSION_RATE | NUMBER | The rate at which a non-monetary accrual is converted to a monetary value | ||
| BENEFIT_QTY | NUMBER | The accrual quantity for non-monetary accruals, or item quantity for promotional goods. | ||
| BENEFIT_UOM_CODE | VARCHAR2 | (3) | The accrual unit of measure for non-monetary accruals, or item unit of measure for promotional goods. | |
| RECURRING_FLAG | VARCHAR2 | (1) | Not used. | |
| BENEFIT_LIMIT | NUMBER | Reserved for future use. | ||
| CHARGE_TYPE_CODE | VARCHAR2 | (30) | Used for modifiers of type Freight/Special Charge to indicate the type of charge, based on lookup type FREIGHT_CHARGES_TYPE. | |
| CHARGE_SUBTYPE_CODE | VARCHAR2 | (30) | Used to indicate the type of charge within the CHARGE_TYPE_CODE categorisation, based on lookups of the same name as lookup codes within the CHARGE_TYPE_CODE lookup type, e.g. MISCELLANEOUS. | |
| INCLUDE_ON_RETURNS_FLAG | VARCHAR2 | (1) | Applicable to modifiers of type Freight/Special Charge to indicate whether the charge should be included on a return transaction. Not used by pricing engine, for transaction system use only. | |
| QUALIFICATION_IND | NUMBER | Used to enhance the performance of the pricing engine. Indicates the setup of the data to allow the pricing engine to choose a highly selective search path. | ||
| 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 | |
| RLTD_MODIFIER_GRP_NO | NUMBER | Related Modifier Group Number | ||
| RLTD_MODIFIER_GRP_TYPE | VARCHAR2 | (30) | Related Modifier Group Type | |
| PRICE_BREAK_HEADER_INDEX | NUMBER | Price Break Header Index | ||
| PRICING_PHASE_NAME | VARCHAR2 | (240) | Pricing Phase Name | |
| RECURRING_VALUE | NUMBER | To define a 'RECURRING' price break. This means that the break repeats for every interval defined in the setup in the recurring value column | ||
| NET_AMOUNT_FLAG | VARCHAR2 | (1) | Net amount or not. | |
| ATTRIBUTE_STATUS | VARCHAR2 | (50) | Indicate the error in the attribute validation. | |
| ORIG_SYS_LINE_REF | VARCHAR2 | (50) | The combination of this and ORIG_SYS_HEADER_REF is the primary key of the equivalent of the price list line table of the external system from where the price data is loaded. | |
| ORIG_SYS_HEADER_REF | VARCHAR2 | (50) | The combination of this and ORIG_SYS_LINE_REF is the primary key of the equivalent of the price list line table of the external system from where the price data is loaded. | |
| PRICE_BREAK_HEADER_REF | VARCHAR2 | (50) | Reference of the price break header. | |
| GENERATE_USING_FORMULA | VARCHAR2 | (50) | GENERATE_USING_FORMULA_ID if NULL, is retrieved using this value | |
| PRICE_BY_FORMULA | VARCHAR2 | (50) | PRICE_BY_FORMULA_ID if NULL is retrieved using this value. | |
| CONTINUOUS_PRICE_BREAK_FLAG | VARCHAR2 | (1) | Flag to indicate whether this price break is a continuous price break or not. |
Cut, paste (and edit) the following text to query this object:
SELECT LIST_LINE_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_HEADER_ID
, LIST_LINE_TYPE_CODE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, AUTOMATIC_FLAG
, MODIFIER_LEVEL_CODE
, PRICE_BY_FORMULA_ID
, LIST_PRICE
, LIST_PRICE_UOM_CODE
, PRIMARY_UOM_FLAG
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, RELATED_ITEM_ID
, RELATIONSHIP_TYPE_ID
, SUBSTITUTION_CONTEXT
, SUBSTITUTION_ATTRIBUTE
, SUBSTITUTION_VALUE
, REVISION
, REVISION_DATE
, REVISION_REASON_CODE
, PRICE_BREAK_TYPE_CODE
, PERCENT_PRICE
, NUMBER_EFFECTIVE_PERIODS
, EFFECTIVE_PERIOD_UOM
, ARITHMETIC_OPERATOR
, OPERAND
, OVERRIDE_FLAG
, PRINT_ON_INVOICE_FLAG
, REBATE_TRANSACTION_TYPE_CODE
, BASE_QTY
, BASE_UOM_CODE
, ACCRUAL_QTY
, ACCRUAL_UOM_CODE
, ESTIM_ACCRUAL_RATE
, PROCESS_ID
, PROCESS_TYPE
, INTERFACE_ACTION_CODE
, LOCK_FLAG
, PROCESS_FLAG
, DELETE_FLAG
, PROCESS_STATUS_FLAG
, COMMENTS
, GENERATE_USING_FORMULA_ID
, REPRICE_FLAG
, LIST_LINE_NO
, ESTIM_GL_VALUE
, BENEFIT_PRICE_LIST_LINE_ID
, EXPIRATION_PERIOD_START_DATE
, NUMBER_EXPIRATION_PERIODS
, EXPIRATION_PERIOD_UOM
, EXPIRATION_DATE
, ACCRUAL_FLAG
, PRICING_PHASE_ID
, PRICING_GROUP_SEQUENCE
, INCOMPATIBILITY_GRP_CODE
, PRODUCT_PRECEDENCE
, PRORATION_TYPE_CODE
, ACCRUAL_CONVERSION_RATE
, BENEFIT_QTY
, BENEFIT_UOM_CODE
, RECURRING_FLAG
, BENEFIT_LIMIT
, CHARGE_TYPE_CODE
, CHARGE_SUBTYPE_CODE
, INCLUDE_ON_RETURNS_FLAG
, QUALIFICATION_IND
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, RLTD_MODIFIER_GRP_NO
, RLTD_MODIFIER_GRP_TYPE
, PRICE_BREAK_HEADER_INDEX
, PRICING_PHASE_NAME
, RECURRING_VALUE
, NET_AMOUNT_FLAG
, ATTRIBUTE_STATUS
, ORIG_SYS_LINE_REF
, ORIG_SYS_HEADER_REF
, PRICE_BREAK_HEADER_REF
, GENERATE_USING_FORMULA
, PRICE_BY_FORMULA
, CONTINUOUS_PRICE_BREAK_FLAG
FROM QP.QP_INTERFACE_LIST_LINES;
QP.QP_INTERFACE_LIST_LINES does not reference any database object
QP.QP_INTERFACE_LIST_LINES is referenced by following:
APPS
QP_INTERFACE_LIST_LINES
|
|
|
|