DBA Data[Home] [Help]

APPS.QP_PRICE_LIST_UTIL dependencies on QP_PRICING_ATTRIBUTES

Line 709: from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c

705: update qp_pte_segments d set used_in_setup='Y'
706: where nvl(used_in_setup,'N')='N'
707: and exists
708: (select 'x'
709: from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c
710: where c.list_header_id = p_PRICE_LIST_rec.list_header_id
711: and a.segment_mapping_column = c.pricing_attribute
712: and a.segment_id = d.segment_id
713: and a.prc_context_id = b.prc_context_id

Line 721: from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c

717: update qp_pte_segments d set used_in_setup='Y'
718: where nvl(used_in_setup,'N')='N'
719: and exists
720: (select 'x'
721: from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c
722: where c.list_header_id = p_PRICE_LIST_rec.list_header_id
723: and a.segment_mapping_column = c.product_attribute
724: and a.segment_id = d.segment_id
725: and a.prc_context_id = b.prc_context_id