APPS.OZF_OFFER_PVT dependencies on AMS_ACT_PRODUCTS

Line 3369: FROM ams_act_products

3365: AND object_attribute = 'BREQ';
3366:
3367: CURSOR c_committed_amount IS
3368: SELECT NVL(SUM(scan_value * scan_unit_forecast/quantity), 0)
3369: FROM ams_act_products
3370: WHERE arc_act_product_used_by = 'OFFR'
3371: AND act_product_used_by_id = p_offer_rec.qp_list_header_id;
3372:
3373: l_attr_avail_flag VARCHAR2(1);

Line 3495: FROM ams_act_products

3491: AND act_budget_used_by_id = p_qp_list_header_id;
3492:
3493: CURSOR c_committed_amount IS
3494: SELECT NVL(SUM(scan_value * scan_unit_forecast/quantity), 0)
3495: FROM ams_act_products
3496: WHERE arc_act_product_used_by = 'OFFR'
3497: AND act_product_used_by_id = p_qp_list_header_id;
3498:
3499: l_api_name CONSTANT VARCHAR2(30) := 'validate_scandata_budget';

Line 5026: FROM ams_act_products

5022: )
5023: IS
5024: CURSOR c_scan_value IS
5025: SELECT NVL(SUM(scan_value * scan_unit_forecast/quantity),0)
5026: FROM ams_act_products
5027: WHERE arc_act_product_used_by = 'OFFR'
5028: AND act_product_used_by_id = p_modifier_list_rec.qp_list_header_id;
5029:
5030: CURSOR c_old_status IS

Line 7402: FROM ams_act_products

7398: l_lumpsum_offer cur_get_lumpsum_details%rowtype;
7399:
7400: CURSOR cur_get_lumpsum_line_details IS
7401: SELECT nvl(sum(line_lumpsum_qty),0)
7402: FROM ams_act_products
7403: WHERE ARC_ACT_PRODUCT_USED_BY = 'OFFR'
7404: AND ACT_PRODUCT_USED_BY_ID = p_qp_list_header_id;
7405:
7406: l_total_distribution NUMBER;

Line 9267: FROM ams_act_products

9263: AND custom_setup_id = p_modifier_list_rec.custom_setup_id;
9264:
9265: CURSOR c_prod_line IS
9266: SELECT COUNT(*)
9267: FROM ams_act_products
9268: WHERE arc_act_product_used_by = 'OFFR'
9269: AND act_product_used_by_id = p_modifier_list_rec.qp_list_header_id;
9270:
9271: CURSOR c_list_line IS