DBA Data[Home] [Help]

APPS.QP_VALIDATE_PLL_PRICING_ATTR dependencies on QP_RLTD_MODIFIERS

Line 1235: from qp_rltd_modifiers

1231:
1232: BEGIN
1233: select from_rltd_modifier_id
1234: into l_from_rltd_modifier_id
1235: from qp_rltd_modifiers
1236: where to_rltd_modifier_id = p_Pricing_Attr_rec.list_line_id;
1237: EXCEPTION
1238: WHEN OTHERS THEN
1239: l_from_rltd_modifier_id := NULL;

Line 1897: from qp_rltd_modifiers qrm

1893: from qp_pricing_attributes a, qp_pricing_attributes b
1894: where a.list_line_id = l_List_Line_ID
1895: and b.list_line_id <> l_List_Line_ID
1896: and not exists (select Null
1897: from qp_rltd_modifiers qrm
1898: Where qrm.to_rltd_modifier_id = b.list_line_id
1899: and qrm.rltd_modifier_grp_type = 'PRICE BREAK')
1900: and b.product_attribute_context = a.product_attribute_context
1901: and b.product_attribute = a.product_attribute