eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_OFFER_BACKDATE_PVT dependencies on QP_LIST_LINES

Line 1171: qp_list_lines ql

1167: ql.list_line_id,
1168: ql.arithmetic_operator,
1169: ql.operand
1170: from qp_pricing_attributes qp,
1171: qp_list_lines ql
1172: where ql.list_header_id = l_id
1173: and qp.list_header_id = l_id -- julou added for sql performance xxfix
1174: and ql.list_line_id = qp.list_line_id
1175: and qp.excluder_flag = 'N';

Line 1336: FROM qp_list_lines

1332:
1333: -- julou backdated offer for Promotional Goods, Trade Deal, Tiered Discount
1334: CURSOR c_qp_line_detail(l_list_line_id NUMBER) IS
1335: SELECT *
1336: FROM qp_list_lines
1337: WHERE list_line_id = l_list_line_id;
1338: l_qp_line_detail c_qp_line_detail%ROWTYPE;
1339: l_qp_rltd_line_detail c_qp_line_detail%ROWTYPE;
1340:

Line 1476: FROM qp_list_lines

1472: l_offer_type VARCHAR2(30);
1473:
1474: CURSOR c_qp_line_detail(p_list_header_id NUMBER) IS
1475: SELECT *
1476: FROM qp_list_lines
1477: WHERE list_header_id = p_list_header_id;
1478: l_qp_line_detail c_qp_line_detail%ROWTYPE;
1479:
1480:

Line 1488: (SELECT operand FROM qp_list_lines WHERE list_header_id

1484: FROM OZF_OFFER_ADJUSTMENT_TIERS
1485: WHERE
1486: offer_adjustment_id = p_offer_adjustment_id
1487: AND original_discount =
1488: (SELECT operand FROM qp_list_lines WHERE list_header_id
1489: = (select qp_list_header_id FROM ozf_offer_adjustment_tiers WHERE offer_adjustment_id = p_offer_adjustment_id and rownum < 2)
1490: and rownum < 2)
1491: ;
1492:

Line 1941: FROM ozf_offer_adjustment_products a, ozf_offer_discount_lines b, ozf_offer_adjustments_b c, qp_list_lines d

1937: AND a.product_attr_value = d.product_attr_value
1938: AND a.offer_adjustment_id = p_offer_adjustment_id;
1939: CURSOR c_prod_reln(p_offer_adjustment_id NUMBER) IS
1940: SELECT b.offer_discount_line_id , d.list_line_id
1941: FROM ozf_offer_adjustment_products a, ozf_offer_discount_lines b, ozf_offer_adjustments_b c, qp_list_lines d
1942: WHERE a.offer_discount_line_id = DECODE(b.tier_type,'PBH',offer_discount_line_id,parent_discount_line_id)
1943: AND b.offer_adjustment_id = a.offer_adjustment_id
1944: AND a.offer_adjustment_id = p_offer_adjustment_id
1945: AND c.list_header_id = d.list_header_id

Line 2092: Ideally the best way to adjust tiers would be to end date qp_list_lines with the effective date of the offer adjustment

2088:
2089:
2090: /**
2091: THis procedure has been trimmed down in its approach due to the following issues.
2092: Ideally the best way to adjust tiers would be to end date qp_list_lines with the effective date of the offer adjustment
2093: and create new qp_list_lines with new discounts and effective date for new tiers.
2094: Since qp overlapping logic does not account for the end_Date of a list line, this approach does not work.
2095: Second approach is to end date the whole pbh qp_list_line and recreate new pbh qp_list_line.
2096: But this is a lot of work and at this stage this will be hard to pull up since it is a sensitive code and mistake here will

Line 2093: and create new qp_list_lines with new discounts and effective date for new tiers.

2089:
2090: /**
2091: THis procedure has been trimmed down in its approach due to the following issues.
2092: Ideally the best way to adjust tiers would be to end date qp_list_lines with the effective date of the offer adjustment
2093: and create new qp_list_lines with new discounts and effective date for new tiers.
2094: Since qp overlapping logic does not account for the end_Date of a list line, this approach does not work.
2095: Second approach is to end date the whole pbh qp_list_line and recreate new pbh qp_list_line.
2096: But this is a lot of work and at this stage this will be hard to pull up since it is a sensitive code and mistake here will
2097: mess up the whole volume offer.

Line 2148: -- inactivate existing qp_list_lines

2144: FND_MSG_PUB.INITIALIZE;
2145: END IF;*/
2146: x_return_status := FND_API.G_RET_STS_SUCCESS;
2147: ozf_utility_pvt.debug_message('Private API:'|| l_api_name || ' Start');
2148: -- inactivate existing qp_list_lines
2149: DECLARE
2150: CURSOR c_qp_list_lines(p_adjustment_id NUMBER)
2151: IS
2152: SELECT c.list_line_id , c.list_header_id , d.effective_date , a.modified_discount, c.arithmetic_operator

Line 2150: CURSOR c_qp_list_lines(p_adjustment_id NUMBER)

2146: x_return_status := FND_API.G_RET_STS_SUCCESS;
2147: ozf_utility_pvt.debug_message('Private API:'|| l_api_name || ' Start');
2148: -- inactivate existing qp_list_lines
2149: DECLARE
2150: CURSOR c_qp_list_lines(p_adjustment_id NUMBER)
2151: IS
2152: SELECT c.list_line_id , c.list_header_id , d.effective_date , a.modified_discount, c.arithmetic_operator
2153: FROM ozf_offer_adjustment_tiers a, ozf_qp_discounts b , qp_list_Lines c, ozf_offer_adjustments_b d
2154: WHERE a.offer_discount_line_id = b.offer_discount_line_id

Line 2153: FROM ozf_offer_adjustment_tiers a, ozf_qp_discounts b , qp_list_Lines c, ozf_offer_adjustments_b d

2149: DECLARE
2150: CURSOR c_qp_list_lines(p_adjustment_id NUMBER)
2151: IS
2152: SELECT c.list_line_id , c.list_header_id , d.effective_date , a.modified_discount, c.arithmetic_operator
2153: FROM ozf_offer_adjustment_tiers a, ozf_qp_discounts b , qp_list_Lines c, ozf_offer_adjustments_b d
2154: WHERE a.offer_discount_line_id = b.offer_discount_line_id
2155: AND b.list_line_id = c.list_line_id
2156: AND a.offer_adjustment_id = d.offer_adjustment_id
2157: AND a.offer_adjustment_id = p_adjustment_id;

Line 2160: for l_qp_list_lines in c_qp_list_lines(p_offer_adjustment_id) LOOP

2156: AND a.offer_adjustment_id = d.offer_adjustment_id
2157: AND a.offer_adjustment_id = p_adjustment_id;
2158:
2159: BEGIN
2160: for l_qp_list_lines in c_qp_list_lines(p_offer_adjustment_id) LOOP
2161: i := i+1;
2162: l_modifier_list_rec.offer_type := 'VOLUME_OFFER';
2163: l_modifier_list_rec.qp_list_header_id := l_qp_list_lines.list_header_id;
2164:

Line 2163: l_modifier_list_rec.qp_list_header_id := l_qp_list_lines.list_header_id;

2159: BEGIN
2160: for l_qp_list_lines in c_qp_list_lines(p_offer_adjustment_id) LOOP
2161: i := i+1;
2162: l_modifier_list_rec.offer_type := 'VOLUME_OFFER';
2163: l_modifier_list_rec.qp_list_header_id := l_qp_list_lines.list_header_id;
2164:
2165: l_modifier_line_tbl(i).list_line_id := l_qp_list_lines.list_line_id;
2166: l_modifier_line_tbl(i).list_header_id := l_qp_list_lines.list_header_id;
2167: --l_modifier_line_tbl(i).end_date_active := l_qp_list_lines.effective_date;

Line 2165: l_modifier_line_tbl(i).list_line_id := l_qp_list_lines.list_line_id;

2161: i := i+1;
2162: l_modifier_list_rec.offer_type := 'VOLUME_OFFER';
2163: l_modifier_list_rec.qp_list_header_id := l_qp_list_lines.list_header_id;
2164:
2165: l_modifier_line_tbl(i).list_line_id := l_qp_list_lines.list_line_id;
2166: l_modifier_line_tbl(i).list_header_id := l_qp_list_lines.list_header_id;
2167: --l_modifier_line_tbl(i).end_date_active := l_qp_list_lines.effective_date;
2168: l_modifier_line_tbl(i).operand := l_qp_list_lines.modified_discount;
2169: l_modifier_line_tbl(i).arithmetic_operator := l_qp_list_lines.arithmetic_operator;

Line 2166: l_modifier_line_tbl(i).list_header_id := l_qp_list_lines.list_header_id;

2162: l_modifier_list_rec.offer_type := 'VOLUME_OFFER';
2163: l_modifier_list_rec.qp_list_header_id := l_qp_list_lines.list_header_id;
2164:
2165: l_modifier_line_tbl(i).list_line_id := l_qp_list_lines.list_line_id;
2166: l_modifier_line_tbl(i).list_header_id := l_qp_list_lines.list_header_id;
2167: --l_modifier_line_tbl(i).end_date_active := l_qp_list_lines.effective_date;
2168: l_modifier_line_tbl(i).operand := l_qp_list_lines.modified_discount;
2169: l_modifier_line_tbl(i).arithmetic_operator := l_qp_list_lines.arithmetic_operator;
2170:

Line 2167: --l_modifier_line_tbl(i).end_date_active := l_qp_list_lines.effective_date;

2163: l_modifier_list_rec.qp_list_header_id := l_qp_list_lines.list_header_id;
2164:
2165: l_modifier_line_tbl(i).list_line_id := l_qp_list_lines.list_line_id;
2166: l_modifier_line_tbl(i).list_header_id := l_qp_list_lines.list_header_id;
2167: --l_modifier_line_tbl(i).end_date_active := l_qp_list_lines.effective_date;
2168: l_modifier_line_tbl(i).operand := l_qp_list_lines.modified_discount;
2169: l_modifier_line_tbl(i).arithmetic_operator := l_qp_list_lines.arithmetic_operator;
2170:
2171: l_modifier_line_tbl(i).operation := 'UPDATE';

Line 2168: l_modifier_line_tbl(i).operand := l_qp_list_lines.modified_discount;

2164:
2165: l_modifier_line_tbl(i).list_line_id := l_qp_list_lines.list_line_id;
2166: l_modifier_line_tbl(i).list_header_id := l_qp_list_lines.list_header_id;
2167: --l_modifier_line_tbl(i).end_date_active := l_qp_list_lines.effective_date;
2168: l_modifier_line_tbl(i).operand := l_qp_list_lines.modified_discount;
2169: l_modifier_line_tbl(i).arithmetic_operator := l_qp_list_lines.arithmetic_operator;
2170:
2171: l_modifier_line_tbl(i).operation := 'UPDATE';
2172: ozf_utility_pvt.debug_message('List Line Id is :'||l_qp_list_lines.list_line_id || ' : '||l_qp_list_lines.list_header_id || ' : '||l_qp_list_lines.modified_discount);

Line 2169: l_modifier_line_tbl(i).arithmetic_operator := l_qp_list_lines.arithmetic_operator;

2165: l_modifier_line_tbl(i).list_line_id := l_qp_list_lines.list_line_id;
2166: l_modifier_line_tbl(i).list_header_id := l_qp_list_lines.list_header_id;
2167: --l_modifier_line_tbl(i).end_date_active := l_qp_list_lines.effective_date;
2168: l_modifier_line_tbl(i).operand := l_qp_list_lines.modified_discount;
2169: l_modifier_line_tbl(i).arithmetic_operator := l_qp_list_lines.arithmetic_operator;
2170:
2171: l_modifier_line_tbl(i).operation := 'UPDATE';
2172: ozf_utility_pvt.debug_message('List Line Id is :'||l_qp_list_lines.list_line_id || ' : '||l_qp_list_lines.list_header_id || ' : '||l_qp_list_lines.modified_discount);
2173: ozf_utility_pvt.debug_message('List Line Id is1 :'||l_modifier_line_tbl(i).list_line_id || ' : '||l_modifier_line_tbl(i).list_header_id || ' : '||l_modifier_line_tbl(i).operand);

Line 2172: ozf_utility_pvt.debug_message('List Line Id is :'||l_qp_list_lines.list_line_id || ' : '||l_qp_list_lines.list_header_id || ' : '||l_qp_list_lines.modified_discount);

2168: l_modifier_line_tbl(i).operand := l_qp_list_lines.modified_discount;
2169: l_modifier_line_tbl(i).arithmetic_operator := l_qp_list_lines.arithmetic_operator;
2170:
2171: l_modifier_line_tbl(i).operation := 'UPDATE';
2172: ozf_utility_pvt.debug_message('List Line Id is :'||l_qp_list_lines.list_line_id || ' : '||l_qp_list_lines.list_header_id || ' : '||l_qp_list_lines.modified_discount);
2173: ozf_utility_pvt.debug_message('List Line Id is1 :'||l_modifier_line_tbl(i).list_line_id || ' : '||l_modifier_line_tbl(i).list_header_id || ' : '||l_modifier_line_tbl(i).operand);
2174:
2175: END LOOP;
2176: OZF_OFFER_PVT.process_modifiers

Line 2233: CURSOR c_create_qp_list_lines(p_offer_adjustment_id NUMBER)

2229: END;
2230: /*
2231: -- create new discount tiers
2232: DECLARE
2233: CURSOR c_create_qp_list_lines(p_offer_adjustment_id NUMBER)
2234: IS
2235: SELECT d.from_rltd_modifier_id list_line_id
2236: , c.list_header_id list_header_id
2237: , f.price_break_type_code price_break_type_code

Line 2245: , ozf_offer_adjustments_b e, qp_list_lines f

2241: , f.arithmetic_operator arithmetic_operator
2242: , c.pricing_attribute pricing_attribute
2243: , e.effective_date start_date_active
2244: FROM ozf_offer_adjustment_tiers a, ozf_qp_discounts b, qp_pricing_attributes c, qp_rltd_modifiers d
2245: , ozf_offer_adjustments_b e, qp_list_lines f
2246: WHERE a.offer_discount_line_id = b.offer_discount_line_id
2247: AND b.list_line_id = c.list_line_id
2248: AND c.list_line_id = d.to_rltd_modifier_id
2249: AND a.offer_adjustment_id = e.offer_adjustment_id

Line 2254: FOR l_create_qp_list_lines IN c_create_qp_list_lines(p_offer_adjustment_id) LOOP

2250: AND b.list_line_id = f.list_line_id
2251: AND a.offer_adjustment_id = p_offer_adjustment_id;
2252: BEGIN
2253: i := 1;
2254: FOR l_create_qp_list_lines IN c_create_qp_list_lines(p_offer_adjustment_id) LOOP
2255: l_modifier_line_create_tbl(i).list_header_id := l_create_qp_list_lines.list_header_id;
2256: l_modifier_line_create_tbl(i).list_line_id := l_create_qp_list_lines.list_line_id;
2257: l_modifier_line_create_tbl(i).price_break_type_code := l_create_qp_list_lines.price_break_type_code;
2258: l_modifier_line_create_tbl(i).pricing_attr_value_from := l_create_qp_list_lines.pricing_attr_value_from;

Line 2255: l_modifier_line_create_tbl(i).list_header_id := l_create_qp_list_lines.list_header_id;

2251: AND a.offer_adjustment_id = p_offer_adjustment_id;
2252: BEGIN
2253: i := 1;
2254: FOR l_create_qp_list_lines IN c_create_qp_list_lines(p_offer_adjustment_id) LOOP
2255: l_modifier_line_create_tbl(i).list_header_id := l_create_qp_list_lines.list_header_id;
2256: l_modifier_line_create_tbl(i).list_line_id := l_create_qp_list_lines.list_line_id;
2257: l_modifier_line_create_tbl(i).price_break_type_code := l_create_qp_list_lines.price_break_type_code;
2258: l_modifier_line_create_tbl(i).pricing_attr_value_from := l_create_qp_list_lines.pricing_attr_value_from;
2259: l_modifier_line_create_tbl(i).pricing_attr_value_to := l_create_qp_list_lines.pricing_attr_value_to;

Line 2256: l_modifier_line_create_tbl(i).list_line_id := l_create_qp_list_lines.list_line_id;

2252: BEGIN
2253: i := 1;
2254: FOR l_create_qp_list_lines IN c_create_qp_list_lines(p_offer_adjustment_id) LOOP
2255: l_modifier_line_create_tbl(i).list_header_id := l_create_qp_list_lines.list_header_id;
2256: l_modifier_line_create_tbl(i).list_line_id := l_create_qp_list_lines.list_line_id;
2257: l_modifier_line_create_tbl(i).price_break_type_code := l_create_qp_list_lines.price_break_type_code;
2258: l_modifier_line_create_tbl(i).pricing_attr_value_from := l_create_qp_list_lines.pricing_attr_value_from;
2259: l_modifier_line_create_tbl(i).pricing_attr_value_to := l_create_qp_list_lines.pricing_attr_value_to;
2260: l_modifier_line_create_tbl(i).operand := l_create_qp_list_lines.operand;

Line 2257: l_modifier_line_create_tbl(i).price_break_type_code := l_create_qp_list_lines.price_break_type_code;

2253: i := 1;
2254: FOR l_create_qp_list_lines IN c_create_qp_list_lines(p_offer_adjustment_id) LOOP
2255: l_modifier_line_create_tbl(i).list_header_id := l_create_qp_list_lines.list_header_id;
2256: l_modifier_line_create_tbl(i).list_line_id := l_create_qp_list_lines.list_line_id;
2257: l_modifier_line_create_tbl(i).price_break_type_code := l_create_qp_list_lines.price_break_type_code;
2258: l_modifier_line_create_tbl(i).pricing_attr_value_from := l_create_qp_list_lines.pricing_attr_value_from;
2259: l_modifier_line_create_tbl(i).pricing_attr_value_to := l_create_qp_list_lines.pricing_attr_value_to;
2260: l_modifier_line_create_tbl(i).operand := l_create_qp_list_lines.operand;
2261: l_modifier_line_create_tbl(i).arithmetic_operator := l_create_qp_list_lines.arithmetic_operator;

Line 2258: l_modifier_line_create_tbl(i).pricing_attr_value_from := l_create_qp_list_lines.pricing_attr_value_from;

2254: FOR l_create_qp_list_lines IN c_create_qp_list_lines(p_offer_adjustment_id) LOOP
2255: l_modifier_line_create_tbl(i).list_header_id := l_create_qp_list_lines.list_header_id;
2256: l_modifier_line_create_tbl(i).list_line_id := l_create_qp_list_lines.list_line_id;
2257: l_modifier_line_create_tbl(i).price_break_type_code := l_create_qp_list_lines.price_break_type_code;
2258: l_modifier_line_create_tbl(i).pricing_attr_value_from := l_create_qp_list_lines.pricing_attr_value_from;
2259: l_modifier_line_create_tbl(i).pricing_attr_value_to := l_create_qp_list_lines.pricing_attr_value_to;
2260: l_modifier_line_create_tbl(i).operand := l_create_qp_list_lines.operand;
2261: l_modifier_line_create_tbl(i).arithmetic_operator := l_create_qp_list_lines.arithmetic_operator;
2262: l_modifier_line_create_tbl(i).pricing_attribute_id := FND_API.G_MISS_NUM;

Line 2259: l_modifier_line_create_tbl(i).pricing_attr_value_to := l_create_qp_list_lines.pricing_attr_value_to;

2255: l_modifier_line_create_tbl(i).list_header_id := l_create_qp_list_lines.list_header_id;
2256: l_modifier_line_create_tbl(i).list_line_id := l_create_qp_list_lines.list_line_id;
2257: l_modifier_line_create_tbl(i).price_break_type_code := l_create_qp_list_lines.price_break_type_code;
2258: l_modifier_line_create_tbl(i).pricing_attr_value_from := l_create_qp_list_lines.pricing_attr_value_from;
2259: l_modifier_line_create_tbl(i).pricing_attr_value_to := l_create_qp_list_lines.pricing_attr_value_to;
2260: l_modifier_line_create_tbl(i).operand := l_create_qp_list_lines.operand;
2261: l_modifier_line_create_tbl(i).arithmetic_operator := l_create_qp_list_lines.arithmetic_operator;
2262: l_modifier_line_create_tbl(i).pricing_attribute_id := FND_API.G_MISS_NUM;
2263: l_modifier_line_create_tbl(i).pricing_attr := l_create_qp_list_lines.pricing_attribute;

Line 2260: l_modifier_line_create_tbl(i).operand := l_create_qp_list_lines.operand;

2256: l_modifier_line_create_tbl(i).list_line_id := l_create_qp_list_lines.list_line_id;
2257: l_modifier_line_create_tbl(i).price_break_type_code := l_create_qp_list_lines.price_break_type_code;
2258: l_modifier_line_create_tbl(i).pricing_attr_value_from := l_create_qp_list_lines.pricing_attr_value_from;
2259: l_modifier_line_create_tbl(i).pricing_attr_value_to := l_create_qp_list_lines.pricing_attr_value_to;
2260: l_modifier_line_create_tbl(i).operand := l_create_qp_list_lines.operand;
2261: l_modifier_line_create_tbl(i).arithmetic_operator := l_create_qp_list_lines.arithmetic_operator;
2262: l_modifier_line_create_tbl(i).pricing_attribute_id := FND_API.G_MISS_NUM;
2263: l_modifier_line_create_tbl(i).pricing_attr := l_create_qp_list_lines.pricing_attribute;
2264: l_modifier_line_create_tbl(i).start_date_active := l_create_qp_list_lines.start_date_active;

Line 2261: l_modifier_line_create_tbl(i).arithmetic_operator := l_create_qp_list_lines.arithmetic_operator;

2257: l_modifier_line_create_tbl(i).price_break_type_code := l_create_qp_list_lines.price_break_type_code;
2258: l_modifier_line_create_tbl(i).pricing_attr_value_from := l_create_qp_list_lines.pricing_attr_value_from;
2259: l_modifier_line_create_tbl(i).pricing_attr_value_to := l_create_qp_list_lines.pricing_attr_value_to;
2260: l_modifier_line_create_tbl(i).operand := l_create_qp_list_lines.operand;
2261: l_modifier_line_create_tbl(i).arithmetic_operator := l_create_qp_list_lines.arithmetic_operator;
2262: l_modifier_line_create_tbl(i).pricing_attribute_id := FND_API.G_MISS_NUM;
2263: l_modifier_line_create_tbl(i).pricing_attr := l_create_qp_list_lines.pricing_attribute;
2264: l_modifier_line_create_tbl(i).start_date_active := l_create_qp_list_lines.start_date_active;
2265: l_modifier_line_create_tbl(i).operation := 'CREATE';

Line 2263: l_modifier_line_create_tbl(i).pricing_attr := l_create_qp_list_lines.pricing_attribute;

2259: l_modifier_line_create_tbl(i).pricing_attr_value_to := l_create_qp_list_lines.pricing_attr_value_to;
2260: l_modifier_line_create_tbl(i).operand := l_create_qp_list_lines.operand;
2261: l_modifier_line_create_tbl(i).arithmetic_operator := l_create_qp_list_lines.arithmetic_operator;
2262: l_modifier_line_create_tbl(i).pricing_attribute_id := FND_API.G_MISS_NUM;
2263: l_modifier_line_create_tbl(i).pricing_attr := l_create_qp_list_lines.pricing_attribute;
2264: l_modifier_line_create_tbl(i).start_date_active := l_create_qp_list_lines.start_date_active;
2265: l_modifier_line_create_tbl(i).operation := 'CREATE';
2266: i := i + 1;
2267: END LOOP;

Line 2264: l_modifier_line_create_tbl(i).start_date_active := l_create_qp_list_lines.start_date_active;

2260: l_modifier_line_create_tbl(i).operand := l_create_qp_list_lines.operand;
2261: l_modifier_line_create_tbl(i).arithmetic_operator := l_create_qp_list_lines.arithmetic_operator;
2262: l_modifier_line_create_tbl(i).pricing_attribute_id := FND_API.G_MISS_NUM;
2263: l_modifier_line_create_tbl(i).pricing_attr := l_create_qp_list_lines.pricing_attribute;
2264: l_modifier_line_create_tbl(i).start_date_active := l_create_qp_list_lines.start_date_active;
2265: l_modifier_line_create_tbl(i).operation := 'CREATE';
2266: i := i + 1;
2267: END LOOP;
2268: dbms_output.put_line('Size is '||l_modifier_line_create_tbl.count);

Line 2295: FROM ozf_offer_adjustment_tiers a, ozf_offer_adjustments_b b , ozf_offer_discount_lines c , qp_list_lines d , qp_pricing_attributes e , ozf_offer_discount_products f

2291: DECLARE
2292: CURSOR c_create_reln(p_offer_adjustment_id NUMBER)
2293: IS
2294: SELECT a.offer_discount_line_id , f.off_discount_product_id , e.pricing_attribute_id , d.list_line_id
2295: FROM ozf_offer_adjustment_tiers a, ozf_offer_adjustments_b b , ozf_offer_discount_lines c , qp_list_lines d , qp_pricing_attributes e , ozf_offer_discount_products f
2296: WHERE a.offer_adjustment_id = b.offer_adjustment_id
2297: AND c.offer_discount_line_id = a.offer_discount_line_id
2298: AND b.list_header_id = d.list_header_id
2299: AND d.list_line_id = e.list_line_id