DBA Data[Home] [Help]

APPS.AMS_ACTPRODUCT_PVT dependencies on MTL_ITEM_CATEGORIES

Line 1719: from MTL_ITEM_CATEGORIES

1715: CURSOR c_check_item(l_cat_id IN NUMBER) IS
1716: select 1
1717: from dual
1718: where exists ( select 1
1719: from MTL_ITEM_CATEGORIES
1720: where INVENTORY_ITEM_ID = p_act_Product_rec.INVENTORY_ITEM_ID
1721: and CATEGORY_ID = l_cat_id);
1722:
1723: -- julou cursors to check duplication of items and categories for scan data

Line 1796: FROM mtl_item_categories

1792: CURSOR c_check_item_in_cat(l_cat_id NUMBER, l_item_id NUMBER) IS
1793: SELECT 1
1794: FROM DUAL
1795: WHERE EXISTS(SELECT 1
1796: FROM mtl_item_categories
1797: WHERE category_id = l_cat_id
1798: AND inventory_item_id = l_item_id);
1799: l_count1 NUMBER := 0; -- count for same item or cat
1800: l_count2 NUMBER := 0; -- count for item in category

Line 2572: ,mtl_item_categories ml

2568: CURSOR check_prod_cat_exist
2569: IS
2570: SELECT 1
2571: from ams_act_products a
2572: ,mtl_item_categories ml
2573: where arc_act_product_used_by = 'CAMP'
2574: and act_product_used_by_id = l_campaign_id
2575: and level_type_code = 'FAMILY'
2576: and a.category_id = p_act_product_rec.category_id

Line 2612: from mtl_item_categories

2608:
2609: CURSOR c_item_cat_check
2610: IS
2611: SELECT 1
2612: from mtl_item_categories
2613: where inventory_item_id = p_act_product_rec.inventory_item_id
2614: and category_id = p_act_product_rec.category_id
2615: and category_set_id = p_act_product_rec.category_set_id;
2616: