APPS.OE_HOLDS_PUB dependencies on MTL_ITEM_CATEGORIES

Line 408: mtl_item_categories ic

404: BEGIN
405: SELECT 'Valid Entity'
406: INTO l_dummy
407: FROM OE_ORDER_LINES l,
408: mtl_item_categories ic
409: WHERE l.LINE_ID = p_line_id
410: AND ic.category_id = p_hold_entity_id
411: AND l.INVENTORY_ITEM_ID = ic.inventory_item_id
412: AND ic.organization_id = oe_sys_parameters.Value('MASTER_ORGANIZATION_ID') --13653352

Line 3930: from mtl_item_categories mic,

3926: --ER# 13331078 start
3927: ELSIF l_hold_entity_code = 'IC' THEN
3928: BEGIN
3929: select 'Y' into l_valid_itemcat
3930: from mtl_item_categories mic,
3931: mtl_default_category_sets mdc
3932: where mic.inventory_item_id = l_line_rec.inventory_item_id
3933: and mic.organization_id = oe_sys_parameters.Value('MASTER_ORGANIZATION_ID') --13653352
3934: and mic.category_id = l_hold_entity_id

Line 4827: from mtl_item_categories mic,

4823: -- Added Exception Handling through 13895629
4824: BEGIN
4825: select mic.category_id
4826: into l_entity_tab(m_counter).entity_id
4827: from mtl_item_categories mic,
4828: mtl_default_category_sets mdc
4829: where mic.inventory_item_id = l_line_rec.inventory_item_id
4830: AND mic.organization_id = oe_sys_parameters.Value('MASTER_ORGANIZATION_ID') --13653352
4831: AND mdc.functional_area_id=7