DBA Data[Home] [Help]

APPS.JMF_SHIKYU_ONT_PVT dependencies on QP_PRICING_ATTRIBUTES

Line 1075: FROM qp_pricing_attributes qpa

1071: l_component_price
1072: FROM qp_list_lines qp
1073: WHERE qp.list_header_id = l_price_list_id
1074: AND EXISTS (SELECT 1
1075: FROM qp_pricing_attributes qpa
1076: WHERE qpa.list_line_id = qp.list_line_id
1077: AND qpa.product_attribute_context = 'ITEM'
1078: AND qpa.product_attribute = 'PRICING_ATTRIBUTE1'
1079: AND to_number(product_attr_value) = p_item_id