DBA Data[Home] [Help]

APPS.AMS_MTL_CATG_LOADER_PVT dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 405: MTL_DEFAULT_CATEGORY_SETS D

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
409: AND D.FUNCTIONAL_AREA_ID = 11)