[Home] [Help] [Dependency Information]
Object Name: | QPFV_MODIFIER_LINES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | QP.QPFV_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 | |||
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 | |||
EXPIRATION_PERIOD_START_DATE | DATE | |||
NUMBER_EXPIRATION_PERIODS | NUMBER | |||
EXPIRATION_DATE | DATE | |||
ACCRUAL_FLAG | VARCHAR2 | (1) | ||
ESTIM_ACCRUAL_RATE | NUMBER | |||
ACCRUAL_CONVERSION_RATE | NUMBER | |||
BENEFIT_QTY | NUMBER | |||
BENEFIT_UOM_CODE | VARCHAR2 | (3) | ||
BENEFIT_UOM_NAME | VARCHAR2 | (25) | This is the name of benefit uom code. | |
PRICING_GROUP_SEQUENCE | NUMBER | |||
_LA:PRICING_GROUP_SEQUENCE | CHAR | (71) | ||
ARITHMETIC_OPERATOR | VARCHAR2 | (30) | ||
_LA:ARITHMETIC_OPERATOR | CHAR | (65) | ||
EXPIRATION_PERIOD_UOM | VARCHAR2 | (3) | ||
EXP_PERIOD_UOM_NAME | VARCHAR2 | (25) | This is the name of expiration period uom code. | |
REBATE_TRANSACTION_TYPE | VARCHAR2 | (30) | ||
_LA:REBATE_TRANSACTION_TYPE | CHAR | (83) | ||
CHARGE_TYPE_CODE | VARCHAR2 | (30) | ||
_LA:CHARGE_TYPE_CODE | CHAR | (63) | ||
CHARGE_SUBTYPE_CODE | VARCHAR2 | (30) | ||
INCOMPATIBILITY_GRP_CODE | VARCHAR2 | (30) | ||
_LA:INCOMPATIBILITY_GRP_CODE | CHAR | (73) | ||
LIST_LINE_TYPE_CODE | VARCHAR2 | (30) | Yes | |
_LA:LIST_LINE_TYPE_CODE | CHAR | (65) | ||
PRICE_BREAK_TYPE_CODE | VARCHAR2 | (30) | ||
_LA:PRICE_BREAK_TYPE_CODE | CHAR | (69) | ||
MODIFIER_LEVEL_CODE | VARCHAR2 | (30) | Yes | |
_LA:MODIFIER_LEVEL_CODE | CHAR | (65) | ||
LIST_LINE_ID | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
_DF | CHAR | (23) | Descriptive Flexfield column values of qp_list_lines table. | |
NET_AMOUNT_FLAG | VARCHAR2 | (1) | ||
ACCUM_CONTEXT | VARCHAR2 | (30) | ||
ACCUM_ATTRIBUTE | VARCHAR2 | (4000) | ||
ACCUM_ATTR_RUN_SRC_FLAG | VARCHAR2 | (1) | ||
ORIG_SYS_HEADER_REF | VARCHAR2 | (50) | ||
ORIG_SYS_LINE_REF | VARCHAR2 | (50) |
Cut, paste (and edit) the following text to query this object:
SELECT LIST_HEADER_ID
, PRICE_BY_FORMULA_ID
, OPERAND
, OVERRIDE_FLAG
, LIST_LINE_NO
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, PRODUCT_PRECEDENCE
, PRIMARY_UOM_FLAG
, PRICING_PHASE_ID
, EXPIRATION_PERIOD_START_DATE
, NUMBER_EXPIRATION_PERIODS
, EXPIRATION_DATE
, ACCRUAL_FLAG
, ESTIM_ACCRUAL_RATE
, ACCRUAL_CONVERSION_RATE
, BENEFIT_QTY
, BENEFIT_UOM_CODE
, BENEFIT_UOM_NAME
, PRICING_GROUP_SEQUENCE
, _LA:PRICING_GROUP_SEQUENCE
, ARITHMETIC_OPERATOR
, _LA:ARITHMETIC_OPERATOR
, EXPIRATION_PERIOD_UOM
, EXP_PERIOD_UOM_NAME
, REBATE_TRANSACTION_TYPE
, _LA:REBATE_TRANSACTION_TYPE
, CHARGE_TYPE_CODE
, _LA:CHARGE_TYPE_CODE
, CHARGE_SUBTYPE_CODE
, INCOMPATIBILITY_GRP_CODE
, _LA:INCOMPATIBILITY_GRP_CODE
, LIST_LINE_TYPE_CODE
, _LA:LIST_LINE_TYPE_CODE
, PRICE_BREAK_TYPE_CODE
, _LA:PRICE_BREAK_TYPE_CODE
, MODIFIER_LEVEL_CODE
, _LA:MODIFIER_LEVEL_CODE
, LIST_LINE_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, _DF
, NET_AMOUNT_FLAG
, ACCUM_CONTEXT
, ACCUM_ATTRIBUTE
, ACCUM_ATTR_RUN_SRC_FLAG
, ORIG_SYS_HEADER_REF
, ORIG_SYS_LINE_REF
FROM APPS.QPFV_MODIFIER_LINES;
APPS.QPFV_MODIFIER_LINES is not referenced by any database object
|
|
|