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 1182: FROM ozf_offer_adjustment_products a, ozf_offer_discount_lines b

1178: , a.include_volume_flag
1179: , b.offer_id
1180: , a.offer_adjustment_product_id
1181: , a.object_version_number
1182: FROM ozf_offer_adjustment_products a, ozf_offer_discount_lines b
1183: WHERE
1184: a.offer_discount_line_id = b.offer_discount_line_id
1185: AND offer_adjustment_id = cp_offerAdjustmentId;
1186:

Line 1220: UPDATE ozf_offer_adjustment_products

1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1217: END IF;
1218: --dbms_output.put_line('Created Product successfully:'||l_objId);
1219: --dbms_output.put_line('Updating :'||l_products.offer_adjustment_product_id);
1220: UPDATE ozf_offer_adjustment_products
1221: SET off_discount_product_id = l_objId , object_version_number = object_version_number + 1
1222: WHERE offer_adjustment_product_id = l_products.offer_adjustment_product_id;
1223: --AND object_version_number = l_products.object_version_number;
1224:

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

1235:
1236: -- initialize
1237: -- query new products added in the adjustment
1238: -- insert the new products into ozf_offer_discount_products
1239: -- update ozf_offer_adjustment_products with the off_discount_product_id of the newly created product
1240: END create_new_products;
1241:
1242:
1243: PROCEDURE populate_advanced_options

Line 1936: FROM ozf_offer_adjustment_products a

1932: IS
1933: CURSOR c_products(cp_offerAdjustmentId NUMBER) IS
1934: SELECT a.off_discount_product_id
1935: , a.offer_discount_line_id
1936: FROM ozf_offer_adjustment_products a
1937: WHERE offer_adjustment_id = cp_offerAdjustmentId
1938: AND product_attr_value IS NOT NULL
1939: AND excluder_flag = 'N';
1940:

Line 1944: FROM ozf_offer_adjustment_products a

1940:
1941: CURSOR c_exclusions(cp_offerAdjustmentId NUMBER) IS
1942: SELECT a.off_discount_product_id
1943: , a.offer_discount_line_id
1944: FROM ozf_offer_adjustment_products a
1945: WHERE offer_adjustment_id = cp_offerAdjustmentId
1946: AND product_attr_value IS NOT NULL
1947: AND excluder_flag = 'Y';
1948: