[Home] [Help]
View: QPFV_PRODUCTS
Product: | QP - Advanced Pricing |
Description: | This view gives information about a 'Buy' Product of a Modifier or Product of a Price list. |
Implementation/DBA Data: |
APPS.QPFV_PRODUCTS
|
View Text
SELECT PA.PRODUCT_ATTRIBUTE_CONTEXT
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_PRICING'
, PA.PRODUCT_ATTRIBUTE_CONTEXT
, PA.PRODUCT_ATTRIBUTE)
, QP_PRICE_LIST_LINE_UTIL.GET_PRODUCT_VALUE('QP_ATTR_DEFNS_PRICING'
, PA.PRODUCT_ATTRIBUTE_CONTEXT
, PA.PRODUCT_ATTRIBUTE
, PA.PRODUCT_ATTR_VALUE)
, PA.PRODUCT_UOM_CODE
, MTL.UNIT_OF_MEASURE
, PA.LIST_LINE_ID
, PA.LIST_HEADER_ID
, PA.CREATION_DATE
, PA.CREATED_BY
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATED_BY
, '_DF:QP:QP_PRICING_ATTRIBUTES:PA'
FROM QP_PRICING_ATTRIBUTES PA
, MTL_UNITS_OF_MEASURE MTL
WHERE PA.EXCLUDER_FLAG = 'N'
AND PA.PRODUCT_UOM_CODE = MTL.UOM_CODE (+)
AND (PA.PRICING_ATTRIBUTE_CONTEXT IS NULL OR PA.PRICING_ATTRIBUTE_CONTEXT = 'VOLUME') WITH READ ONLY
Columns
Name |
PRODUCT_ATTRIBUTE_CONTEXT |
PRODUCT_ATTRIBUTE |
PRODUCT_ATTR_VALUE |
PRODUCT_UOM_CODE |
UOM_NAME |
LIST_LINE_ID |
LIST_HEADER_ID |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
"_DF" |