DBA Data[Home] [Help]

APPS.INV_ITEM_CATEGORY_OI dependencies on MTL_CATEGORY_SETS_B

Line 39: FROM mtl_category_sets_b

35:
36: CURSOR c_mult_item_flag (cp_cat_set_id NUMBER)
37: IS
38: SELECT mult_item_cat_assign_flag
39: FROM mtl_category_sets_b
40: WHERE category_set_id = cp_cat_set_id;
41:
42: l_category_id NUMBER := 0;
43: l_old_category_id NUMBER;

Line 258: from mtl_category_sets_b m

254: AND set_process_id = g_xset_id
255: AND ( i.organization_id = org_id OR all_org = l_All_Org )
256: AND (
257: (NOT EXISTS (select m.category_set_id
258: from mtl_category_sets_b m
259: where m.category_set_id = i.category_set_id )
260: )
261: OR
262: (NOT EXISTS (select m.category_id

Line 264: mtl_category_sets_b ms

260: )
261: OR
262: (NOT EXISTS (select m.category_id
263: from mtl_categories_b m,
264: mtl_category_sets_b ms
265: where m.category_id = i.category_id
266: and m.structure_id = ms.structure_id
267: and i.category_set_id = ms.category_set_id)
268: )

Line 735: FROM mtl_category_sets_b

731: BEGIN
732: -- bug 3500492
733: IF l_structure_id IS NULL THEN
734: SELECT structure_id INTO l_structure_id
735: FROM mtl_category_sets_b
736: WHERE category_set_id = l_category_set_id;
737: END IF;
738: SELECT category_id INTO l_category_id
739: FROM mtl_categories_b_kfv