DBA Data[Home] [Help]

APPS.OE_CONTRACTS_UTIL dependencies on MTL_ITEM_CATEGORIES_V

Line 2371: FROM mtl_item_categories_v

2367: -- returns non-translatable code eg. HOSPITAL.MISC
2368: CURSOR c_get_derived_item_category (cp_org_id NUMBER,
2369: cp_inventory_item_id NUMBER) IS
2370: SELECT category_concat_segs
2371: FROM mtl_item_categories_v
2372: WHERE inventory_item_id = cp_inventory_item_id
2373: AND organization_id = cp_org_id -- should be inventory master org
2374: AND structure_id = 101; -- hardcoded to 101 i.e. Item Categories (Inv. Items) for Order Management
2375: