DBA Data[Home] [Help]

APPS.PA_RLMI_RBS_MAP_PUB dependencies on MTL_ITEM_CATEGORIES

Line 491: ,MTL_ITEM_CATEGORIES cat

487: UPDATE pa_rbs_plans_in_tmp tmp
488: SET tmp.item_category_id = ( SELECT cat.CATEGORY_ID
489: FROM PA_RESOURCE_CLASSES_B classes
490: ,PA_PLAN_RES_DEFAULTS cls
491: ,MTL_ITEM_CATEGORIES cat
492: WHERE classes.RESOURCE_CLASS_CODE = 'MATERIAL_ITEMS'
493: AND cls.RESOURCE_CLASS_ID = classes.RESOURCE_CLASS_ID
494: AND cls.ITEM_CATEGORY_SET_ID = cat.CATEGORY_SET_ID
495: AND cat.ORGANIZATION_ID = tmp.organization_id

Line 1204: ,MTL_ITEM_CATEGORIES cat

1200: UPDATE pa_res_list_map_tmp1 tmp
1201: SET tmp.item_category_id = ( SELECT cat.CATEGORY_ID
1202: FROM PA_RESOURCE_CLASSES_B classes
1203: ,PA_PLAN_RES_DEFAULTS cls
1204: ,MTL_ITEM_CATEGORIES cat
1205: WHERE classes.RESOURCE_CLASS_CODE = 'MATERIAL_ITEMS'
1206: AND cls.RESOURCE_CLASS_ID = classes.RESOURCE_CLASS_ID
1207: AND cls.ITEM_CATEGORY_SET_ID = cat.CATEGORY_SET_ID
1208: AND cat.ORGANIZATION_ID = tmp.organization_id