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_LINES

Object Details

Object Name:	QP_LIST_LINES
Object Type:	TABLE
Owner:	QP
FND Design Data:	QP.QP_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'.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QP_LIST_LINES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	LIST_LINE_ID
QP_LIST_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LIST_HEADER_ID LIST_LINE_NO
QP_LIST_LINES_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID
QP_LIST_LINES_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORIG_SYS_HEADER_REF ORIG_SYS_LINE_REF LIST_HEADER_ID
QP_LIST_LINES_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BREAK_UOM_CONTEXT BREAK_UOM_ATTRIBUTE
QP_LIST_LINES_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCUM_CONTEXT ACCUM_ATTRIBUTE
QP_LIST_LINES_N14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CACHE_KEY
QP_LIST_LINES_N15	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LIST_HEADER_ID REQUEST_ID
QP_LIST_LINES_N16	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LIST_HEADER_ID PATTERN_ID HASH_KEY PRICING_PHASE_ID START_DATE_ACTIVE END_DATE_ACTIVE PTE_CODE
QP_LIST_LINES_N17	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRICING_PHASE_ID PATTERN_ID HASH_KEY START_DATE_ACTIVE END_DATE_ACTIVE PTE_CODE
QP_LIST_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUALIFICATION_IND PRICING_PHASE_ID LIST_LINE_TYPE_CODE LIST_HEADER_ID
QP_LIST_LINES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUALIFICATION_IND LIST_LINE_TYPE_CODE MODIFIER_LEVEL_CODE
QP_LIST_LINES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MODIFIER_LEVEL_CODE PRICING_PHASE_ID
QP_LIST_LINES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRICING_PHASE_ID QUALIFICATION_IND LIST_HEADER_ID LIST_LINE_TYPE_CODE
QP_LIST_LINES_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRICE_BY_FORMULA_ID
QP_LIST_LINES_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GENERATE_USING_FORMULA_ID
QP_LIST_LINES_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PATTERN_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LIST_LINE_ID	NUMBER		Yes	Indentifies the list line. System Generated ID
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_HEADER_ID	NUMBER		Yes	Identifies the List header.
LIST_LINE_TYPE_CODE	VARCHAR2	(30)	Yes	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)	Yes	This indicates whether the modifier should be automatically or manually applied to the transaction.
MODIFIER_LEVEL_CODE	VARCHAR2	(30)	Yes	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			This column is no longer used. Had prior use for R11 compatibility.
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			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.
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.
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
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.
LIMIT_EXISTS_FLAG	VARCHAR2	(1)		Indicates whether there are Limits associated to this List Line.
GROUP_COUNT	NUMBER			This column stores the number of attributes with search_ind = 2 for each list_line_id.
NET_AMOUNT_FLAG	VARCHAR2	(1)		Item Amount based on Selling Price
RECURRING_VALUE	NUMBER			Holds the recurring value in block price breaks
ACCUM_CONTEXT	VARCHAR2	(30)		Context of an accumulation attribute.
ACCUM_ATTRIBUTE	VARCHAR2	(240)		The name of the volume attribute designated as the accumulation attribute.
ACCUM_ATTR_RUN_SRC_FLAG	VARCHAR2	(1)		This flag indicates whether or not accumulation value should be runtime sourced with custom API; only applicable for modifier list lines in accumulated range break processing.
CUSTOMER_ITEM_ID	NUMBER			Identifies the customer item associated with this list line. Primary key of mtl_customer_items.
BREAK_UOM_CODE	VARCHAR2	(3)		Unit of measure code for the price break. Optional. Column should not be available if list_line_type_code = 'PLL'.
BREAK_UOM_CONTEXT	VARCHAR2	(30)		Context to define the seeded context for break UOM. Mandatory if break_uom_code is populated, else should be null.
BREAK_UOM_ATTRIBUTE	VARCHAR2	(30)		Attribute in which the calling application is supposed to pass the break UOM of the volume attribute used for the break. Mandatory if break_uom_code is populated, else should be null.
PATTERN_ID	NUMBER			Identifier for product pattern. Maps to qp_patterns.pattern_id where pattern_type='PP'.
PRODUCT_UOM_CODE	VARCHAR2	(3)		Denormalized data from qp_pricing_attributes.product_uom_code
PRICING_ATTRIBUTE_COUNT	NUMBER			Total count of pricing attributes attached to the list line irrespective of operator_code
HASH_KEY	VARCHAR2	(2000)		Concatenation of product and pricing attribute values, delimited by the pipe character ('\|'). Maps to setup values of segment IDs in qp_patterns.pattern_string in the same order.
CACHE_KEY	VARCHAR2	(240)		For factor list line, same value as list_header_id. For price list line and modifier line (which does not have any line-level qualifier, but product attached), the value is in the format 'list_header_id\|product_segment_id\|product_attribute_value'.
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.
CONTINUOUS_PRICE_BREAK_FLAG	VARCHAR2	(1)		Indicates whether the price break is continuous
EQ_FLAG	VARCHAR2	(1)
CURRENCY_HEADER_ID	NUMBER
NULL_OTHER_OPRT_COUNT	NUMBER
PTE_CODE	VARCHAR2	(30)
SOURCE_SYSTEM_CODE	VARCHAR2	(30)
SERVICE_DURATION	NUMBER
SERVICE_PERIOD	VARCHAR2	(3)

Query Text

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
,      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
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      INCLUDE_ON_RETURNS_FLAG
,      QUALIFICATION_IND
,      LIMIT_EXISTS_FLAG
,      GROUP_COUNT
,      NET_AMOUNT_FLAG
,      RECURRING_VALUE
,      ACCUM_CONTEXT
,      ACCUM_ATTRIBUTE
,      ACCUM_ATTR_RUN_SRC_FLAG
,      CUSTOMER_ITEM_ID
,      BREAK_UOM_CODE
,      BREAK_UOM_CONTEXT
,      BREAK_UOM_ATTRIBUTE
,      PATTERN_ID
,      PRODUCT_UOM_CODE
,      PRICING_ATTRIBUTE_COUNT
,      HASH_KEY
,      CACHE_KEY
,      ORIG_SYS_LINE_REF
,      ORIG_SYS_HEADER_REF
,      CONTINUOUS_PRICE_BREAK_FLAG
,      EQ_FLAG
,      CURRENCY_HEADER_ID
,      NULL_OTHER_OPRT_COUNT
,      PTE_CODE
,      SOURCE_SYSTEM_CODE
,      SERVICE_DURATION
,      SERVICE_PERIOD
FROM QP.QP_LIST_LINES;

Dependencies

[top of page]

QP.QP_LIST_LINES does not reference any database object

QP.QP_LIST_LINES is referenced by following:

QP: QP_LIST_LINES#