APPS.QP_PRICE_LIST_PVT dependencies on QP_PRICING_ATTRIBUTES

Line 1435: , QP_PRICING_ATTRIBUTES QPPRC

1431: , l_list_price
1432: , l_percent_price
1433: FROM QP_LIST_HEADERS QPLST
1434: , QP_LIST_LINES QPLIN
1435: , QP_PRICING_ATTRIBUTES QPPRC
1436: WHERE QPLST.LIST_HEADER_ID = QPLIN.LIST_HEADER_ID
1437: AND QPLIN.LIST_LINE_ID = QPPRC.LIST_LINE_ID
1438: AND QPLIN.LIST_LINE_TYPE_CODE = G_PRC_PRICE_LIST_LINE
1439: AND DECODE(QPLIN.LIST_PRICE,NULL,G_PRC_METHOD_PERCENT,G_PRC_METHOD_AMOUNT) =

Line 2070: from qp_pricing_attributes

2066: QP_UTIL.Get_Context_Attribute('1001', l_context, l_attribute);
2067:
2068: select to_number(product_attr_value)
2069: into l_inventory_item_id
2070: from qp_pricing_attributes
2071: where list_line_id = p_list_line_id
2072: and product_attribute_context = l_context
2073: and product_attribute = l_attribute
2074: and rownum = 1;

Line 2095: from qp_pricing_attributes

2091: QP_UTIL.Get_Context_Attribute('CUSTOMER_ITEM_ID', l_context, l_attribute);
2092:
2093: select to_number(pricing_attr_value_from)
2094: into l_customer_item_id
2095: from qp_pricing_attributes
2096: where list_line_id = p_list_line_id
2097: and pricing_attribute_context = l_context
2098: and pricing_attribute = l_attribute;
2099:

Line 2120: from qp_pricing_attributes

2116: begin
2117:
2118: select pricing_attribute_context
2119: into l_pricing_context
2120: from qp_pricing_attributes
2121: where list_line_id = p_list_line_id
2122: and pricing_attribute in ('PRICING_ATTRIBUTE1',
2123: 'PRICING_ATTRIBUTE2',
2124: 'PRICING_ATTRIBUTE3',

Line 2160: from qp_pricing_attributes

2156:
2157:
2158: select pricing_attr_value_from
2159: into l_pricing_attribute1
2160: from qp_pricing_attributes
2161: where list_line_id = p_list_line_id
2162: and pricing_attribute = p_pricing_attr;
2163:
2164: return l_pricing_attribute1;

Line 2189: from QP_PRICING_ATTRIBUTES QPPA --, QP_LIST_LINES QPLL

2185: Begin
2186:
2187: SELECT 'x'
2188: Into Dummy_Variable
2189: from QP_PRICING_ATTRIBUTES QPPA --, QP_LIST_LINES QPLL
2190: Where
2191: PRODUCT_ATTRIBUTE_CONTEXT = P_Product_Attr_Context
2192: And PRODUCT_ATTRIBUTE = P_Product_Attr
2193: And PRODUCT_ATTR_VALUE = P_Product_Attr_Val

Line 2221: from qp_pricing_attributes

2217: QP_UTIL.Get_Context_Attribute ( 'UNITS',l_context, l_attribute);
2218:
2219: select to_number(pricing_attr_value_to) into
2220: l_price_break_high
2221: from qp_pricing_attributes
2222: where list_line_id = p_list_line_id
2223: and pricing_attribute_context = l_context
2224: and pricing_attribute = l_attribute;
2225:

Line 2243: from qp_pricing_attributes

2239: QP_UTIL.Get_Context_Attribute ( 'UNITS',l_context, l_attribute);
2240:
2241: select to_number(pricing_attr_value_from) into
2242: l_price_break_low
2243: from qp_pricing_attributes
2244: where list_line_id = p_list_line_id
2245: and pricing_attribute_context = l_context
2246: and pricing_attribute = l_attribute;
2247:

Line 2264: from qp_pricing_attributes

2260: QP_UTIL.Get_Context_Attribute ( '1001',l_context, l_attribute);
2261:
2262: select product_uom_code
2263: into l_uom_code
2264: from qp_pricing_attributes
2265: where list_line_id = p_list_line_id
2266: and product_attribute_context = l_context
2267: and product_attribute = l_attribute
2268: and rownum = 1;