DBA Data[Home] [Help]

APPS.OE_BULK_HOLDS_PVT dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 1731: mtl_default_category_sets mdc

1727: BEGIN
1728: select mic.category_id
1729: into l_itemcategory_id
1730: from mtl_item_categories mic,
1731: mtl_default_category_sets mdc
1732: where mic.inventory_item_id = p_line_rec.inventory_item_id
1733: and mic.organization_id = oe_sys_parameters.Value('MASTER_ORGANIZATION_ID') --13653352
1734: AND mdc.functional_area_id=7
1735: AND mdc.category_set_id = mic.category_set_id;