APPS.OZF_FUND_ADJUSTMENT_PVT dependencies on AMS_ACT_PRODUCTS

Line 1585: FROM ams_act_products

1581: l_lumpsum_offer cur_get_lumpsum_details%ROWTYPE;
1582:
1583: CURSOR cur_get_lumpsum_line_details IS
1584: SELECT SUM (line_lumpsum_qty)
1585: FROM ams_act_products
1586: WHERE arc_act_product_used_by = 'OFFR'
1587: AND act_product_used_by_id = p_qp_list_header_id;
1588:
1589: l_total_distribution NUMBER;

Line 2363: FROM ams_act_products

2359: --get product information.
2360: CURSOR c_off_products (p_offer_id IN NUMBER) IS
2361: SELECT activity_product_id,DECODE (level_type_code, 'PRODUCT', inventory_item_id, category_id) product_id
2362: ,level_type_code,scan_value,scan_unit_forecast,quantity
2363: FROM ams_act_products
2364: WHERE act_product_used_by_id = p_offer_id
2365: AND arc_act_product_used_by = 'OFFR';
2366:
2367: --kdass 08-Jun-2005 Bug 4415878 SQL Repository Fix - changed the cursor query

Line 2796: FROM ams_act_products

2792: --get product information.
2793: CURSOR c_off_products (p_offer_id IN NUMBER) IS
2794: SELECT DECODE (level_type_code, 'PRODUCT', inventory_item_id, category_id) product_id
2795: ,SUM(line_lumpsum_qty) amount, level_type_code
2796: FROM ams_act_products
2797: WHERE act_product_used_by_id = p_offer_id
2798: AND arc_act_product_used_by = 'OFFR'
2799: GROUP BY inventory_item_id,level_type_code,category_id; -- added by feliu to fix bug 4861647
2800:

Line 2804: FROM ams_act_products

2800:
2801: --get sum of lumpsum line amount.
2802: CURSOR c_off_pdts_total_qty (p_offer_id IN NUMBER) IS
2803: SELECT SUM (line_lumpsum_qty) total_quantity
2804: FROM ams_act_products
2805: WHERE act_product_used_by_id = p_offer_id
2806: AND arc_act_product_used_by = 'OFFR';
2807:
2808: --kdass 08-Jun-2005 Bug 4415878 SQL Repository Fix - changed the cursor query

Line 2911: TYPE itemIdTbl IS TABLE OF ams_act_products.inventory_item_id%TYPE;

2907: l_count NUMBER;
2908: l_limit_row NUMBER := 100;
2909: l_amount_remaining NUMBER;
2910:
2911: TYPE itemIdTbl IS TABLE OF ams_act_products.inventory_item_id%TYPE;
2912: TYPE lumsumAmtTbl IS TABLE OF ams_act_products.line_lumpsum_qty%TYPE;
2913: TYPE levelTypeTbl IS TABLE OF ams_act_products.level_type_code%TYPE;
2914:
2915: l_itemId_tbl itemIdTbl;

Line 2912: TYPE lumsumAmtTbl IS TABLE OF ams_act_products.line_lumpsum_qty%TYPE;

2908: l_limit_row NUMBER := 100;
2909: l_amount_remaining NUMBER;
2910:
2911: TYPE itemIdTbl IS TABLE OF ams_act_products.inventory_item_id%TYPE;
2912: TYPE lumsumAmtTbl IS TABLE OF ams_act_products.line_lumpsum_qty%TYPE;
2913: TYPE levelTypeTbl IS TABLE OF ams_act_products.level_type_code%TYPE;
2914:
2915: l_itemId_tbl itemIdTbl;
2916: l_lumsumAmt_tbl lumsumAmtTbl;

Line 2913: TYPE levelTypeTbl IS TABLE OF ams_act_products.level_type_code%TYPE;

2909: l_amount_remaining NUMBER;
2910:
2911: TYPE itemIdTbl IS TABLE OF ams_act_products.inventory_item_id%TYPE;
2912: TYPE lumsumAmtTbl IS TABLE OF ams_act_products.line_lumpsum_qty%TYPE;
2913: TYPE levelTypeTbl IS TABLE OF ams_act_products.level_type_code%TYPE;
2914:
2915: l_itemId_tbl itemIdTbl;
2916: l_lumsumAmt_tbl lumsumAmtTbl;
2917: l_levelType_tbl levelTypeTbl;

Line 3269: FROM ozf_funds_utilized_all_b util, ams_act_products line,

3265: util.cust_account_id CustomerId,
3266: util.plan_curr_amount AccrualAmount,
3267: ''0'' ShippedQuantity,
3268: util.plan_curr_amount Revenue
3269: FROM ozf_funds_utilized_all_b util, ams_act_products line,
3270: ozf_xref_map map
3271: WHERE util.product_id = line.inventory_item_id
3272: AND util.plan_type = ''OFFR''
3273: AND util.plan_id = line.act_product_used_by_id

Line 3565: FROM ams_act_products

3561: --get product information.
3562: CURSOR c_off_products (p_product_activity_id IN NUMBER) IS
3563: SELECT DECODE (level_type_code, 'PRODUCT', inventory_item_id, category_id) product_id
3564: ,level_type_code,scan_value, quantity
3565: FROM ams_act_products
3566: WHERE activity_product_Id = p_product_activity_id;
3567:
3568: --get offer currency and source_from_parent
3569: CURSOR c_offer_data(p_qp_list_header_id IN NUMBER) IS