APPS.EGO_ITEM_PUB dependencies on MTL_ITEM_CATEGORIES

Line 2071: DELETE MTL_ITEM_CATEGORIES

2067: -- assignments for unapproved items will be supported, so only
2068: -- functional category assignments will be deleted
2069: --Bug: 3808294 If its unapproved item delete default item-cat assignments
2070: IF p_approval_status <> 'A' THEN
2071: DELETE MTL_ITEM_CATEGORIES
2072: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
2073: AND ORGANIZATION_ID = p_organization_id
2074: AND CATEGORY_SET_ID IN (SELECT CATEGORY_SET_ID
2075: FROM MTL_DEFAULT_CATEGORY_SETS);

Line 3708: from mtl_item_categories a

3704: l_total_count NUMBER := 0;
3705: BEGIN
3706: IF (P_CATEGORY_ID <> -1) THEN
3707: select count(*) into l_total_count
3708: from mtl_item_categories a
3709: where category_id in (
3710: select category_id
3711: from mtl_category_set_valid_cats
3712: start with category_id = P_CATEGORY_ID

Line 3720: from mtl_item_categories a

3716: and a.organization_id = P_ORGANIZATION_ID
3717: and a.category_set_id = P_CATEGORY_SET_ID;
3718: ELSE
3719: select count(*) into l_total_count
3720: from mtl_item_categories a
3721: where a.organization_id = P_ORGANIZATION_ID
3722: and a.category_set_id = P_CATEGORY_SET_ID;
3723: END IF;
3724: