DBA Data[Home] [Help]

APPS.QP_MULTI_CURRENCY_PVT dependencies on QP_NPREQ_LINE_ATTRS_TMP

Line 33: FROM qp_npreq_line_attrs_tmp lattr

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

Line 56: FROM qp_npreq_line_attrs_tmp lattr

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

Line 176: qp_npreq_line_attrs_tmp lattr

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

Line 215: qp_npreq_line_attrs_tmp lattr

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

Line 288: qp_npreq_line_attrs_tmp lattr

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

Line 330: qp_npreq_line_attrs_tmp lattr

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