DBA Data[Home] [Help]

APPS.CSD_RULES_ENGINE_PVT dependencies on CS_STD

Line 1394: and organization_id = cs_std.get_item_valdn_orgzn_id;

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:
1396: -- variables --
1397: l_item_is_in_cat VARCHAR2(1);
1398: l_return_val VARCHAR2(1) := FND_API.G_FALSE;

Line 2008: || ' and cat.organization_id = cs_std.get_item_valdn_orgzn_id'

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 || ')';
2011: end if;
2012: