DBA Data[Home] [Help]

APPS.QP_MODIFIER_LIST_UTIL dependencies on QP_PRICING_ATTRIBUTES

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

925: update qp_pte_segments d set used_in_setup='Y'
926: where nvl(used_in_setup,'N')='N'
927: and exists
928: (select 'x'
929: from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c
930: where c.list_header_id = p_MODIFIER_LIST_rec.list_header_id
931: and a.segment_mapping_column = c.pricing_attribute
932: and a.segment_id = d.segment_id
933: and a.prc_context_id = b.prc_context_id

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

937: update qp_pte_segments d set used_in_setup='Y'
938: where nvl(used_in_setup,'N')='N'
939: and exists
940: (select 'x'
941: from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c
942: where c.list_header_id = p_MODIFIER_LIST_rec.list_header_id
943: and a.segment_mapping_column = c.product_attribute
944: and a.segment_id = d.segment_id
945: and a.prc_context_id = b.prc_context_id

Line 2053: DELETE FROM QP_PRICING_ATTRIBUTES

2049:
2050: FOR list_lines in C1(p_list_header_id)
2051: LOOP
2052:
2053: DELETE FROM QP_PRICING_ATTRIBUTES
2054: WHERE LIST_LINE_ID = list_lines.list_line_id;
2055:
2056: DELETE FROM QP_RLTD_MODIFIERS
2057: WHERE FROM_RLTD_MODIFIER_ID = list_lines.list_line_id;