[Home] [Help]
View: QPBV_TERM_SUBSTITUTIONS
Product: | QP - Advanced Pricing |
Description: | This view gives information about Term Substitutuions type of Modifiers. |
Implementation/DBA Data: |
APPS.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 |