FND Design Data [Home] [Help]

View: QPBV_TERM_SUBSTITUTIONS

Product: QP - Advanced Pricing
Description: This view gives information about Term Substitutuions type of Modifiers.
Implementation/DBA Data: ViewAPPS.QPBV_TERM_SUBSTITUTIONS
View Text

SELECT LIST_HEADER_ID
, LIST_LINE_NO
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, PRODUCT_PRECEDENCE
, PRICING_PHASE_ID
, ESTIM_GL_VALUE
, SUBSTITUTION_CONTEXT
, SUBSTITUTION_ATTRIBUTE
, SUBSTITUTION_VALUE
, 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 = 'TSN'

Columns

Name
LIST_HEADER_ID
LIST_LINE_NO
START_DATE_ACTIVE
END_DATE_ACTIVE
PRODUCT_PRECEDENCE
PRICING_PHASE_ID
ESTIM_GL_VALUE
SUBSTITUTION_CONTEXT
SUBSTITUTION_ATTRIBUTE
SUBSTITUTION_VALUE
INCOMPATIBILITY_GRP_CODE
LIST_LINE_TYPE_CODE
MODIFIER_LEVEL_CODE
LIST_LINE_ID
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY