DBA Data[Home] [Help]

APPS.OE_HOLDS_PUB dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 3931: mtl_default_category_sets mdc

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
3935: AND mdc.functional_area_id=7

Line 4828: mtl_default_category_sets mdc

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
4832: AND mdc.category_set_id = mic.category_set_id;