[Home] [Help]
View: QPBV_ITEM_UPGRADES
| Product: | QP - Advanced Pricing |
| Description: | This view gives information about Item Upgrades type of modifiers. |
| Implementation/DBA Data: |
APPS.QPBV_ITEM_UPGRADES
|
View Text
SELECT LIST_HEADER_ID
, LIST_LINE_NO
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, ESTIM_GL_VALUE
, PRODUCT_PRECEDENCE
, PRICING_PHASE_ID
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, RELATED_ITEM_ID
, RELATIONSHIP_TYPE_ID
, INCOMPATIBILITY_GRP_CODE
, LIST_LINE_TYPE_CODE
, MODIFIER_LEVEL_CODE
, LIST_LINE_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM QP_LIST_LINES
WHERE LIST_LINE_TYPE_CODE = 'IUE'
Columns
| Name |
| LIST_HEADER_ID |
| LIST_LINE_NO |
| START_DATE_ACTIVE |
| END_DATE_ACTIVE |
| ESTIM_GL_VALUE |
| PRODUCT_PRECEDENCE |
| PRICING_PHASE_ID |
| INVENTORY_ITEM_ID |
| ORGANIZATION_ID |
| RELATED_ITEM_ID |
| RELATIONSHIP_TYPE_ID |
| INCOMPATIBILITY_GRP_CODE |
| LIST_LINE_TYPE_CODE |
| MODIFIER_LEVEL_CODE |
| LIST_LINE_ID |
| CREATION_DATE |
| CREATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |