154: c.product_uom_code list_price_uom_code ,
155: qlhb.currency_code /* Added for bug#8844209 */
156:
157: FROM
158: JAI_CMN_CUS_ADDRESSES a,
159: qp_list_lines b,
160: qp_pricing_attributes c ,
161: qp_list_headers_b qlhb /* Added for bug#8844209 */
162: WHERE
188: b.operand list_price,
189: c.product_uom_code list_price_uom_code ,
190: qlhb.currency_code /* Added for bug#8844209 */
191: FROM
192: JAI_CMN_CUS_ADDRESSES a,
193: qp_list_lines b,
194: qp_pricing_attributes c,
195: qp_list_headers_b qlhb /* Added for bug#8844209 */
196: WHERE
217: b.operand list_price,
218: c.product_uom_code list_price_uom_code ,
219: qlhb.currency_code /* Added for bug#8844209 */
220: FROM
221: JAI_CMN_CUS_ADDRESSES a,
222: qp_list_lines b,
223: qp_pricing_attributes c,
224: qp_list_headers_b qlhb /* Added for bug#8844209 */
225: WHERE
280: b.operand list_price
281: , c.product_uom_code list_price_uom_code,
282: qlhb.currency_code /* Added for bug#8844209 */
283: FROM
284: jai_cmn_cus_addresses a
285: , qp_list_lines b
286: , qp_pricing_attributes c ,
287: qp_list_headers_b qlhb /* Added for bug#8844209 */
288: WHERE a.customer_id = pn_party_id
316: b.operand list_price
317: , c.product_uom_code list_price_uom_code,
318: qlhb.currency_code /* Added for bug#8844209 */
319: FROM
320: jai_cmn_cus_addresses a
321: , qp_list_lines b
322: , qp_pricing_attributes c ,
323: qp_list_headers_b qlhb /* Added for bug#8844209 */
324: WHERE a.customer_id = pn_party_id
351: b.operand list_price
352: , c.product_uom_code list_price_uom_code,
353: qlhb.currency_code /* Added for bug#8844209 */
354: FROM
355: jai_cmn_cus_addresses a
356: , qp_list_lines b
357: , qp_pricing_attributes c ,
358: qp_list_headers_b qlhb /* Added for bug#8844209 */
359: WHERE a.customer_id = pn_party_id