APPS.OZF_OFFER_PVT dependencies on AMS_ACT_PRODUCTS

Line 3204: FROM ams_act_products

3200: AND object_attribute = 'BREQ';
3201:
3202: CURSOR c_committed_amount IS
3203: SELECT NVL(SUM(scan_value * scan_unit_forecast/quantity), 0)
3204: FROM ams_act_products
3205: WHERE arc_act_product_used_by = 'OFFR'
3206: AND act_product_used_by_id = p_offer_rec.qp_list_header_id;
3207:
3208: l_attr_avail_flag VARCHAR2(1);

Line 3330: FROM ams_act_products

3326: AND act_budget_used_by_id = p_qp_list_header_id;
3327:
3328: CURSOR c_committed_amount IS
3329: SELECT NVL(SUM(scan_value * scan_unit_forecast/quantity), 0)
3330: FROM ams_act_products
3331: WHERE arc_act_product_used_by = 'OFFR'
3332: AND act_product_used_by_id = p_qp_list_header_id;
3333:
3334: l_api_name CONSTANT VARCHAR2(30) := 'validate_scandata_budget';

Line 4648: FROM ams_act_products

4644: )
4645: IS
4646: CURSOR c_scan_value IS
4647: SELECT NVL(SUM(scan_value * scan_unit_forecast/quantity),0)
4648: FROM ams_act_products
4649: WHERE arc_act_product_used_by = 'OFFR'
4650: AND act_product_used_by_id = p_modifier_list_rec.qp_list_header_id;
4651:
4652: CURSOR c_old_status IS

Line 6868: FROM ams_act_products

6864: l_lumpsum_offer cur_get_lumpsum_details%rowtype;
6865:
6866: CURSOR cur_get_lumpsum_line_details IS
6867: SELECT nvl(sum(line_lumpsum_qty),0)
6868: FROM ams_act_products
6869: WHERE ARC_ACT_PRODUCT_USED_BY = 'OFFR'
6870: AND ACT_PRODUCT_USED_BY_ID = p_qp_list_header_id;
6871:
6872: l_total_distribution NUMBER;

Line 8728: FROM ams_act_products

8724: AND custom_setup_id = p_modifier_list_rec.custom_setup_id;
8725:
8726: CURSOR c_prod_line IS
8727: SELECT COUNT(*)
8728: FROM ams_act_products
8729: WHERE arc_act_product_used_by = 'OFFR'
8730: AND act_product_used_by_id = p_modifier_list_rec.qp_list_header_id;
8731:
8732: CURSOR c_list_line IS