[Home] [Help]
67: AND price_list_id = new_list; */ /*Changed cursor query for bug 16574430 */
68:
69: SELECT qpll.operand list_price
70: FROM qp_list_lines qpll,
71: qp_pricing_attributes qppr
72: WHERE qppr.list_line_id = qpll.list_line_id
73: AND qpll.list_header_id = new_list
74: AND qppr.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM'
75: AND qppr.product_attribute = 'PRICING_ATTRIBUTE1'
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
163: a.customer_id = p_customer_id AND
164: a.address_id = p_address_id AND
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
197: a.customer_id = p_customer_id AND
198: a.address_id = p_address_id AND
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
226: a.customer_id = p_customer_id AND
227: a.address_id = p_address_id AND
233: NVL(qlhb.active_flag,'N') = 'Y' AND /*Added for bug#8844209*/
234: (b.end_date_active is null OR b.end_date_active >= p_ordered_date); /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
235: --NVL(b.end_date_active,SYSDATE) >= p_ordered_date;
236:
237: v_primary_uom_code qp_pricing_attributes.product_uom_code%type; --Added by Nagaraj.s for Bug3700249
238: v_other_uom_code qp_pricing_attributes.product_uom_code%type; --Added by Nagaraj.s for Bug3700249
239:
240: v_debug VARCHAR2(1); --File.Sql.35 Cbabu := 'N';
241: v_address_id NUMBER;
234: (b.end_date_active is null OR b.end_date_active >= p_ordered_date); /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
235: --NVL(b.end_date_active,SYSDATE) >= p_ordered_date;
236:
237: v_primary_uom_code qp_pricing_attributes.product_uom_code%type; --Added by Nagaraj.s for Bug3700249
238: v_other_uom_code qp_pricing_attributes.product_uom_code%type; --Added by Nagaraj.s for Bug3700249
239:
240: v_debug VARCHAR2(1); --File.Sql.35 Cbabu := 'N';
241: v_address_id NUMBER;
242: v_assessable_value NUMBER;
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
289: AND a.address_id = pn_address_id
290: AND a.price_list_id = b.list_header_id
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
325: AND a.address_id = pn_address_id
326: AND a.price_list_id = b.list_header_id
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
360: AND a.address_id = pn_address_id
361: AND a.price_list_id = b.list_header_id
899: AND NVL(END_DATE_ACTIVE,SYSDATE);*/ /*Changed cursor query for bug 16574430 */
900:
901: SELECT qpll.operand list_price
902: FROM qp_list_lines qpll,
903: qp_pricing_attributes qppr
904: WHERE qppr.list_line_id = qpll.list_line_id
905: AND qpll.list_header_id = new_no
906: AND qppr.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM'
907: AND qppr.product_attribute = 'PRICING_ATTRIBUTE1'