[Home] [Help]
3146: BEGIN
3147: SELECT f.segment_level
3148: INTO l_seg_level
3149: FROM qp_prc_contexts_b d,
3150: qp_segments_b e, qp_pte_segments f
3151: WHERE d.prc_context_code =p_qualifier_rec.qualifier_context(I)
3152: AND e.segment_mapping_column = p_qualifier_rec.qualifier_attribute(I)
3153: AND d.prc_context_id = e.prc_context_id
3154: AND e.segment_id = f.segment_id
4173: begin
4174: SELECT 1
4175: into l_exist
4176: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d,
4177: qp_segments_b e, qp_pte_segments f
4178: WHERE orig_sys_pricing_attr_ref = p_pricing_attr_rec.orig_sys_pricing_attr_ref(I)
4179: AND b.product_attribute_context = d.prc_context_code
4180: AND b.product_attribute = e.segment_mapping_column
4181: AND d.prc_context_id = e.prc_context_id
5882: SELECT 'x'
5883: FROM qp_interface_qualifiers b,
5884: qp_prc_contexts_b d,
5885: qp_segments_b e,
5886: qp_pte_segments f
5887: WHERE b.qualifier_context = d.prc_context_code
5888: AND b.qualifier_attribute = e.segment_mapping_column
5889: and e.segment_code = b.qualifier_attribute_code
5890: AND d.prc_context_id = e.prc_context_id
5916: SELECT 'x'
5917: FROM qp_interface_qualifiers b,
5918: qp_prc_contexts_b d,
5919: qp_segments_b e,
5920: qp_pte_segments f
5921: WHERE b.qualifier_context = d.prc_context_code
5922: and e.segment_code = b.qualifier_attribute_code
5923: AND d.prc_context_id = e.prc_context_id
5924: AND d.prc_context_type = 'QUALIFIER'
5948: SELECT 'x'
5949: FROM qp_interface_qualifiers b,
5950: qp_prc_contexts_b d,
5951: qp_segments_b e,
5952: qp_pte_segments f
5953: WHERE b.qualifier_context = d.prc_context_code
5954: AND b.qualifier_attribute = e.segment_mapping_column
5955: AND d.prc_context_id = e.prc_context_id
5956: AND d.prc_context_type = 'QUALIFIER'
6455: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref
6456: AND qpip.pricing_attribute_context IS NULL
6457: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6458: AND EXISTS ( SELECT 'x'
6459: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6460: WHERE b.product_attribute_context = d.prc_context_code
6461: AND b.product_attribute = e.segment_mapping_column
6462: and e.segment_code = b.product_attr_code
6463: AND d.prc_context_id = e.prc_context_id
6467: AND f.segment_level <> 'LINE'
6468: AND qpip.rowid = b.rowid
6469: union
6470: SELECT 'x'
6471: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6472: WHERE b.product_attribute_context = d.prc_context_code
6473: AND b.product_attribute is NULL and e.segment_code = b.product_attr_code
6474: AND d.prc_context_id = e.prc_context_id
6475: AND d.prc_context_type = 'PRODUCT'
6507: AND qpip.product_attr_code IS NOT NULL
6508: AND qpip.product_attr_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
6509: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6510: AND NOT EXISTS ( SELECT 'x'
6511: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6512: WHERE b.product_attribute_context = d.prc_context_code
6513: AND b.product_attribute = e.segment_mapping_column
6514: and e.segment_code = b.product_attr_code
6515: AND d.prc_context_id = e.prc_context_id
6540: AND qpip.product_attr_code IS NOT NULL
6541: AND qpip.product_attr_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
6542: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6543: AND NOT EXISTS ( SELECT 'x'
6544: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6545: WHERE b.product_attribute_context = d.prc_context_code
6546: and e.segment_code = b.product_attr_code
6547: AND d.prc_context_id = e.prc_context_id
6548: AND d.prc_context_type = 'PRODUCT'
6571: AND qpip.product_attribute IS NOT NULL
6572: AND qpip.product_attr_code IS NULL
6573: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6574: AND NOT EXISTS ( SELECT 'x'
6575: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6576: WHERE b.product_attribute_context = d.prc_context_code
6577: AND b.product_attribute = e.segment_mapping_column
6578: AND d.prc_context_id = e.prc_context_id
6579: AND d.prc_context_type = 'PRODUCT'
6609: AND qpip.pricing_attr_code IS NOT NULL
6610: AND qpip.pricing_attr_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
6611: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6612: AND NOT EXISTS ( SELECT 'x'
6613: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6614: WHERE b.pricing_attribute_context = d.prc_context_code
6615: AND b.pricing_attribute = e.segment_mapping_column
6616: and e.segment_code = b.pricing_attr_code
6617: AND d.prc_context_id = e.prc_context_id
6642: AND qpip.pricing_attr_code IS NOT NULL
6643: AND qpip.pricing_attr_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
6644: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6645: AND NOT EXISTS ( SELECT 'x'
6646: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6647: WHERE b.pricing_attribute_context = d.prc_context_code
6648: and e.segment_code = b.pricing_attr_code
6649: AND d.prc_context_id = e.prc_context_id
6650: AND d.prc_context_type = 'PRICING_ATTRIBUTE'
6673: AND qpip.pricing_attribute IS NOT NULL
6674: AND qpip.pricing_attr_code IS NULL
6675: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6676: AND NOT EXISTS ( SELECT 'x'
6677: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6678: WHERE b.pricing_attribute_context = d.prc_context_code
6679: AND b.pricing_attribute = e.segment_mapping_column
6680: AND d.prc_context_id = e.prc_context_id
6681: AND d.prc_context_type = 'PRICING_ATTRIBUTE'