APPS.AHL_PP_RESRC_REQUIRE_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 1266: -- To find the UOM_CODE from MTL_UNITS_OF_MEASURE table

1262: AHL_VISITS_B V, AHL_VISIT_TASKS_B T, AHL_WORKORDERS W
1263: WHERE W.VISIT_TASK_ID = T.VISIT_TASK_ID AND T.VISIT_ID = V.VISIT_ID
1264: AND W.VISIT_TASK_ID = x_id;
1265:
1266: -- To find the UOM_CODE from MTL_UNITS_OF_MEASURE table
1267: CURSOR c_UOM (x_name IN VARCHAR2) IS
1268: SELECT UOM_CODE
1269: FROM MTL_UNITS_OF_MEASURE
1270: WHERE UNIT_OF_MEASURE = x_name;

Line 1269: FROM MTL_UNITS_OF_MEASURE

1265:
1266: -- To find the UOM_CODE from MTL_UNITS_OF_MEASURE table
1267: CURSOR c_UOM (x_name IN VARCHAR2) IS
1268: SELECT UOM_CODE
1269: FROM MTL_UNITS_OF_MEASURE
1270: WHERE UNIT_OF_MEASURE = x_name;
1271: -- Get uom from bom resources
1272: CURSOR c_uom_code (x_id IN NUMBER)
1273: IS

Line 2379: -- To find the UOM_CODE from MTL_UNITS_OF_MEASURE table

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
2381: SELECT UOM_CODE
2382: FROM MTL_UNITS_OF_MEASURE
2383: WHERE UNIT_OF_MEASURE = x_name;

Line 2382: FROM MTL_UNITS_OF_MEASURE

2378:
2379: -- To find the UOM_CODE from MTL_UNITS_OF_MEASURE table
2380: CURSOR c_UOM (x_name IN VARCHAR2) IS
2381: SELECT UOM_CODE
2382: FROM MTL_UNITS_OF_MEASURE
2383: WHERE UNIT_OF_MEASURE = x_name;
2384:
2385: -- Get uom from bom resources
2386: CURSOR c_uom_code (x_id IN NUMBER)

Line 3320: MTL_UNITS_OF_MEASURE MUOM,

3316: MUOM.UNIT_OF_MEASURE UOM_NAME,
3317: AWO.workorder_id job_id
3318: FROM
3319: BOM_RESOURCES BOM,
3320: MTL_UNITS_OF_MEASURE MUOM,
3321: AHL_OPERATION_RESOURCES AOR,
3322: AHL_WORKORDER_OPERATIONS AWO
3323: WHERE
3324: AOR.OPERATION_RESOURCE_ID = x_id AND