DBA Data[Home] [Help]

APPS.OE_ITORD_UTIL dependencies on MTL_ITEM_CATEGORIES

Line 18: from mtl_item_categories ic,

14:
15: IF NOT OE_GLOBALS.Equal( p_inventory_item_id , G_INVENTORY_ITEM_ID ) then
16: select category_id
17: into l_item_category_id
18: from mtl_item_categories ic,
19: MTL_DEFAULT_CATEGORY_SETS CS
20: where ic.category_set_id=cs.category_set_id
21: AND CS.functional_area_id = 7
22: AND ic.organization_id=oe_sys_parameters.Value('MASTER_ORGANIZATION_ID')