APPS.QP_PRICE_BOOK_PVT dependencies on QP_PRICING_ATTRIBUTES

Line 1528: FROM qp_pricing_attributes

1524: CURSOR pl_items_cur(a_price_list_id NUMBER)
1525: IS
1526: SELECT DISTINCT product_attr_value item_id
1527: --Since an item can occur multiple times in a pl if attributes differ
1528: FROM qp_pricing_attributes
1529: WHERE list_header_id = a_price_list_id
1530: AND product_attribute = 'PRICING_ATTRIBUTE1' --Item Number
1531: AND product_attribute_context = 'ITEM';
1532:

Line 1609: FROM qp_pricing_attributes pa

1605: AND nvl(muom.disable_date,trunc(a_effective_date)+1) >
1606: trunc(a_effective_date)
1607: AND EXISTS (
1608: SELECT 'x'
1609: FROM qp_pricing_attributes pa
1610: WHERE pa.product_attribute_context = 'ITEM'
1611: AND pa.product_attribute = 'PRICING_ATTRIBUTE1'
1612: AND pa.product_attr_value = To_Char(a_item_id)
1613: AND pa.product_uom_code = muom.uom_code