FND Design Data [Home] [Help]

View: QPFV_ITEM_UPGRADES

Product: QP - Advanced Pricing
Description: This view gives information about Item Upgrades type of modifiers.
Implementation/DBA Data: ViewAPPS.QPFV_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
, '_LA:INCOMPATIBILITY_GRP_CODE:QP_LOOKUPS:INCOMPATIBILITY_GROUPS:MEANING'
, LIST_LINE_TYPE_CODE
, '_LA:LIST_LINE_TYPE_CODE:QP_LOOKUPS:LIST_LINE_TYPE_CODE:MEANING'
, MODIFIER_LEVEL_CODE
, '_LA:MODIFIER_LEVEL_CODE:QP_LOOKUPS:MODIFIER_LEVEL_CODE:MEANING'
, LIST_LINE_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, '_DF:QP:QP_LIST_LINES:QP_LIST_LINES'
FROM QP_LIST_LINES
WHERE LIST_LINE_TYPE_CODE = 'IUE' WITH READ ONLY

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
"_LA:INCOMPATIBILITY_GROUPS"
LIST_LINE_TYPE_CODE
"_LA:LIST_LINE_TYPE_CODE"
MODIFIER_LEVEL_CODE
"_LA:MODIFIER_LEVEL_CODE"
LIST_LINE_ID
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
"_DF"