eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_RULES_ENGINE_PVT dependencies on MTL_ITEM_CATEGORIES

Line 30: FROM mtl_item_categories mic,wip_entities we

26: BEGIN
27: BEGIN
28: SELECT fnd_api.g_true
29: INTO l_return_val
30: FROM mtl_item_categories mic,wip_entities we
31: WHERE mic.inventory_item_id = p_mtl_txn_item_id
32: AND mic.category_id = p_criterion
33: AND mic.organization_id = we.organization_id
34: AND we.wip_entity_id = p_wip_entity_id;

Line 1963: FROM mtl_item_categories_v

1959: CURSOR cur_is_item_in_cat (p_inventory_item_id NUMBER,
1960: p_category_id NUMBER)
1961: IS
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:

Line 2578: || ' from mtl_item_categories_v cat'

2574: end if;
2575:
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 || ')';