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.

[Home] [Help]

APPS.OZF_VOLUME_OFFER_ADJ dependencies on OZF_OFFER_ADJUSTMENT_PRODUCTS

Line 1237: FROM ozf_offer_adjustment_products a, ozf_offer_discount_lines b

1233: , a.include_volume_flag
1234: , b.offer_id
1235: , a.offer_adjustment_product_id
1236: , a.object_version_number
1237: FROM ozf_offer_adjustment_products a, ozf_offer_discount_lines b
1238: WHERE
1239: a.offer_discount_line_id = b.offer_discount_line_id
1240: AND offer_adjustment_id = cp_offerAdjustmentId;
1241:

Line 1275: UPDATE ozf_offer_adjustment_products

1271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1272: END IF;
1273: --dbms_output.put_line('Created Product successfully:'||l_objId);
1274: --dbms_output.put_line('Updating :'||l_products.offer_adjustment_product_id);
1275: UPDATE ozf_offer_adjustment_products
1276: SET off_discount_product_id = l_objId , object_version_number = object_version_number + 1
1277: WHERE offer_adjustment_product_id = l_products.offer_adjustment_product_id;
1278: --AND object_version_number = l_products.object_version_number;
1279:

Line 1294: -- update ozf_offer_adjustment_products with the off_discount_product_id of the newly created product

1290:
1291: -- initialize
1292: -- query new products added in the adjustment
1293: -- insert the new products into ozf_offer_discount_products
1294: -- update ozf_offer_adjustment_products with the off_discount_product_id of the newly created product
1295: END create_new_products;
1296:
1297:
1298: PROCEDURE populate_advanced_options

Line 1995: FROM ozf_offer_adjustment_products a

1991: IS
1992: CURSOR c_products(cp_offerAdjustmentId NUMBER) IS
1993: SELECT a.off_discount_product_id
1994: , a.offer_discount_line_id
1995: FROM ozf_offer_adjustment_products a
1996: WHERE offer_adjustment_id = cp_offerAdjustmentId
1997: AND product_attr_value IS NOT NULL
1998: AND excluder_flag = 'N';
1999:

Line 2003: FROM ozf_offer_adjustment_products a

1999:
2000: CURSOR c_exclusions(cp_offerAdjustmentId NUMBER) IS
2001: SELECT a.off_discount_product_id
2002: , a.offer_discount_line_id
2003: FROM ozf_offer_adjustment_products a
2004: WHERE offer_adjustment_id = cp_offerAdjustmentId
2005: AND product_attr_value IS NOT NULL
2006: AND excluder_flag = 'Y';
2007: