DBA Data[Home] [Help]

APPS.QP_VALIDATE_PLL_PRICING_ATTR dependencies on QP_RLTD_MODIFIERS

Line 1178: from qp_rltd_modifiers

1174:
1175: BEGIN
1176: select from_rltd_modifier_id
1177: into l_from_rltd_modifier_id
1178: from qp_rltd_modifiers
1179: where to_rltd_modifier_id = p_Pricing_Attr_rec.list_line_id;
1180: EXCEPTION
1181: WHEN OTHERS THEN
1182: l_from_rltd_modifier_id := NULL;

Line 1840: from qp_rltd_modifiers qrm

1836: from qp_pricing_attributes a, qp_pricing_attributes b
1837: where a.list_line_id = l_List_Line_ID
1838: and b.list_line_id <> l_List_Line_ID
1839: and not exists (select Null
1840: from qp_rltd_modifiers qrm
1841: Where qrm.to_rltd_modifier_id = b.list_line_id
1842: and qrm.rltd_modifier_grp_type = 'PRICE BREAK')
1843: and b.product_attribute_context = a.product_attribute_context
1844: and b.product_attribute = a.product_attribute