DBA Data[Home] [Help]

APPS.CSF_PREVENTIVE_MAINTENANCE_PVT dependencies on MTL_CATEGORY_SETS_B

Line 186: mtl_category_sets_b mcsb

182: cursor c_item_category(p_organization_id number,p_inventory_item_id number) is
183: select mic.category_set_id,
184: mic.category_id
185: from mtl_item_categories mic,
186: mtl_category_sets_b mcsb
187: where mic.inventory_item_id = p_inventory_item_id
188: and mic.category_set_id = mcsb.category_set_id
189: and mcsb.mult_item_cat_assign_flag = 'N'
190: and mic.organization_id = p_organization_id