29: , context
30: , attribute
31: , pricing_status_code
32: , qp_number.canonical_to_number(value_from)
33: FROM qp_npreq_line_attrs_tmp lattr
34: WHERE attribute_type IN ('PRICING', 'PRODUCT')
35: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
36: AND EXISTS (
37: SELECT format_type
52: ,context
53: ,attribute
54: ,pricing_status_code
55: ,qp_number.canonical_to_number(value_from)
56: FROM qp_npreq_line_attrs_tmp lattr
57: WHERE attribute_type IN ('PRICING', 'PRODUCT')
58: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
59: AND EXISTS(
60: SELECT format_type
172: ,attribute
173: ,pricing_status_code
174: ,qp_number.number_to_canonical(to_number(value_from))
175: FROM
176: qp_npreq_line_attrs_tmp lattr
177: WHERE
178: attribute_type IN ('PRICING', 'PRODUCT')
179: AND
180: pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
211: ,attribute
212: ,pricing_status_code
213: ,value_from
214: FROM
215: qp_npreq_line_attrs_tmp lattr
216: WHERE
217: attribute_type IN ('PRICING', 'PRODUCT')
218: AND
219: pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
284: ,attribute
285: ,pricing_status_code
286: ,qp_number.number_to_canonical(to_number(value_from))
287: FROM
288: qp_npreq_line_attrs_tmp lattr
289: WHERE
290: attribute_type IN ('PRICING', 'PRODUCT')
291: AND
292: pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
326: ,attribute
327: ,pricing_status_code
328: ,value_from
329: FROM
330: qp_npreq_line_attrs_tmp lattr
331: WHERE
332: attribute_type IN ('PRICING', 'PRODUCT')
333: AND
334: pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED