DBA Data[Home] [Help]

APPS.QP_MODIFIER_LIST_UTIL dependencies on QP_PRICING_ATTRIBUTES

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

1035: update qp_pte_segments d set used_in_setup='Y'
1036: where nvl(used_in_setup,'N')='N'
1037: and exists
1038: (select 'x'
1039: from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c
1040: where c.list_header_id = p_MODIFIER_LIST_rec.list_header_id
1041: and a.segment_mapping_column = c.pricing_attribute
1042: and a.segment_id = d.segment_id
1043: and a.prc_context_id = b.prc_context_id

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

1047: update qp_pte_segments d set used_in_setup='Y'
1048: where nvl(used_in_setup,'N')='N'
1049: and exists
1050: (select 'x'
1051: from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c
1052: where c.list_header_id = p_MODIFIER_LIST_rec.list_header_id
1053: and a.segment_mapping_column = c.product_attribute
1054: and a.segment_id = d.segment_id
1055: and a.prc_context_id = b.prc_context_id

Line 2284: DELETE FROM QP_PRICING_ATTRIBUTES

2280:
2281: FOR list_lines in C1(p_list_header_id)
2282: LOOP
2283:
2284: DELETE FROM QP_PRICING_ATTRIBUTES
2285: WHERE LIST_LINE_ID = list_lines.list_line_id;
2286:
2287: DELETE FROM QP_RLTD_MODIFIERS
2288: WHERE FROM_RLTD_MODIFIER_ID = list_lines.list_line_id;