APPS.AHL_UMP_BOM_PVT dependencies on BOM_DEPARTMENT_RESOURCES

Line 2196: FROM ahl_resource_mappings map, bom_department_resources bdr

2192:
2193: */
2194: /* SELECT bom_resource_id
2195: INTO p_x_consolidated_res_tbl(u).BOM_RESOURCE_ID
2196: FROM ahl_resource_mappings map, bom_department_resources bdr
2197: WHERE map.aso_resource_id = p_x_consolidated_res_tbl(u).CMRO_RESOURCE_ID
2198: AND bdr.department_id = p_maint_dept_id
2199: AND map.bom_resource_id = bdr.resource_id
2200: AND NVL(p_maint_dept_id, bdr.department_id) = bdr.department_id

Line 2225: FROM bom_department_resources

2221: AND NVL(map.department_id, p_maint_dept_id) = p_maint_dept_id;
2222: G_DEBUG_LINE_NUM := l_debug_module||': '||2877;
2223: SELECT 1
2224: INTO l_temp
2225: FROM bom_department_resources
2226: WHERE resource_id = p_x_consolidated_res_tbl(u).BOM_RESOURCE_ID
2227: AND department_id = p_maint_dept_id
2228: AND ROWNUM < 2;
2229: G_DEBUG_LINE_NUM := l_debug_module||': '||2878;

Line 2240: FROM ahl_resource_mappings map, bom_department_resources bdr

2236: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' p_maint_dept_id IS NULL');
2237:
2238: SELECT map.bom_resource_id, bdr.department_id
2239: INTO p_x_consolidated_res_tbl(u).BOM_RESOURCE_ID, p_x_consolidated_res_tbl(u).DEPARTMENT_ID
2240: FROM ahl_resource_mappings map, bom_department_resources bdr
2241: WHERE map.aso_resource_id = p_x_consolidated_res_tbl(u).CMRO_RESOURCE_ID
2242: AND map.bom_org_id = p_maint_org_id
2243: AND map.bom_resource_id = bdr.resource_id
2244: AND NVL(map.department_id,bdr.department_id) = bdr.department_id