[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | QPBV_MODIFIER_LINES |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  QP.QPBV_MODIFIER_LINES
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
This view gives information about Discount, Surcharge, Freight and Special Charge, Price Break Header, Other item discount and Promotional goods type of modifier summary lines. These are only 'header' line for a Price Break and 'Buy' line for Other item discount and Promotional Goods.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LIST_HEADER_ID | NUMBER | Yes | ||
| PRICE_BY_FORMULA_ID | NUMBER | |||
| ARITHMETIC_OPERATOR | VARCHAR2 | (30) | ||
| OPERAND | NUMBER | |||
| OVERRIDE_FLAG | VARCHAR2 | (1) | ||
| LIST_LINE_NO | VARCHAR2 | (30) | ||
| START_DATE_ACTIVE | DATE | |||
| END_DATE_ACTIVE | DATE | |||
| PRODUCT_PRECEDENCE | NUMBER | |||
| PRIMARY_UOM_FLAG | VARCHAR2 | (1) | ||
| PRICING_PHASE_ID | NUMBER | |||
| PRICING_GROUP_SEQUENCE | NUMBER | |||
| INCLUDE_ON_RETURNS_FLAG | VARCHAR2 | (1) | ||
| EXPIRATION_PERIOD_START_DATE | DATE | |||
| NUMBER_EXPIRATION_PERIODS | NUMBER | |||
| EXPIRATION_PERIOD_UOM | VARCHAR2 | (3) | ||
| EXPIRATION_DATE | DATE | |||
| ACCRUAL_FLAG | VARCHAR2 | (1) | ||
| ESTIM_ACCRUAL_RATE | NUMBER | |||
| REBATE_TRANSACTION_TYPE_CODE | VARCHAR2 | (30) | ||
| ACCRUAL_CONVERSION_RATE | NUMBER | |||
| BENEFIT_QTY | NUMBER | |||
| BENEFIT_UOM_CODE | VARCHAR2 | (3) | ||
| CHARGE_TYPE_CODE | VARCHAR2 | (30) | ||
| CHARGE_SUBTYPE_CODE | VARCHAR2 | (30) | ||
| INCOMPATIBILITY_GRP_CODE | VARCHAR2 | (30) | ||
| LIST_LINE_TYPE_CODE | VARCHAR2 | (30) | Yes | |
| PRICE_BREAK_TYPE_CODE | VARCHAR2 | (30) | ||
| MODIFIER_LEVEL_CODE | VARCHAR2 | (30) | Yes | |
| LIST_LINE_ID | NUMBER | Yes | ||
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | Yes | ||
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | Yes | ||
| NET_AMOUNT_FLAG | VARCHAR2 | (1) | Item Amount based on Selling Price | |
| 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. | |
| 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. | |
| 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. |
Cut, paste (and edit) the following text to query this object:
SELECT LIST_HEADER_ID
, PRICE_BY_FORMULA_ID
, ARITHMETIC_OPERATOR
, OPERAND
, OVERRIDE_FLAG
, LIST_LINE_NO
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, PRODUCT_PRECEDENCE
, PRIMARY_UOM_FLAG
, PRICING_PHASE_ID
, PRICING_GROUP_SEQUENCE
, INCLUDE_ON_RETURNS_FLAG
, EXPIRATION_PERIOD_START_DATE
, NUMBER_EXPIRATION_PERIODS
, EXPIRATION_PERIOD_UOM
, EXPIRATION_DATE
, ACCRUAL_FLAG
, ESTIM_ACCRUAL_RATE
, REBATE_TRANSACTION_TYPE_CODE
, ACCRUAL_CONVERSION_RATE
, BENEFIT_QTY
, BENEFIT_UOM_CODE
, CHARGE_TYPE_CODE
, CHARGE_SUBTYPE_CODE
, INCOMPATIBILITY_GRP_CODE
, LIST_LINE_TYPE_CODE
, PRICE_BREAK_TYPE_CODE
, MODIFIER_LEVEL_CODE
, LIST_LINE_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, NET_AMOUNT_FLAG
, ACCUM_CONTEXT
, ACCUM_ATTRIBUTE
, ACCUM_ATTR_RUN_SRC_FLAG
, ORIG_SYS_HEADER_REF
, ORIG_SYS_LINE_REF
FROM APPS.QPBV_MODIFIER_LINES;
APPS
QP_LIST_LINES
QP_RLTD_MODIFIERS
APPS.QPBV_MODIFIER_LINES is not referenced by any database object
|
|
|
|