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_PP_RESRC_REQUIRE_PVT dependencies on BOM_DEPARTMENT_RESOURCES

Line 136: FROM BOM_RESOURCES BR, BOM_DEPARTMENT_RESOURCES BDR, AHL_WORKORDER_OPERATIONS_V AWV

132: BEGIN
133: IF (p_resource_code IS NOT NULL) THEN
134: SELECT DISTINCT(BR.RESOURCE_ID)
135: INTO x_resource_id
136: FROM BOM_RESOURCES BR, BOM_DEPARTMENT_RESOURCES BDR, AHL_WORKORDER_OPERATIONS_V AWV
137: WHERE BR.RESOURCE_ID = BDR.RESOURCE_ID AND BDR.DEPARTMENT_ID = AWV.DEPARTMENT_ID
138: AND AWV.WORKORDER_ID = p_workorder_id AND BR.RESOURCE_CODE = p_resource_code;
139: END IF;
140:

Line 1254: BOM_DEPARTMENT_RESOURCES

1250:
1251: -- To find the resource sequence nubmer from ahl_operation_resources
1252: CURSOR c_resources (x_id IN NUMBER) IS
1253: SELECT DEPARTMENT_ID FROM
1254: BOM_DEPARTMENT_RESOURCES
1255: WHERE RESOURCE_ID = x_id;
1256:
1257: -- To find the resource sequence nubmer from ahl_operation_resources
1258: CURSOR c_wo_dept (x_id IN NUMBER) IS

Line 2376: BOM_DEPARTMENT_RESOURCES

2372:
2373: -- To find the resource sequence nubmer from ahl_operation_resources
2374: CURSOR c_resources (x_id IN NUMBER) IS
2375: SELECT DEPARTMENT_ID FROM
2376: BOM_DEPARTMENT_RESOURCES
2377: WHERE RESOURCE_ID = x_id;
2378:
2379: -- To find the UOM_CODE from MTL_UNITS_OF_MEASURE table
2380: CURSOR c_UOM (x_name IN VARCHAR2) IS