DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_PVT dependencies on QP_PRICING_ATTRIBUTES

Line 1547: FROM qp_pricing_attributes

1543: CURSOR pl_items_cur(a_price_list_id NUMBER)
1544: IS
1545: SELECT DISTINCT product_attr_value item_id
1546: --Since an item can occur multiple times in a pl if attributes differ
1547: FROM qp_pricing_attributes
1548: WHERE list_header_id = a_price_list_id
1549: AND product_attribute = 'PRICING_ATTRIBUTE1' --Item Number
1550: AND product_attribute_context = 'ITEM';
1551:

Line 1613: FROM qp_pricing_attributes pa

1609: trunc(a_effective_date)
1610: -- bug 7034445
1611: AND EXISTS (
1612: SELECT 'x'
1613: FROM qp_pricing_attributes pa
1614: WHERE pa.product_attribute_context = 'ITEM'
1615: AND pa.product_attribute = 'PRICING_ATTRIBUTE1'
1616: AND pa.product_attr_value = To_Char(a_item_id)
1617: AND pa.product_uom_code = muom.uom_code