DBA Data[Home] [Help]

APPS.CSD_RULES_ENGINE_PVT dependencies on CS_STD

Line 1966: and organization_id = cs_std.get_item_valdn_orgzn_id;

1962: SELECT 'X'
1963: FROM mtl_item_categories_v
1964: WHERE inventory_item_id = p_inventory_item_id
1965: and category_id = p_category_id
1966: and organization_id = cs_std.get_item_valdn_orgzn_id;
1967:
1968: -- variables --
1969: l_item_is_in_cat VARCHAR2(1);
1970: l_return_val VARCHAR2(1) := FND_API.G_FALSE;

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

2576: if (l_join_stmt is not null) then
2577: l_join_stmt := l_join_stmt || ' (select ''X'''
2578: || ' from mtl_item_categories_v cat'
2579: || ' where cat.inventory_item_id = dra.inventory_item_id'
2580: || ' and cat.organization_id = cs_std.get_item_valdn_orgzn_id'
2581: || ' and cat.category_id = '
2582: || l_rule_condition_rec.attribute2 || ')';
2583: end if;
2584: