DBA Data[Home] [Help]

APPS.AMS_MTL_CATG_LOADER_PVT dependencies on MTL_ITEM_CATEGORIES

Line 404: FROM MTL_ITEM_CATEGORIES B,

400:
401: UPDATE AMS_ACT_PRODUCTS A
402: SET (A.CATEGORY_ID, A.CATEGORY_SET_ID) =
403: (SELECT B.CATEGORY_ID, B.CATEGORY_SET_ID
404: FROM MTL_ITEM_CATEGORIES B,
405: MTL_DEFAULT_CATEGORY_SETS D
406: WHERE B.INVENTORY_ITEM_ID = A.INVENTORY_ITEM_ID
407: AND B.ORGANIZATION_ID = A.ORGANIZATION_ID
408: AND D.CATEGORY_SET_ID = B.CATEGORY_SET_ID