VIEW: APPS.QP_PRICE_LIST_ITEMS_V

Source

View Text - Preformatted

SELECT unique h.name||' - '|| substr(mtl.concatenated_segments,1,1700) list_item, h.name, a.product_attr_value, substr(mtl.concatenated_segments,1,2000) concatenated_segments, d.list_line_id, d.operand, a.product_uom_code, d.start_date_active, d.end_date_active, d.price_by_formula_id FROM qp_secu_list_headers_vl h, qp_list_lines d, qp_pricing_attributes a, (select m.concatenated_segments concatenated_segments,to_char(m.inventory_item_id) product_id,1 type from mtl_system_items_kfv m where organization_id = fnd_profile.value('QP_ORGANIZATION_ID') UNION ALL select c.concatenated_segments concatenated_segments,to_char(c.category_id) product_id,2 type from mtl_categories_kfv c UNION ALL select QP_UTIL.Get_Attribute_Value_Meaning('QP_ATTR_DEFNS_PRICING', 'ITEM', 'PRICING_ATTRIBUTE3', 'ALL', '=') concatenated_segments,'ALL' product_id,3 type from dual) mtl WHERE h.list_type_code ='PRL' and d.list_line_type_code in ('PLL') and d.list_header_id = h.list_header_id and d.list_line_id = a.list_line_id and d.price_by_formula_id is null AND a.product_attr_value = mtl.product_id and ((mtl.type = 1 and a.PRODUCT_ATTRIBUTE = 'PRICING_ATTRIBUTE1') or (mtl.type = 2 and a.PRODUCT_ATTRIBUTE = 'PRICING_ATTRIBUTE2') or (mtl.type = 3 and a.PRODUCT_ATTRIBUTE = 'PRICING_ATTRIBUTE3')) AND h.view_flag = 'Y'

View Text - HTML Formatted

SELECT UNIQUE H.NAME||' - '|| SUBSTR(MTL.CONCATENATED_SEGMENTS
, 1
, 1700) LIST_ITEM
, H.NAME
, A.PRODUCT_ATTR_VALUE
, SUBSTR(MTL.CONCATENATED_SEGMENTS
, 1
, 2000) CONCATENATED_SEGMENTS
, D.LIST_LINE_ID
, D.OPERAND
, A.PRODUCT_UOM_CODE
, D.START_DATE_ACTIVE
, D.END_DATE_ACTIVE
, D.PRICE_BY_FORMULA_ID
FROM QP_SECU_LIST_HEADERS_VL H
, QP_LIST_LINES D
, QP_PRICING_ATTRIBUTES A
, (SELECT M.CONCATENATED_SEGMENTS CONCATENATED_SEGMENTS
, TO_CHAR(M.INVENTORY_ITEM_ID) PRODUCT_ID
, 1 TYPE
FROM MTL_SYSTEM_ITEMS_KFV M
WHERE ORGANIZATION_ID = FND_PROFILE.VALUE('QP_ORGANIZATION_ID') UNION ALL SELECT C.CONCATENATED_SEGMENTS CONCATENATED_SEGMENTS
, TO_CHAR(C.CATEGORY_ID) PRODUCT_ID
, 2 TYPE
FROM MTL_CATEGORIES_KFV C UNION ALL SELECT QP_UTIL.GET_ATTRIBUTE_VALUE_MEANING('QP_ATTR_DEFNS_PRICING'
, 'ITEM'
, 'PRICING_ATTRIBUTE3'
, 'ALL'
, '=') CONCATENATED_SEGMENTS
, 'ALL' PRODUCT_ID
, 3 TYPE
FROM DUAL) MTL
WHERE H.LIST_TYPE_CODE ='PRL'
AND D.LIST_LINE_TYPE_CODE IN ('PLL')
AND D.LIST_HEADER_ID = H.LIST_HEADER_ID
AND D.LIST_LINE_ID = A.LIST_LINE_ID
AND D.PRICE_BY_FORMULA_ID IS NULL
AND A.PRODUCT_ATTR_VALUE = MTL.PRODUCT_ID
AND ((MTL.TYPE = 1
AND A.PRODUCT_ATTRIBUTE = 'PRICING_ATTRIBUTE1') OR (MTL.TYPE = 2
AND A.PRODUCT_ATTRIBUTE = 'PRICING_ATTRIBUTE2') OR (MTL.TYPE = 3
AND A.PRODUCT_ATTRIBUTE = 'PRICING_ATTRIBUTE3'))
AND H.VIEW_FLAG = 'Y'