DBA Data[Home] [Help]

APPS.ENI_UPD_ASSGN dependencies on MTL_ITEM_CATEGORIES

Line 45: FROM MTL_ITEM_CATEGORIES C

41: AND CHILD_ID = NVL(p_old_category_id, -1)
42: AND ITEM_ASSGN_FLAG = 'Y'
43: AND CHILD_ID <> -1
44: AND NOT EXISTS (SELECT NULL
45: FROM MTL_ITEM_CATEGORIES C
46: WHERE C.CATEGORY_SET_ID = g_catset_id
47: AND C.CATEGORY_ID = B.CHILD_ID);
48:
49: l_rows_updated := l_rows_updated + SQL%ROWCOUNT;

Line 69: AND NOT EXISTS (SELECT NULL FROM MTL_ITEM_CATEGORIES C

65: /**Bug 4675565 Replaced with the query below
66: SELECT 1 INTO l_count
67: FROM MTL_SYSTEM_ITEMS_B IT
68: WHERE ROWNUM = 1
69: AND NOT EXISTS (SELECT NULL FROM MTL_ITEM_CATEGORIES C
70: WHERE C.CATEGORY_SET_ID = g_catset_id
71: AND C.INVENTORY_ITEM_ID = IT.INVENTORY_ITEM_ID
72: AND C.ORGANIZATION_ID = IT.ORGANIZATION_ID);*/
73: