APPS.CSD_RULES_ENGINE_PVT dependencies on MTL_ITEM_CATEGORIES_V

Line 1391: FROM mtl_item_categories_v

1387: CURSOR cur_is_item_in_cat (p_inventory_item_id NUMBER,
1388: p_category_id NUMBER)
1389: IS
1390: SELECT 'X'
1391: FROM mtl_item_categories_v
1392: WHERE inventory_item_id = p_inventory_item_id
1393: and category_id = p_category_id
1394: and organization_id = cs_std.get_item_valdn_orgzn_id;
1395:

Line 2006: || ' from mtl_item_categories_v cat'

2002: end if;
2003:
2004: if (l_join_stmt is not null) then
2005: l_join_stmt := l_join_stmt || ' (select ''X'''
2006: || ' from mtl_item_categories_v cat'
2007: || ' where cat.inventory_item_id = dra.inventory_item_id'
2008: || ' and cat.organization_id = cs_std.get_item_valdn_orgzn_id'
2009: || ' and cat.category_id = '
2010: || l_rule_condition_rec.attribute2 || ')';