Product: | QP - Advanced Pricing |
---|---|
Description: | This view gives information about Term Substitutuions type of Modifiers. |
Implementation/DBA Data: | APPS.QPFV_TERM_SUBSTITUTIONS |
SELECT LIST_HEADER_ID
, LIST_LINE_NO
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, PRODUCT_PRECEDENCE
, PRICING_PHASE_ID
, ESTIM_GL_VALUE
, SUBSTITUTION_CONTEXT
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_QUALIFIER'
, SUBSTITUTION_CONTEXT
, SUBSTITUTION_ATTRIBUTE)
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE_VALUE('QP_ATTR_DEFNS_QUALIFIER'
, SUBSTITUTION_CONTEXT
, SUBSTITUTION_ATTRIBUTE
, SUBSTITUTION_VALUE)
, 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 = 'TSN' WITH READ ONLY