DBA Data[Home] [Help]

APPS.PA_RLMI_RBS_MAP_PUB dependencies on MTL_ITEM_CATEGORIES

Line 682: ,MTL_ITEM_CATEGORIES cat

678: UPDATE pa_rbs_plans_in_tmp tmp
679: SET tmp.item_category_id = ( SELECT cat.CATEGORY_ID
680: FROM PA_RESOURCE_CLASSES_B classes
681: ,PA_PLAN_RES_DEFAULTS cls
682: ,MTL_ITEM_CATEGORIES cat
683: WHERE classes.RESOURCE_CLASS_CODE = 'MATERIAL_ITEMS'
684: AND cls.RESOURCE_CLASS_ID = classes.RESOURCE_CLASS_ID
685: AND cls.ITEM_CATEGORY_SET_ID = cat.CATEGORY_SET_ID
686: AND cat.ORGANIZATION_ID = tmp.organization_id

Line 1416: ,MTL_ITEM_CATEGORIES cat

1412: UPDATE pa_res_list_map_tmp1 tmp
1413: SET tmp.item_category_id = ( SELECT cat.CATEGORY_ID
1414: FROM PA_RESOURCE_CLASSES_B classes
1415: ,PA_PLAN_RES_DEFAULTS cls
1416: ,MTL_ITEM_CATEGORIES cat
1417: WHERE classes.RESOURCE_CLASS_CODE = 'MATERIAL_ITEMS'
1418: AND cls.RESOURCE_CLASS_ID = classes.RESOURCE_CLASS_ID
1419: AND cls.ITEM_CATEGORY_SET_ID = cat.CATEGORY_SET_ID
1420: AND cat.ORGANIZATION_ID = tmp.organization_id