DBA Data[Home] [Help]

APPS.OE_CONTRACTS_UTIL dependencies on MTL_ITEM_CATEGORIES_V

Line 2380: FROM mtl_item_categories_v

2376: -- returns non-translatable code eg. HOSPITAL.MISC
2377: CURSOR c_get_derived_item_category (cp_org_id NUMBER,
2378: cp_inventory_item_id NUMBER) IS
2379: SELECT category_concat_segs
2380: FROM mtl_item_categories_v
2381: WHERE inventory_item_id = cp_inventory_item_id
2382: AND organization_id = cp_org_id -- should be inventory master org
2383: AND structure_id = 101; -- hardcoded to 101 i.e. Item Categories (Inv. Items) for Order Management
2384: