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.WIP_EAM_WORKREQUEST_PVT dependencies on BOM_DEPARTMENTS

Line 1279: FROM BOM_DEPARTMENTS

1275: l_stmt_num := 240;
1276: BEGIN
1277: SELECT department_code
1278: INTO l_old_data
1279: FROM BOM_DEPARTMENTS
1280: WHERE department_id = l_old_owning_dept_id
1281: AND organization_id = p_org_id;
1282: EXCEPTION
1283: WHEN NO_DATA_FOUND THEN

Line 1290: FROM BOM_DEPARTMENTS

1286: l_stmt_num := 250;
1287: BEGIN
1288: SELECT department_code
1289: INTO l_new_data
1290: FROM BOM_DEPARTMENTS
1291: WHERE department_id = l_new_owning_dept_id
1292: AND organization_id = p_org_id;
1293: EXCEPTION
1294: WHEN NO_DATA_FOUND THEN

Line 2349: FROM BOM_DEPARTMENTS

2345: x_msg_data out NOCOPY VARCHAR2
2346: ) is
2347: BEGIN
2348: SELECT department_id INTO x_dept_id
2349: FROM BOM_DEPARTMENTS
2350: WHERE DEPARTMENT_CODE = p_dept_name
2351: And Organization_Id = p_org_id;
2352: EXCEPTION
2353: When others then

Line 2364: FROM BOM_DEPARTMENTS BD

2360: l_count number := 0;
2361: begin
2362: begin
2363: SELECT count(*) INTO l_count
2364: FROM BOM_DEPARTMENTS BD
2365: WHERE BD.ORGANIZATION_ID = p_organization_id
2366: AND BD.DEPARTMENT_ID = p_department_id
2367: AND nvl(BD.DISABLE_DATE,sysdate+1) > sysdate;
2368: exception