eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_UMP_BOM_PVT dependencies on AHL_RESOURCE_MAPPINGS

Line 2187: FROM ahl_resource_mappings

2183:
2184: /* Commented out as per code review comments
2185: SELECT bom_resource_id
2186: INTO p_x_consolidated_res_tbl(u).BOM_RESOURCE_ID
2187: FROM ahl_resource_mappings
2188: WHERE aso_resource_id = p_x_consolidated_res_tbl(u).CMRO_RESOURCE_ID
2189: AND bom_org_id = p_maint_org_id
2190: AND NVL(department_id, p_maint_dept_id) = p_maint_dept_id; -- Deb: The NVL is used because department is optional for a bom resource...
2191: -- and in such a case where department is not there the bom resource needs to be picked.

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 2218: FROM ahl_resource_mappings map

2214: THEN
2215:
2216: SELECT bom_resource_id, p_maint_dept_id
2217: INTO p_x_consolidated_res_tbl(u).BOM_RESOURCE_ID, p_x_consolidated_res_tbl(u).DEPARTMENT_ID
2218: FROM ahl_resource_mappings map
2219: WHERE map.aso_resource_id = p_x_consolidated_res_tbl(u).CMRO_RESOURCE_ID
2220: AND map.bom_org_id = p_maint_org_id
2221: AND NVL(map.department_id, p_maint_dept_id) = p_maint_dept_id;
2222: G_DEBUG_LINE_NUM := l_debug_module||': '||2877;

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