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 261: from mtl_category_sets_b m

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

Line 267: mtl_category_sets_b ms

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

Line 743: FROM mtl_category_sets_b

739: BEGIN
740: -- bug 3500492
741: IF l_structure_id IS NULL THEN
742: SELECT structure_id INTO l_structure_id
743: FROM mtl_category_sets_b
744: WHERE category_set_id = l_category_set_id;
745: END IF;
746: SELECT category_id INTO l_category_id
747: FROM mtl_categories_b_kfv