APPS.OZF_FUND_ADJUSTMENT_PVT dependencies on AMS_ACT_PRODUCTS

Line 1368: FROM ams_act_products

1364: l_lumpsum_offer cur_get_lumpsum_details%ROWTYPE;
1365:
1366: CURSOR cur_get_lumpsum_line_details IS
1367: SELECT SUM (line_lumpsum_qty)
1368: FROM ams_act_products
1369: WHERE arc_act_product_used_by = 'OFFR'
1370: AND act_product_used_by_id = p_qp_list_header_id;
1371:
1372: l_total_distribution NUMBER;

Line 1841: FROM ams_act_products

1837: --get product information.
1838: CURSOR c_off_products (p_offer_id IN NUMBER) IS
1839: SELECT activity_product_id,DECODE (level_type_code, 'PRODUCT', inventory_item_id, category_id) product_id
1840: ,level_type_code,scan_value,scan_unit_forecast,quantity
1841: FROM ams_act_products
1842: WHERE act_product_used_by_id = p_offer_id
1843: AND arc_act_product_used_by = 'OFFR';
1844:
1845: --kdass 08-Jun-2005 Bug 4415878 SQL Repository Fix - changed the cursor query

Line 2268: FROM ams_act_products

2264: --get product information.
2265: CURSOR c_off_products (p_offer_id IN NUMBER) IS
2266: SELECT DECODE (level_type_code, 'PRODUCT', inventory_item_id, category_id) product_id
2267: ,SUM(line_lumpsum_qty) amount, level_type_code
2268: FROM ams_act_products
2269: WHERE act_product_used_by_id = p_offer_id
2270: AND arc_act_product_used_by = 'OFFR'
2271: GROUP BY inventory_item_id,level_type_code,category_id; -- added by feliu to fix bug 4861647
2272:

Line 2276: FROM ams_act_products

2272:
2273: --get sum of lumpsum line amount.
2274: CURSOR c_off_pdts_total_qty (p_offer_id IN NUMBER) IS
2275: SELECT SUM (line_lumpsum_qty) total_quantity
2276: FROM ams_act_products
2277: WHERE act_product_used_by_id = p_offer_id
2278: AND arc_act_product_used_by = 'OFFR';
2279:
2280: --kdass 08-Jun-2005 Bug 4415878 SQL Repository Fix - changed the cursor query

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

2379: l_count NUMBER;
2380: l_limit_row NUMBER := 100;
2381: l_amount_remaining NUMBER;
2382:
2383: TYPE itemIdTbl IS TABLE OF ams_act_products.inventory_item_id%TYPE;
2384: TYPE lumsumAmtTbl IS TABLE OF ams_act_products.line_lumpsum_qty%TYPE;
2385: TYPE levelTypeTbl IS TABLE OF ams_act_products.level_type_code%TYPE;
2386:
2387: l_itemId_tbl itemIdTbl;

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

2380: l_limit_row NUMBER := 100;
2381: l_amount_remaining NUMBER;
2382:
2383: TYPE itemIdTbl IS TABLE OF ams_act_products.inventory_item_id%TYPE;
2384: TYPE lumsumAmtTbl IS TABLE OF ams_act_products.line_lumpsum_qty%TYPE;
2385: TYPE levelTypeTbl IS TABLE OF ams_act_products.level_type_code%TYPE;
2386:
2387: l_itemId_tbl itemIdTbl;
2388: l_lumsumAmt_tbl lumsumAmtTbl;

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

2381: l_amount_remaining NUMBER;
2382:
2383: TYPE itemIdTbl IS TABLE OF ams_act_products.inventory_item_id%TYPE;
2384: TYPE lumsumAmtTbl IS TABLE OF ams_act_products.line_lumpsum_qty%TYPE;
2385: TYPE levelTypeTbl IS TABLE OF ams_act_products.level_type_code%TYPE;
2386:
2387: l_itemId_tbl itemIdTbl;
2388: l_lumsumAmt_tbl lumsumAmtTbl;
2389: l_levelType_tbl levelTypeTbl;

Line 2890: FROM ams_act_products

2886: --get product information.
2887: CURSOR c_off_products (p_product_activity_id IN NUMBER) IS
2888: SELECT DECODE (level_type_code, 'PRODUCT', inventory_item_id, category_id) product_id
2889: ,level_type_code,scan_value, quantity
2890: FROM ams_act_products
2891: WHERE activity_product_Id = p_product_activity_id;
2892:
2893: --get offer currency and source_from_parent
2894: CURSOR c_offer_data(p_qp_list_header_id IN NUMBER) IS